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