Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Issue with CSV Import

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?

Tips and Tricks

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

3 Replies

Anonymous
Not applicable
3 years ago
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
  Not applicable
  3 years ago
  Hey! It is 100% CSV file
Anonymous
Not applicable
3 years ago
It works only when I re-save the Excel file as CSV again and then import it to Power Query