Parsing CSV file from Google Sheet export failed :(

How To
,
1

I’m tearing my hair out over using the CSV Parsing module on files that come from the Google Sheet CSV export.
The CSV files I need all come from the same source but sometimes columns are deleted or added.
Some work, mostly the smallest ones, others generate errors.
The most common is “Number of columns on line 1 does not match header”

I have attached a csv file which is problematic (I have many others)…

Many many thanks

Copie de Yfen_Matrice de Lancement_21_09_2024 - Matrice lancement FR (3).csv (3.1 KB)

1 Like
2

Hey @PaulEtok

What is the error you are recieving while doing action in Make??

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

3

Mainly :

Do you have an idea ?

4

I found the problem which came from the way the file was created…

1 Like