- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works only when I re-save the Excel file as CSV again and then import it to Power Query

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works only when I re-save the Excel file as CSV again and then import it to Power Query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey! It is 100% CSV file

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-13-2024 06:23 AM | |||
03-11-2024 12:37 PM | |||
08-27-2024 07:31 PM | |||
09-26-2022 08:12 AM | |||
06-05-2024 03:18 PM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |