Remove first 6 rows in csv file

Like (0) Share

Report

Posted on 14 Mar 2024 12:52:03 by Nuems

Hi,

I get sent a csv file daily in my inbox and I would like to find a way to automate the removal of the first 6 lines of that csv file (see attached). So that the first row is the columns: Day, Ad Exchange etc.

Is there a way to do this?

p.s. Had to save the attachment as .xlsx due to limitations of attaching .csv files in the forums

Vistar_Daily_Extr...

All responses (1)

Answers (0)

Andrew_J 1,962 Super User 2025 Season 1 on 14 Mar 2024 at 15:54:14

Like (0)

Report

Re: Remove first 6 rows in csv file

@Nuems

I know what you want to do and that is to get the header row you need from row 7 throught to whatever.

You need a column header which is a key value in Excel. In Power Automate you need an Excel table which will have a column header. Without table and columns you can't process the excel sheet in Power Automate. Therefore rows I do not think you can delete rows one through six.

However look at the below:

http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

If I am reading the Extra Tips 2 correctly then it could be possible but I have not tried any of this out. So do not know if it will work.

If this does not work and the file is in a standard format then could you not look at training AI to delete the frist six lines.

Or what about scripts

https://powerusers.microsoft.com/t5/Building-Flows/How-to-remove-top-few-lines-of-an-excel-file-that-does-not-have/td-p/2252124

Maybe you have seen the above already.

Regards,

Andrew