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 goes fine until the Text indicator appears at the beginning of a line of the CSV. Excel seems to delete them then with the consequence the colums are wronly separated.

I'll give 2 screenshots here aswell (a picture says it easier). The first is the CSV opened with Notepad (ASCII), the second is what Excel makes of it. The problem is in the red circle. Strange thing is that the text indicator stays when used further in the same line...

Does anybody know what I'm doing wrong?

BI & Data Analysis
excel

6 Replies

  • 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 :)
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 20, 2017

    Can you perhaps upload a sample csv and a sample workbook of the same CSV as you would need it to look after importing?

Resources