File upload error details

[luis_ca]

Hi, i am getting the below errors while trying to import a CSV file that i have only added 1 column for the month to have date filters.

There was an error in processing your upload.

This file has processing errors.

Invalid CSV format at row 1.

Every file you upload to a given data set must have exactly the same structure, with the same fields in the same order. The "invalid CSV format" error can be caused by column headers in the file that are improperly formatted, in the wrong order, or missing.

The previous version does not have a column month and works perfectly fine.

[GavinW]

I think the error message is telling you that adding this month column has changed the expected format of the data. You could perhaps validate this by creating a new dataset using this new version of the CSV. If it works for a new dataset, then the error is not due to an issue with the CSV formatting, but because the original dataset can only accept files with the exact same columns in the same order, as the error says.

[luis_ca]

Hey Gavin, happy new year and thanks for taking the time in answering this.

Indeed I have created a data set and I still have the error, sometimes the error reference row 1, sometime row 2, are there any CSV formatting that I should consider to avoid this error or decrease the risk of having them?Thanks

[GavinW]

Ok, that seems to suggest that there is (also?) a problem with the CSV file itself. If the data is not sensitive, I might test the CSV file in a CSV validator like this just to make sure that it is being exported correctly from whatever the source is. You could also try uploading it to Google Sheets or Excel and then re-exporting it as CSV.