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?

I think I've just succeeded in attaching the aforementioned .csv file, hopefully, with this reply:

thank you so much for your reply! the issue is that we need to regularly update the ORIGINAL file, so that solution sadly does not apply in this case:/

Attachment 860543

Attachment 860543

here's an image of what the file looks like, btw:

hey TMS, thank you so much for your reply!! The issue is that we need to frequently update the original file, and not change the delimeter of the file itself, nor the file format (it should stay as a CSV), as it then needs to be used as part of a java program - so importing it into a new excel file is not an option. Also, note that we've changed the regional setting of the computer so that the system delimeter is comma ( , ) rather than semicolon now, but for some reason that doesn't help either...