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.
CannonAli , not sure why such effect. If open your csv file in Excel and save as CSV UTF-8 or CSV MS-DOS in both cases such file is imported correctly by default
At the same time your initial file is also could be imported correctly, but it's required few more steps
From here
click Transform Data, after that Split Column by Delimeter
Select Semicolon, Ok
Close and load to back to Excel with desired options
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.