How to Change Excel CSV Format in Windows System

This is the example of the formatting problem on Excel when exporting the file from Backoffice. The data appearance will be in 1 cell and separated only by the comma (,).

CSV_Problem.png

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

  1. Open Windows menu on your PC/Laptop then click Control Panel.
    B.png
  2. Click Language & Region.
    C.png
  3. Change the region settings into English (United States).
  4. Change the short date format into dd-MMM-yy.
    D.png
  5. Click Apply then click OK.
  6. Repeat the export process in Backoffice.
  7. The Excel data will be changed to normal after you have changed the region format into United States.
    E.png

 

Was this article helpful?
45 out of 58 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