Import customers from a file
Add customers from a CSV file, without creating duplicates.
Open this area in your workspacePrepare the file
Use a CSV file with one customer per line and a header line on top. From Excel or Google Sheets, choose File, Download, then CSV.
Only the email column is needed. First name, last name, phone, country, city, tags and a subscribed column are used when present. Files up to 200,000 rows are accepted.
Import it
People already in your audience are matched by email. Their details from Shopify are kept; only empty fields are filled in, and tags are added.
- Open Customers and choose Import CSV.
- Choose the file. We guess which column is which; correct any that are wrong.
- Say whether these people asked for your emails.
- Choose Import. Keep the page open until it finishes.
Only import people you may email
Import your own customers and subscribers. Bought or borrowed lists are full of addresses that don't exist and people who will report you as spam, and both stop your emails reaching anyone.
An import never subscribes someone who unsubscribed, and never removes an address from the never-mail list.