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 comma separated.

If you are using Excel to edit a CSV file, and your country uses commas as decimal separators, when you save as a CSV file, Excel may use a different separator, such as a semicolon.

To use commas as separators, in your operating system settings, change the number format to use decimal points.

For example, for a Spanish computer running macOS, do these steps.

  1. Go to System Settings > General > Language & Region.
  2. Change the Number format to use a decimal point.
  3. You can also change the Date format to use a four-digit year to make it easier to correctly format the date in Excel.
Select the date and number format to use on the Mac

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


Recommended reading

Import customers from a CSV file