QuickSight Cant parse my csv file

Question

hello, I've been trying to get QuickSight to parse one CSV document I have, and it's not working. It keeps telling me that the format is not supported and the file cant be parsed although it's a normal CSV file. Any suggestions regarding this?

Answer

There is no real "normal CSV" file format. There are many possible issues with CSV mainly around strings that can be quoted (") or can include commas (,) in the text. There can also be issues with missing values, line breaks, headers, encoding, etc.

Try to simplify the CSV file by removing various columns (using Excel, for example) and rows to try and identify where your CSV is not what expected by QuickSight.

QuickSight Cant parse my csv file

Contenuto pertinente