Forum Discussion

Jan Borger's avatar
Jan Borger
Copper Contributor
Jan 20, 2017

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
Anonymous's avatar
Anonymous
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's avatar
    Jan Borger
    Copper Contributor
    Jan 20, 2017
    Thanks Mourad! That does the trick for now!
    Nice one :)

Resources