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.
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.
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.
Marketing consent
Import it
- Open Import in Bulkvane, choose Customers and add the file.
- Choose Create and update to add new customers and update existing ones by email.
- Click Check file: every customer that will be created or changed is listed, field by field.
- 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 products in Shopify (2026 guide, 3 methods)
Bulk edit Shopify product data three ways (the admin bulk editor, a CSV import or an app), with steps for prices, tags, SEO, metafields, variants and stock.
· 14 min read
Import supplier CSV files into Shopify over FTP or SFTP
A practical guide to importing supplier CSV files via FTP, FTPS or SFTP into Shopify: SKUs, inventory locations, preview and safe updates.
· 2 min read
How to schedule Shopify product exports daily or weekly
Set up recurring Shopify CSV or Excel exports with saved templates, daily or weekly schedules, job history and completion notifications.
· 2 min read
How to bulk edit Shopify productsFree CSV templatesBrowse the help center
Preview every change.Undo any import for 30 days.
Install free