Extracting data from csv file

[ISBS_ROBOT]

Hello all,
I have a file of CSV format but when I use Read CSV activity I’m getting an error like “Read CSV: The CSV file format for Output File\data.csv is invalid. Line 2 contains more values than the header line.” How to remove this error and get the data in excel.
Please help me with this issue.

[Yoichi]

Hi,

Can you try UseExcelFile activity as the following?

Then use ReadRange activity or ForEachExcelRow activity etc.

Regards,

[supermanPunch (Arpan)]

Hi @ISBS_ROBOT ,

Maybe you could also refer the below post :

The CSV File Format For <file> Is Invalid. Line 2 Contains More Values Than The Header Line

Using Read CSV File activity returns the error "The CSV file format for is invalid. Line 2 contains more values than the header line." There are two possible approaches: Approach #1: Open CSV in notepad or Notepad++. Check the delimiter being used. Pass the same delimiter in the Delimiter property of the "Read CSV" activity. Approach #2: Replace the "Read CSV" activity, with a "Read Text file" activity and use the .csv file as input and set a string variable for output. Use a "Generate …