EStore Tools

Shopify Customer CSV Formatter

Fix phone numbers, country codes and marketing consent before you import a customer list.

Describe the result you need. AI will set up the tool and ask for any missing details.

Configure with AI

Enter to submit · Shift + Enter for a new line

Sent to AI. Leave out passwords and private customer data.

Drop your customer list here or browse files

CSV up to 25 MB. It's read in your browser and never uploaded.

Used only for numbers with no country code already, like a plain US or Canadian number.

How it works

Shopify's customer CSV is picky about a few columns: phone numbers need a leading + and country code, Country/Province Code need two-letter ISO codes, and Accepts Email Marketing / Accepts SMS Marketing only accept yes or no, not true/false or 1/0.

  • Phone numbers with no country code are assumed to be in the country you set below (default +1 for US/Canada) and reformatted to E.164.
  • Country and province names (like "United States", "California") are converted to their 2-letter codes.
  • Marketing consent values are normalized to yes/no.
  • Duplicate emails are flagged so you can merge or remove them before importing.

Importing the result

  1. 01

    Fix any errors listed

    Rows with no email and no phone number can't be imported; Shopify needs at least one to identify the customer.

  2. 02

    Go to Customers → Import

    In your Shopify admin, upload the downloaded CSV.

  3. 03

    Check the marketing consent columns

    Only add customers who actually agreed to receive marketing; importing a list doesn't collect real consent.

Questions people ask

What country code does it assume?

Whatever you set in the option above, applied only to phone numbers that don't already start with a country code or +.

Does this check that an email is deliverable?

No, only that it's not a duplicate within the file. Use an email verification tool separately if you need deliverability checks.

Can I import marketing consent for people who never opted in?

You shouldn't. Shopify's own policies and most email/SMS laws require real consent before you mark someone as subscribed.

What if a country isn't recognized?

It's left as-is with a warning; set the two-letter code for that row by hand.

Related tools

Shopify CSV ValidatorCheck a Shopify product CSV for import errors before you upload it, and download a cleaned-up copy.Shopify CSV Find & ReplaceFind and replace text across chosen columns of any Shopify CSV, with a live preview.Shopify Metafields CSV BuilderTurn plain columns into Shopify's metafield CSV header format, with type checking.Shopify Inventory CSV BuilderTurn a supplier's SKU and quantity list into Shopify's per-location inventory CSV.

Want this builtinto your store?

I'm Emmanuel, a Shopify and WooCommerce developer. If this tool pointed at something you'd rather have fixed for you (a faster store, cleaner product data, a migration, a custom feature), send me a note.

Emmanuel Asika

Emmanuel Asika

Shopify & WooCommerce developer, Dublin

I build and fix online stores: new builds, migrations, speed, SEO and the custom bits apps can't do.

hello@emmanuelasika.com
See my work

Last reviewed 30 September 2026.

Sources: Shopify Help Center: Importing and exporting customer lists