Importing and exporting customer lists
If you have a customer list that you want to use in Shopify, you can enter it into a customer CSV file and then import it in your Shopify admin. You can also use the customer CSV template to build a new customer list.
CSV stands for comma-separated values, a file format (.csv) for spreadsheets. You can use CSV files to import and export products, customers, orders (export only), and discounts (export only).
They can be useful in many situations, such as when you are switching to Shopify from another ecommerce platform, need to import a list of customer accounts, or want to upload products by using a spreadsheet.
CSV files might seem intimidating at first, but after you understand their format and how they work, you might decide to use them for a variety of tasks.
Your CSV files must use UTF-8 encoding.
In a CSV file, each entry represents a cell in a spreadsheet, each line represents a new row, and each comma indicates where one entry ends and another one begins.
For example, the entries in this customer CSV file:
look like this in a spreadsheet program:
Import CSV files into Google Sheets
When you export a CSV file from your Shopify admin, it opens as a .csv file in your computer's native text editor. You can also use an alternative text editor, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead.
To import a CSV in to Google Sheets:
On the Google Sheets page, click Blank in the Start a new spreadsheet section:
From the Untitled Spreadsheet page, go to File > Import...:
Locate and select the CSV file that you want to edit.
In the Import file dialog, select your preferred options under the Import action, Separator character, and Convert text to numbers and dates sections.
Your CSV will look something like this after you've uploaded it:
From here you can edit your CSV. When you are done, you can export it from Google Sheets as a .csv file.
Export CSV files using Google Sheets
When you are done viewing or editing your CSV file in Google Sheets, you can export it as a .csv file to your computer.
To export your CSV file:
From your CSV spreadsheet page, go to File > Download as > Comma-separated values (.csv, current sheet):
Your CSV file will appear in your downloads folder.
Customer CSV template
If you import the blank customer CSV template without adding any new customers to it, then it creates two default customer records in your store:
- Jane Doe is an example of a customer with only an email address
- John Doe is an example of an customer with an email address and a shipping address.
The customer CSV template file will look something like this:
Import existing customers using the customer CSV
Shopify provides a template file that you can use as a guide to create your own customer list to import into your store. You can download and view our customer CSV template.
Shopify's ability to import customer accounts from other platforms is limited. If you are trying to import customer email lists from another platform to Shopify, then see here for more information.
To import a customer CSV:
From your Shopify admin, click Customers.
Click Import customers:
In the Import Customers By CSV dialog, click Choose file, and then select your customer CSV file:
If you want to update any existing customers, then click Overwrite existing customers that have the same email.
Click Import customers:
The customers whose records you've added to the CSV will appear on the Customers page in your Shopify admin.
Export existing customers to a CSV file
You can export a CSV file of all your store's customers and their details, or a filtered list of customers and their details.
Exported CSV files can be opened in a spreadsheet application like Excel, Numbers, or Google Sheets, or used to connect your Shopify store with a third-party CRM system.
If you export up to one page of customers (up to 50 customers), then the CSV file is downloaded by your browser. If you export more than one page of customers (51 or more customers), then the CSV file is emailed to you and the Shopify account owner.
To export customers:
From your Shopify admin, go to Customers.
Click one of the following export options:
- Current page to export the customers showing in your store admin
- All customers to export all your store's customers
- Selected customer to export customers you have selected
- Current Search to export a filtered list of customers.
Select which file format you want to export:
- Select CSV for Excel, Numbers, and other spreadsheet programs if you plan to use a spreadsheet program with your customer CSV.
- Select Plain CSV file if you plan to use a plain-text editor with your customer CSV.
Click Export customers:
Format your customer CSV file
The first line of your customer CSV must include all the headers listed below, which are included in the customer CSV template.
|First Name||The first name of the customer.|
|Last Name||The last name of the customer.|
|The email address of the customer.|
|Company||The name of the company that customer uses if applicable.|
|Address1||The first line of the customer's address.|
|Address2||The second line of the customer's address, if necessary.|
|City||The city the customer lives in.|
|Province||The province or state the customer lives in. You must also enter the Province Code if this field is completed.|
|Province Code||The province or state ISO code. Shopify uses ISO alpha 2 codes.|
|Country||The country the customer lives in.|
|Country Code||The country ISO code.Shopify uses ISO alpha 2 codes.|
|Zip||The postal or zip code for the customer's address.|
|Phone||The customer's phone number.|
|Accepts Marketing||Sets whether or not the customer agrees to subscribe to email marketing, such as a newsletter. Valid entries are
|Total Spent||The customer's total amount spent. Valid entries must not have a currency symbol included. This field will not be imported with customer details.|
|Total Orders||The customer's total number of orders. This field will not be imported with customer details.|
|Tags||A comma-separated list of tags used to tag the customer (for example,
|Note||Additional information about the customer.|
|Tax Exempt||Indicates if the customer is tax exempt.|
When importing customer information, your CSV file must be in UTF-8 format. Most spreadsheet applications have the ability to save CSV files in UTF-8 format with the Save As... or Export command, depending on the program.
Use a text editor to edit your customer CSV file
If you don't have a spreadsheet program, then you can edit CSV files using a text editor.
To format your CSV file in a text editor:
- Column headers must be separated by commas (for example,
First Name,Last Name,Email,Company,Address1).
- The list of tags must be wrapped in quotation marks (for example,
- Different records must be separated by line breaks.