All Collections
How to Fix CSV Files Separating Into Columns (Mac OS)
How to Fix CSV Files Separating Into Columns (Mac OS)

Change your Mac OS Region to solve CSV bad format

Ryandi Ibrahim avatar
Written by Ryandi Ibrahim
Updated over a week ago

Currently, Dealpos supports to export and import of data using CSV files. If in case you experience a messy CSV file format display, you can follow the steps below to fix up your CSV display.

If you export our reports into .csv (Excel Files) using the Report menu in the DealPOS application or when you want to Import a Product Using a CSV File. Sometimes, after opening the .csv file that is exported from DealPOS, the file's appearance can be messy or irregular, making it extremely difficult to read or identify the data it contains. The most common problem related to this is due to Bad Format.

Step 1. Open System Preferences Menu

Select Language & Region Option.

Open System Preferences

Step 2. Open Region Option, then Select America (United States)

Choose Region - United States

Step 3. Save Configuration

Your display should look like this :

Save Configuration

Step 4. Try to Restart the System

You need to restart your computer afterward.

Restart the System

Related Articles

Did this answer your question?