Importing data and exporting data are both very in-demand, especially when it is customer data. You can either pull all of the data manually or do an automated data export to Google Sheets (a spreadsheet program just like Excel).
Here is a simple method for exporting a customer email list and other details. If you are looking to safely back up your store data, be sure to check our guide on backing up your Shopify store. Check this guide if you’re looking to import customers to Shopify.
Recommended Shopify app (built by us)
DDA – Digital Downloads
Digital product delivery on Shopify + file protection.
This includes unique features no other app has, such as email tracking, fraud protection, file protection, IP address download limits (stop users from sharing the files with others) and much more.
Notes on exporting customer lists
- There are some essential things to note when exporting the email list from your Shopify store. You need to use CSV files with a Shopify format to export customers from your source store. Every source cart has its own way in which you should export data.
- CSV file format regulations must be kept to as incorrect formatting will lead to file import failures.
- Some requirements for customer CSV files include an email column, the first line, headers, a customer’s phone number, and other information. If you want to export all customer information, your CSV files must be in a UTF-8 format.
- CSV stands for comma-separated values. This type of file can be handy in multiple ways. However, they can only be 1 MB in size. If you export up to about 50 customers, your browser will download the CSV files, but if you export more than 50, the exported CSV files will be sent via email.
How to export customer emails from Shopify
There are various ways to export your email list. You could download an app from the Shopify app store or follow this simple method:
Step 1: Go to your Shopify dashboard
First, head to your dashboard to see what you need to export.
Step 2: Go to “Customers”
Then go to Shopify > Customers to see a list and details about your existing customers.
Step 3: Select the customers you want to export
Next, you will need to select the customers you want by using the checkbox on the left of the list. You can export every customer if you want by selecting the “Select all 50+ customers” option after selecting a few of the customers.
If you only want to export data from specific people on your customer list, then choose those people only. Select all of the customers you’d like to export and the CSV file format. You can choose from various export options.
Step 4: Select the ‘Export’ button
Once you have selected all of your customers and data on the online store, click “Export customers“.
Now you will be prompted with an “Export customers” box. This is where you can choose the final settings to export. Usually, the default is the most applicable, but that is up to you. once you are ready, click the green “Export customers” button.
What to remember for CSV files
The very first line of the customer CSV must have column headers and an email column is required. CSV files tend to be case-sensitive.
The total orders and total spent columns will not be exported.
Can I apply filters before exporting customer emails from Shopify?
Yes, you can apply filters to your customer list before exporting it from Shopify. This allows you to export a specific segment of your customer list based on criteria like their purchase history, location, and more.
In what format does Shopify export customer emails?
Shopify exports customer emails in a CSV (Comma-Separated Values) file. This file can be opened with any spreadsheet software like Microsoft Excel or Google Sheets.
Can I export all customer data from Shopify, not just emails?
Yes, when you export your customer list from Shopify, it includes all customer data, not just emails. This includes information like the customer’s name, address, and purchase history.
Can I import customer data into Shopify?
Yes, Shopify allows you to import customer data from a CSV file. This can be useful if you’re migrating your store from another platform to Shopify.
Exporting data using a plain CSV file is relatively easy, as long as you follow all steps correctly and stick to the requirements. Exporting emails helps prevent duplicate email addresses and helps with email marketing. If you get stuck, go check out Shopify’s guide or drop a comment below.