You can export your customer data and save it as a CSV file. This means that you receive a tabular overview of all data that you can open via an application like Microsoft Excel.
You simply need to click on the button 'More' and then on the option 'Export customers'. Either the download starts automatically or a popup appears in which the storage location can be selected. Click on 'Save' to start the download of the CSV file.
Double-click on the exported document if you wish to open it via excel. Excel will therefore open. The list is already usable. But if something went wrong, you will find out here how to prepare the CSV file manually.
Hint: In case you use Apple you can open the document via the application “Numbers”.
Select column “A” to format the data per column. Afterwards, you have to click on the tabs “Data” and “Text in columns”. A new window will open where you choose the option “separated”. You will then get to the next page.
The next step is to change the delimiter to a “comma”. Through the button “Next” you will reach the last page where you only have to press “Finish”.
The document consists of the following information:
- First name
- Customer number
- Email address
- ZIP code
- Newsletter subscription
- Member since
If you would like to integrate further filters to search for, e.g. certain groups or newsletter subscription, select all columns in row 1 that should be filtered. The filter will be active if you click on the button “Filter” in “Data”.
Click here to find out more about creating a list of all the email addresses of your new customers.