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 (,).

CSV_Problem.png 

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

  1. Open your System Preferences and click on Language & Region.
    Screen_Shot_2018-11-06_at_12.07.53_PM.png

  2. Change the Region to United States.
    Screen_Shot_2018-11-06_at_1.09.02_PM.png

  3. Restart your Mac for the setting to be applied.
Was this article helpful?
2 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Still Have Questions?

Our customer care team is here for you!

Contact Us