Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

Shopify customer CSV template: free download and how to import customers

Free Shopify customer CSV template with every column Bulkvane imports, two example customers, the rules for phones and addresses, and how to import it safely.

The Bulkvane teamPublished Last updated 2 min read

Download the template

One row per customer, with every customer column Bulkvane imports and two example customers, one in Canada and one in the United States.

Download the customer CSV template

Free, no sign-up. Delete the example rows before you import.

The columns

ID, Email, First Name, Last Name, Phone, Note, Tags, Tax Exempt, Company, Address 1, Address 2, City, Province Code, Country Code, Zip, Address Phone.

A customer export also includes Email Marketing, SMS Marketing, Orders Count, Amount Spent, Created At and Updated At for reference. They're read-only, so they're not in the template. Shopify's own customer CSV headers work too.

Rules that prevent failed rows

  • Email is how customers are matched when there's no ID, so use one email per customer.
  • Phone numbers need a country code: +1 for Canada and the United States, for example +1 416 … or +1 212 ….
  • Province Code and Country Code are the two-letter codes: ON, BC, QC; NY, CA, TX; CA for Canada and US for the United States. Country names such as “Canada” are converted to codes for you.
  • Tags are separated by commas; the cell is the customer's full tag list.

Import it

  1. Open Import in Bulkvane, choose Customers and add the file.
  2. Choose Create and update to add new customers and update existing ones by email.
  3. Click Check file: every customer that will be created or changed is listed, field by field.
  4. Apply. If something's wrong, undo the import for 30 days.

Need the product template instead? See the product CSV template.

Frequently asked questions

What happens if a customer's email is already in my store?

That customer is updated instead of a new one being created. Customers are matched by ID first, then by email.

What format do phone numbers need?

International format with the country code, for example +1 212 … for the United States or +351 912 345 678 for Portugal.

Can I import email marketing consent?

Not with Bulkvane. Consent has to be given by the customer, so it's exported for reference only, which is also what anti-spam laws such as Canada's CASL expect.

Do Shopify's own customer CSV headers work?

Yes. Bulkvane reads Shopify's customer CSV headers as well as its own, and converts country names such as Canada to their codes.

Related guides

How to bulk edit Shopify productsFree CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free