Import and export your customer list
Bring customers in from a CSV, or download your list for reporting or backup.
On this page
Have a CSV with a header row, or decide which search filter you want to export.
Export everything in view
Customers → Export downloads a CSV of the customers matching your current search and filters (or your whole list if none are set). Columns: first_name, last_name, email, phone, accepts_email_marketing, accepts_sms_marketing, accepts_whatsapp_marketing, language, tax_exempt, tags, note, total_orders, total_spent, created_at.
Export just a few rows
Select customers with the row checkboxes, then Export selected in the bulk-action bar. This builds a smaller CSV in your browser from the rows already on screen — first_name, last_name, email, phone, location, total_orders, total_spent — and leaves out marketing consent, tags, and notes.
- Export selected can't reach customers outside the current page; change the page size or filter first if you need more.
Start an import
Customers → Import. Upload a .csv file or paste CSV text with a header row. Only the first_name, last_name, email and phone columns are read; the file needs an email or a phone column.
Run the import
Import up to 1,000 rows at a time. Each row needs an email or a phone number.
Read the skip reasons
Rows missing both contacts, or reusing an email already in your store, are skipped — not failed — and listed with a reason (“Missing both email and phone”, “<email> is already used by another customer”). The result banner reads “<n> customers created · <n> skipped”.
Fix and re-import
Correct the skipped rows and run Import again. Rows whose email already exists are skipped again, so customers with an email aren't duplicated — but a phone-only row is created again each time, so remove phone-only rows that were already imported before you re-run.
CHECK YOUR WORK
You’re ready when…
- The export's filter matches what you intended to download.
- Every created and skipped row in the import result is accounted for.
- Phone-only rows that were already imported are removed before re-running an import.
IF SOMETHING DOESN’T LOOK RIGHT
Troubleshooting
My whole import came back 0 created.
Check the header spelling — first_name, last_name, email, phone (case and spacing don't matter, but the words do) — and confirm every row has at least an email or a phone.
A row failed saying the email is already in use.
That email already belongs to another customer in this store; edit the existing record instead of importing a duplicate.
Can I import addresses or store credit through this?
No — Import only creates customers from first_name, last_name, email and phone. Add addresses, consent, tags and store credit on each profile afterward.