Importing a Customer List via CSV File

• If you have a customer list that you want to use in Shopify, then you can enter it into a customer CSV file, and then import the CSV file into your Shopify admin
• You can also use the customer CSV template to build a new customer list
• Shopify has a template CSV file, which you can download here

Description of the Customer CSV File

• The first line of your customer CSV must include the column headers. You can use the customer CSV template to help you to create your CSV file
• The Email column is required and must be present, but the value can be blank
• If the Email column is missing, then you receive an error when you import your CSV file
• CSV file headers are case sensitive, and their capitalization must match the examples that appear in the following table
• The Total Spent and Total Orders columns are not imported with customer details

Column	Description
First Name	The first name of the customer.
Last Name	The last name of the customer.
Email	The email address of the customer. This column is required, but the value can be blank.
Company	The name of the company that the 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. If you enter information into this column, then you must also enter the information for the Province Code.
Province Code	The province or state ISO code.
Country	The country the customer lives in.
Country Code	The country ISO code.
Zip	The postal or zip code for the customer's address.
Phone	The customer's phone number.
Accepts Email Marketing	Sets whether or not the customer agrees to subscribe to email marketing, such as a newsletter. Valid entries are yes or no.
Accepts SMS Marketing	Sets whether or not the customer agrees to subscribe to SMS marketing, such as discount offers. Valid entries are yes or no.
Total Spent	The customer's total amount spent. Valid entries must not have a currency symbol included. This column is not imported with customer details.
Total Orders	The customer's total number of orders. This column is not imported with customer details.
Tags	A comma-separated list of tags used to tag the customer (for example, tag1,tag2,tag3). Tags are not case sensitive.
Note	Additional information about the customer.
Tax Exempt	Indicates whether the customer is tax exempt. Valid entries are yes or no.

Notable Restrictions

File Size

• You can only import customer CSV files that are 1 MB or smaller
• To get around this, you can use multiple CSV files to import your customer profiles

Passwords

• When you use CSV files to import customer accounts from another online store, you need to invite your customers to create new passwords
• Otherwise, customers on the list can't register accounts using those emails
• Because passwords are encrypted, you can't migrate customer passwords from another online store
• Overwriting existing customer accounts with a CSV file import won’t require those accounts to be created again

Transferring Information

• Some of your customers' information can't be transferred between platforms
• Shopify only tracks what customers order and spend on your online store, and it isn't possible to import customer data for orders placed and money spent on another store or ecommerce platform
• You can’t edit the Total Spent and Total Orders columns because they represent what that customer has spent and ordered from your online store