By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

QuickSight Cant parse my csv file

0

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?

Topics
AnalyticsMedia ServicesDatabaseMachine Learning & AI
Tags
AnalyticsAWS Elemental MediaConvertAmazon QuickSightExtract Transform & Load DataAmazon Comprehend
Language
English
rePost-User-5988827
asked 3 years ago398 views
1 Answer
0

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.

MLGuy
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content