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...

BI & Data Analysis

excel

Deleted

Jan 20, 2017

Hi 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

Copper Contributor

Jan 20, 2017

Thanks Mourad! That does the trick for now!
Nice one :)

Forum Discussion

CSV to Colums

Resources