Use this tool

Prepare the input and run the tool

Paste a customer CSV from Shopify, CRM, spreadsheet, or email platform. Result: Download a cleaned customer CSV and an issue report.

All tools

Clean and validate customer CSVs before Shopify customer import.

Map the customer-related columns, then run checks for email quality, duplicates, and marketing-consent values.

Recommended laneUp to 500MB on modern desktop browsers

Local processingNo upload; keep this tab open while the worker runs

Large outputsClean CSV and issue report are split into downloadable parts

Best for Chrome or Edge on a desktop browser. Keep this tab open while the worker runs. If the file is above 500MB or the browser warns about memory, use Split CSV first and run each part.

Drop a customer CSV here

Use customer exports from Shopify, a CRM, email platform, old store, or spreadsheet.

Customer CSV

Email source columnFirst Name source columnLast Name source columnPhone source columnAccepts Email Marketing source columnAccepts SMS Marketing source column

Ready.

Customer import report

Run the cleaner before importing customers

Waiting for cleaner

Rows checked--

Issues found--

Blockers--

Next actionMap columns

Run to generate cleaned CSV summary and issue report.

Filter issue table

No row-level issues yet.

Row	Severity	Type	Email / phone	Field	Value	Reason	Suggested action

Data handling: This page processes only pasted text, selected files and form inputs in this browser session. Analytics measure page and button actions only; inputs and results are never read.

Readiness details

What to check before using the result

References and workflow

Open related workflow

Tool guide

How to use Shopify Customer CSV Import Cleaner

Use this before importing customers into Shopify. It gives you a cleaned CSV and a report for invalid emails, duplicate contacts, and consent values.

What this tool does

Clean a Shopify customer CSV by normalizing emails, phones, names, duplicates, and consent fields.

Input: Paste a customer CSV from Shopify, CRM, spreadsheet, or email platform
Output: Download a cleaned customer CSV and an issue report

Step-by-step usage guide

1Paste the customer CSV.
2Confirm email, name, phone, and consent columns.
3Download the cleaned CSV and review the issue report.

Common errors and fixes

Invalid email rows are removed or flagged

Customer imports depend on usable email identifiers, and copied lists often include notes, names, or malformed addresses.

Fix invalid addresses in the source, then rerun the cleaner before importing customers.

Duplicate customers appear after cleanup

The same customer can appear with different casing, whitespace, or phone formats.

Use the issue report to merge duplicates by normalized email first, then review phone-only duplicates manually.

Consent values are blank or invalid

Marketing consent columns need consistent allowed values for a safe import.

Standardize consent values before upload and keep uncertain rows out of the import until reviewed.

FAQ

What files can I download?

Download a cleaned customer CSV and an issue report for invalid emails, duplicates and consent values.

What validation is done?

Email normalization and basic format checks, duplicate detection, consent value validation, and blank-value warnings.