Forum Discussion
CSV not parsed into columns despite Get Data delimiter set
I found a solution.
Another function in the same menu - Text to Columns.
This one processed the comma separator correctly. Hurray.
Yes, I see. On preview stage Excel make some guesses how to transform your data, not always correct ones. It's always better to give it direct instructions of what to do and not rely on guesses.
Other words, query your initial file, click on Transform and directly ask Excel to split your column by semicolons. Steps as in my previous post. When it works.
I repeat here the file which do that.
Hi.. i'am having this same issue, but with an interesting "effect" . Im using office 2010 64bit windows10. I have tried all the suggestions listed here and spent hours searching for solutions on google (and tried most of them).. i even uninstalled office 2010 and upgraded to office 2013 64bit but still the problem persist. If i open the file .csv file on a different pc ..( with exactly the same office 2013 ) everything works fine.. so i went through .. patches ,, Add-on's .. every setting i could find.. they are the same.. between the two pc's the only difference is the one pc is on win7 64bit and the other win10.. the region settings are the same in both pc's ..??
I would appreciate so help or advice.
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.
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
- Since your data is already in excel use the text to column command use either comma (,) or quotation marks (") as separators.
