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?