Forum Discussion
Jan Borger
Jan 20, 2017Copper Contributor
CSV to Colums
Hi, I hope I'm at the right place for this but I am having trouble with importing CSVs. Here are the details: - separator: , - Text indicator: " Everything g...
Deleted
Jan 20, 2017Hi Jan Borger,
I can't tell you what's going wrong with the import assistant, but I can make you the suggestion to use PowerQuery for importing the CSV-file. You have so much more possibilities in PowerQuery.
In an English version of Excel 2016, you can find PowerQuery in the Data Tab and Get & Transform section. Please see the screenshot. Then choose your CSV-file and you get a preview dialogue where you can set some parameters. If you click on the Edit button, you'll reach the PowerQuery Editor with more options.
Best,
Mourad
Jan Borger
Jan 20, 2017Copper Contributor
Thanks Mourad! That does the trick for now!
Nice one :)
Nice one :)