I'm trying to insert a new row with content as header and description inside a CSV or Excel sheet using the data extraction.
I'm able to insert data as columns, Is it possible to insert a row using a script?
Yes, this is trivial with scripting, e.g. execCommand("sed -i '1s/^/<added text>/'").
The data extraction activity supports column headers though, so this should be unnecessary.