How to Change Excel CSV Format in Mac

This is the example of the formatting problem on Excel when exporting the file from Backoffice. The data may appear in 1 cell and separated only by the commas (,).

 

These are the steps you can do to change the Excel format:

1. Open your System Preferences and click on Language & Region.
   
   
   
2. Change the Region to United States.
   
   
   
3. Restart your Mac for the setting to be applied.