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.

     

     

Filip Vrlik's avatar
Filip Vrlik
Copper Contributor
Sep 05, 2018
This exactly does not work
which puzzles me.

Thank you for response though!
Scott Rogerson's avatar
Scott Rogerson
Copper Contributor
Sep 05, 2018

I don't think I am answering this any different but in Excel 2016 did you go to the Data tab, then select From Text/CSV?

 

Then just select the CSV file you want. 

 

  • Filip Vrlik's avatar
    Filip Vrlik
    Copper Contributor
    Sep 06, 2018

    That's what I did (also Sergei suggested) but did not work :(

Resources