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.

     

     

ihatebills's avatar
ihatebills
Copper Contributor
Jul 21, 2019
Since your data is already in excel use the text to column command use either comma (,) or quotation marks (") as separators.
Jack_Eijbers's avatar
Jack_Eijbers
Copper Contributor
Jul 22, 2019

ihatebills 

 

Thank you for the reply, i have done that and yes with some manipulating and editing the data, it kinda works (some of the merged data does not keep its formatting or formula) .. the work around is to right click on the merged data in Word and select "preserve formatting during updates"... i do a mail merge with about 25 of these csv files to 1000's of clients ..witch leave this as a poor solution.

 

it still bugs me that all works fine on one pc but not the other .. although both has the same setting and office 2013 versions..

my final solution is to try and have the same OS's on both pc's ..witch does not make scene to me at all sins this is a MS Office  issue..? and not Windows

  • Jack_Eijbers's avatar
    Jack_Eijbers
    Copper Contributor
    Jul 23, 2019

    Jack_Eijbers 

     

    Okay, well this is most interesting ... i have reinstalled Windows10 64bit , MS Excel (2013) is working fine now..??

    i still have no idea why or what caused the problem. Clearly Windows OS had or have a integration outcome in MS Office.

     

Resources