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.
Thank you very much. I saved it as CSV MS-DOS and was able to import it. I don't know why, but with each new release of Office, Microsoft makes it harder and harder to use their programs. I never had this problem with older versions of Excel.
I thought Excel parsed the file correctly, but it looks like only some of data was parsed. The Data is row 4 is all contained in A4
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.
