Use commas for Excel CSV export
Change your system settings to use decimal separators
When you import customers to BillPro from a CSV file, the fields should be separated by commas.
If you use Excel to edit a CSV file and your country uses commas as decimal separators, when you save it as a CSV file, Excel may use a different separator, such as a semicolon.
To use commas as separators, go to your operating system settings and change the number format to use decimal points.
For example, for a Spanish computer running macOS, do these steps.
- Go to System Settings > General > Language & Region.
- Change the Number format to use a decimal point.
- You can also change the Date format to use a four-digit year to make it easier to format the date in Excel correctly.
Select the date and number format to use on the Mac
CSV format
If you are using Excel on a Mac, save your file in the MS-DOS Comma-separated Values file format
Updated 4 months ago