Will this file import into Shopify?
Find out before you upload. This checks your spreadsheet against Shopify's real customers rules, maps your columns to its field names, and shows you exactly which rows would be rejected — with row numbers.
Runs in your browser. Nothing is uploaded.
Drop a CSV or Excel file here
Or choose a file — nothing leaves your browser.
Shopify rejects the whole row for a badly formatted phone number, and its marketing-consent columns accept literally only 'yes' or 'no' — not TRUE, 1, or Y.
- Email — used to deduplicate
- The Email column must be present, though individual values may be blank.
- Headers are not case sensitive.
- Consent and tax columns accept only 'yes' or 'no'.
Common questions
Which columns does Shopify require for customers?
Email. Rows missing it are rejected. This page checks every row for you and lists the ones that would fail.
Why did my Shopify import fail?
Shopify rejects the whole row for a badly formatted phone number, and its marketing-consent columns accept literally only 'yes' or 'no' — not TRUE, 1, or Y. Drop your file above and you'll get a row-by-row list of what Shopify would reject, with the row numbers.
Is my file uploaded anywhere?
No. The mapping and validation run entirely in your browser using JavaScript. Your spreadsheet never reaches our servers, which matters when the file is a customer list.
Does it change my data?
It renames your column headers to Shopify's exact field names and reformats values that Shopify would otherwise reject — phone numbers, yes/no fields and picklist casing. Every change is listed before you export, and nothing that can't be safely converted is touched.
Field rules sourced from Shopify's own documentation.