Issue with CSV Import

[Anonymous]

Hey everyone!

Trying to import CSV from Sharepoint Folder and I get the follwoing picture

The table itself contains columns, headers and etc. The most interesing thing is that the rest CSV files from the same folder work correctly

How to make Power Query Editor read the data properly? 

[Anonymous · Accepted solution]

It works only when I re-save the Excel file as CSV again and then import it to Power Query

[Daryl-Lynch-Bzy]

Hi @Anonymous - I don't think the file that you are trying to import is CSV.  It is possible that it is XLSX file or ODS version of an Excel file (Differences between the OpenDocument Spreadsheet (.ods) format and the Excel for Windows (.xlsx) format - Microsoft Support).

[Anonymous]

Hey! It is 100% CSV file