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: how to use data hosted on SharePoint?asked 8 months ago
Quicksight export more than 1 million rows data to multiple csvasked 6 months ago
How to use AWS Tranlsation if I only have plain text, not CSV, not Memory files?asked 3 months ago
How to escape a comma in a csv file in AWS Glue?Accepted AnswerMODERATORasked 3 years ago
Accessing via API data of type FILE in QuickSightasked a month ago
Quicksight Athena - analysis error: "HIVE_UNSUPPORTED_FORMAT: Unable to create input format"asked 2 months ago
Uploading CSV file keeps failing to import usersasked 11 days ago
How can i import an .xlsx File located in S3 Bucket in my quicksight?asked 6 months ago
Quicksight not able to ingest dataset bigger than 1GB at a timeasked 6 months ago
QuickSight Cant parse my csv fileasked 2 months ago