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

Relevant questions

QuickSight: how to use data hosted on SharePoint?

Quicksight export more than 1 million rows data to multiple csv

How to use AWS Tranlsation if I only have plain text, not CSV, not Memory files?

How to escape a comma in a csv file in AWS Glue?

Accessing via API data of type FILE in QuickSight

Quicksight Athena - analysis error: "HIVE_UNSUPPORTED_FORMAT: Unable to create input format"

Uploading CSV file keeps failing to import users

How can i import an .xlsx File located in S3 Bucket in my quicksight?

Quicksight not able to ingest dataset bigger than 1GB at a time