Export customers

You can export customers from the customer overview screen by selecting import/export from the filters. Then click “export customers” and a CSV file will be downloaded.

CSV file

The following information is exported:

  • Customer number
  • Name
  • Contact
  • E-mail
  • Phone number
  • Cellphone number
  • VAT number
  • Billing Address: Address line 1
  • Billing Address: Address line 2
  • Billing Address: Zip code
  • Billing Address: Municipality
  • Billing Address: County
  • Billing Address: Country
  • Delivery address: Name
  • Delivery address: Address line 1
  • Delivery address: Address line 2
  • Delivery address: Zip code
  • Delivery address: Municipality
  • Delivery address: County
  • Delivery address: Country

Make CSV file readable

All data will be exported as a single column. To make sure you can read the file, convert the file to a regular Excel spreadsheet. There are multiple ways to do this:

  • In the CSV file, click “data” and then “text to columns”. Make sure to select “comma” as the separator.
  • In the CSV file, click “data” and then “from text/CSV”. Select the CSV file that needs to be converted and check the separator.
  • Use an online conversion tool to convert the CSV file into a readable Excel file.

Of bekijk onze uitgebreide walkthrough video waarin we stap voor stap door de applicatie gaan!