ZapKit

Remove duplicate rows

De-duplicate a list of contacts, orders or products, matching on the columns that matter, and see exactly which rows were removed.

What does removing duplicate rows mean?

Removing duplicate rows means deleting repeated records from a table so each person, order or product appears once. Duplicates creep in when lists are merged, forms are submitted twice or exports overlap, and they inflate counts and send people the same email twice.

Paste or open a CSV and decide what counts as a duplicate: entire rows, or a set of key columns. Choose whether capitals and extra spaces matter and which copy to keep. You'll see how many rows were checked, removed and left, with the cleaned table and the removed copies ready to download.

How to use the Remove duplicate rows

  1. 1.Paste or open the CSV

    With headers in the first row.

  2. 2.Choose what makes a duplicate

    Whole rows, or columns such as email or SKU.

  3. 3.Download

    The de-duplicated rows, and the removed copies if you want them.

Example: a newsletter list

Six sign-ups where Asha appears three times and Ravi twice:

Exact whole-row match
1 removed
Whole rows, ignoring capitals
2 removed
Matching on email only
3 removed, 3 subscribers left

Matching on email catches "Ravi K." too, leaving one row per subscriber.

Matching the way people mean it

Exact matching misses copies like ASHA@example.com and asha@example.com, or a name with an extra space. Ignoring capitals and spaces catches those. Matching on chosen columns treats two rows as the same customer when their email matches, even if the name was typed differently.

Keep first holds on to the earliest row of each group, keep last the most recent, which suits exports where newer rows hold updated details. The original order of the kept rows is preserved.

Frequently asked questions

Can I see what was removed before downloading?

Yes. The removed copies are listed underneath and can be downloaded separately.

Does it change the values I keep?

No. Matching ignores capitals and spaces, but kept rows stay exactly as they were.

Can it find near-duplicates like misspelled names?

No. Match on a reliable column such as email or phone instead.

Is the file uploaded?

No. Matching happens locally.

More Developer tools