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.

     

     

StudentFI's avatar
StudentFI
Copper Contributor
Oct 02, 2019

Hi!

 

I'm facing a bit different problem with my .csv file. I write on my excel .csv file with another application. I'm writing on string format and can separate string to different columns with "," symbol. I would like to know how could I separate the string to different rows? What is the symbol for this one? Only tips I could find is if I would open it with this editor thing, but as I said this is not possible for me. Also could change my settings on this computer control panel but would prefer not to do that one either.

 

Thank you for your replies and please ask if I'm representing my problem unclear.

 

Filip Vrlik 

Resources