If you export our reports into .csv (Excel Files) using the Report menu in the DealPOS application or when you want to Import Product with CSV File. Sometimes, after open the .csv file that 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. We will explain how to fix the Bad Format display in .csv files, please read the explanation below:
Step 1. Open Control Panel, then Select Clock, Language & Region
Step 2. Click Region - Format 'English United States - Apply
Step 3. Click Additional Settings, then Click Ok
Notes :
Please make sure the Decimal symbol is already selected with point ( . ) and the List Separation selected with comma ( , ). This will prevent your excel from random format and additional triple zero (000).
Before
After
[Tutorial Video] Fix CSV Bad Format in Windows
You might also like to read this article :
If you experience minor issues in using DealPOS, there is a possibility that the issue is due to the cache in the browser. You can try to clear the cache according to the browser you are using : Google Chrome | Mozilla | Safari
If you can't access your DealPOS page, maybe you can try using Browsec VPN for a while : How to Download and Enable Browsec VPN on Browser
If you have a similar problem on a PC using Mac OS, you can check this article: How to Solve Bad Format in CSV File (Mac OS)