Forum Discussion
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 ...
It works only when I re-save the Excel file as CSV again and then import it to Power Query
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).
Hey! It is 100% CSV file