Forum Discussion
Import CSV change
In general you may allow legacy text import wizard in options
which was the only option in previous Excel versions, and use it. But both this wizard and Power Query give exactly the same result, they recognize all data columns. Perhaps it's something else with your file, better if you submit it as txt file, not as the part of the text within the post, which is actually HTML.
Hi thanks for the response.
Hadn't used that option before.
While it does allow me to deselect the top rows when I "delete" them
the import is still limited to the 2 columns.
Am I missing a stage?
In general you may allow legacy text import wizard in options
which was the only option in previous Excel versions, and use it. But both this wizard and Power Query give exactly the same result, they recognize all data columns. Perhaps it's something else with your file, better if you submit it as txt file, not as the part of the text within the post, which is actually HTML.
- Must be something strange about the file
See attached.