Forum Discussion
Microsoft Excel not formatting CSV file correctly
We are trying to open a CSV file with Microsoft Excel (2013 and 2016) on Windows Desktop. Unfortunately, excel is not formatting the file correctly: each row is in a new row as it should be, but all of the columns are in the same cell, and the values are displayed seperated by a comma( , ).
The CSV file, as said above is separated by commas. Our computer's region is Turkey, which means semicolon ( ; ) separation by default; but following advice here and elsewhere we have changed our delimiter setting to comma in the region settings. However, the file is still not formatted correctly for some reason. It is not possible to create a new file and import the CSV there, as the original CSV file needs to be modified - and quite regularly. The issue persists on both our computers (one with Excel 2013 and the other Excel 2016). (If this is useful context, the file itself was created on the latest model MacBook Pro, local to the UK (the computer itself has 360, though the file was created using a java program without any Office programs involved)). How can we resolve this?
Can you provide a sample of this. You can just include a dummy information so it is easy to understand your requests.
Kind Regards,
Select the cells and click on Data, then Text to Column as shown below
Then choose Delimiter. Click on Next and select Comma on the next page, it will show you the preview of the solution.
Click on finish and you should have the data properly arranged in the columns.
Cheers
