Skip the manual navigation

Import and export your customer list

Bring customers in from a CSV, or download your list for reporting or backup.

5 min read · Updated October 2, 2026 · Screenshots use demonstration accounts

On this page
  1. 1. Export everything in view
  2. 2. Export just a few rows
  3. 3. Start an import
  4. 4. Run the import
  5. 5. Read the skip reasons
  6. 6. Fix and re-import
  7. Completion checklist
  8. Troubleshooting
Before you start

Have a CSV with a header row, or decide which search filter you want to export.

On a phone? Open the admin menu to find the same section. Screenshots below show the desktop view; tap “Open full size” for a closer look.
STEP 1

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.

STEP 2

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.
STEP 3

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.

STEP 4

Run the import

Import up to 1,000 rows at a time. Each row needs an email or a phone number.

STEP 5

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”.

STEP 6

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.

In this section: Customer records

Still need help?

Tell us your store address and what you’re trying to do. Leave out passwords and payment details.

Contact support