Deduplicate a Shopify Customer Export CSV

When you export customers from Shopify, the CSV can contain the same customer multiple times — once per order, or once per fulfillment. For a store with thousands of repeat customers, the export can have three to ten rows per person. If you upload that export directly to a marketing platform like Klaviyo or Mailchimp, some customers will receive your campaign multiple times.

The CSV Deduplicator removes the extra rows, leaving one row per unique email address. Upload your Shopify export, select the Email column, keep the first occurrence, and download the clean single-row-per-customer list.

Why Shopify Customer Exports Have Duplicates

Shopify's customer export includes order history. A customer who has placed five orders appears five times in the export — once for each order. From Shopify's perspective, this is useful data: each row represents a transaction, not just a person.

But for email marketing, segmentation, or syncing to a CRM, you want one row per customer. The order-level data (order count, total spent, last order date) is usually summarized in dedicated Shopify columns like "Total Orders" and "Total Spent" — so the top row already has the aggregate data you need, and the subsequent duplicate rows add no additional contact information.

Depending on your export settings and Shopify plan, duplicates can also come from:

• Customers who checked out as guest and later created an account — two records linked to the same email
• Customers who placed orders with two slightly different email addresses (e.g., a work email and a personal email)
• Exports that include archived or merged customer records

Deduplicating by Email Address

Shopify's customer export uses "Email" as the column name for email addresses. This is the correct column to deduplicate on — it is the unique identifier Shopify uses for each customer account.

Steps:

1. Export your customers from Shopify Admin > Customers > Export (choose "All customers" or your filtered segment)
2. Open the CSV Deduplicator and upload the exported CSV
3. Select the "Email" column as the matching column
4. Choose "Keep first occurrence" — this keeps the row with the most complete summary data (total orders, total spent)
5. Download the deduplicated CSV — one row per customer

The tool normalizes email addresses before comparing, so "[email protected]" and "[email protected]" are treated as the same customer. No duplicates slip through due to capitalization.

Sell Custom Apparel — We Handle Printing & Free Shipping

First Occurrence vs Last Occurrence — Which to Keep

In a Shopify customer export sorted by order date (the default), the first row for each customer is typically their most recent or most complete record. The "Total Orders" and "Total Spent" columns are cumulative and the same value appears across all rows for that customer — so in practice, it does not matter which occurrence you keep for those fields.

Where it does matter: if you have filtered or customized your export so that rows are not identical across duplicates — for example, if you exported order-level data alongside contact data — choose the occurrence that has the most complete or up-to-date contact information.

If you are unsure, download both the deduplicated file and the duplicates file, spot-check a few known repeat customers, and confirm the kept row has the data you expected.

After Deduplication: Uploading to Your Marketing Platform

With a deduplicated CSV in hand, you can safely upload to any marketing platform:

• Klaviyo: Import CSV via Lists and Segments > the list name > Import Contacts. Klaviyo also deduplicates on email internally, but sending it a clean file prevents the import summary from showing high "duplicate skipped" counts.
• Mailchimp: Import via Audience > Add Contacts > Import Contacts. Mailchimp counts duplicates against your plan contact limit before deduplicating — uploading a pre-cleaned file keeps your contact count accurate.
• HubSpot: Import via Contacts > Import. HubSpot matches on email and updates existing contacts, but a pre-deduped file makes the import log cleaner and easier to audit.

If you also need to rename or reorder columns to match your platform's import format, run the CSV through the CSV Column Mapper after deduplication.

Frequently Asked Questions

Does Shopify have a built-in way to export one row per customer?

Not directly. Shopify's customer export includes order history by default. The only way to get one row per customer from a standard Shopify export is to deduplicate after exporting.

Should I deduplicate before or after filtering the list?

Either order works, but deduplicating first and then filtering is usually faster — you are working with a smaller file when you apply filters. If you are filtering on order-level data (e.g., customers who spent over $200 in 2025), filter first so you do not accidentally keep a row that meets the filter criteria when a better row for that customer was removed.