Forum Discussion

Filip Vrlik's avatar
Filip Vrlik
Copper Contributor
Sep 04, 2018
Solved

CSV not parsed into columns despite Get Data delimiter set

My Excel does not parse CSV file correctly. The separator is comma (,). Even if I use the Get Data tool and set the delimiter there to be COMMA I still get everything in one column. Obviously, I want...
excel
office 365
  • Filip Vrlik's avatar
    Filip Vrlik
    Sep 06, 2018

    I found a solution.

     

    Another function in the same menu - Text to Columns.

    This one processed the comma separator correctly. Hurray.

     

     

CannonAli's avatar
CannonAli
Copper Contributor
Jun 04, 2019

SergeiBaklan 

 

Hi,

I'm having a similar problem, but I can post my .CSV file.  These are the steps I have tried:

 

1. I tried to open the comma-delimited CSV file directly from File Explorer

2. I opened Excel, then tried to open the CSV file

3. I tried to use the Data/Get from CSV option

4. I opened the file in a text editor and replaced all the commas with semi colons

5. I created a blank text file, copy and pasted the text from the CSV file, saved the renamed the file

 

In every case, when the connector screen pops up, changing the delimiter type does almost nothing.  I think one of them splits the data into 3 columns, but my file is many columns wide.

 

I'm using Windows 10 with Excel for Office 365

CannonAli's avatar
CannonAli
Copper Contributor
Jun 04, 2019

Here is a screenshot from the connector: