Remove duplicates from CSV

Removes duplicate rows by email, domain, LinkedIn URL or company name and keeps the most complete row.

CSV or Excel, up to 200,000 rows
Runs in your browser. The file never leaves your device.CSV or Excel, up to 200,000 rows

Next

Email me this report
A short summary of this run: the counts and settings, never your rows. Your file stays in your browser.
The counts from this runThe settings you usedNo file, no rows, no saved link
One email with the report. No sequence, no sales call.
Ken cleans every list you import, then verifies it.
Import once. Ken dedupes, formats and verifies every address, and keeps the flags with each lead.
Start free - 1,000 credits, no card

What remove duplicates does

It finds rows that describe the same person or company and keeps one. Pick what counts as a duplicate:

  • Email, after trimming and lowercasing, with Gmail dots and +tags ignored.
  • Domain, to keep one contact per company.
  • LinkedIn URL, after canonicalizing the profile link.
  • Company name, with fuzzy matching that ignores suffixes and case, so "Acme Inc." matches "ACME".

The file is read in your browser and never uploaded.

How to read the result

The counts show how many duplicate groups were found and how many rows were removed. Each group lists the rows that matched and which one stayed. The kept row is the one with the most filled cells, so you lose blanks, not data. Every removed row goes to a second file.

How to use it

Dedupe by email for a contact list. Dedupe by domain when you want one person per account, for example the most senior one, and sort the file by seniority before you run it. Use company name matching for account lists that have no domain column. Check the groups before downloading if you use fuzzy matching, because two different companies can share a name.

Why it matters for cold email

The same person getting the same email twice is a fast way to a spam complaint, and complaints weigh more than anything else in inbox placement. Duplicates also skew every rate you measure and waste sends you pay for. Lists merged from two exports almost always overlap.

Questions

How do I remove duplicates from a CSV file?
Drop the file here, pick the column that should be unique, usually email, and download the result. The tool keeps one row per duplicate group and puts the removed rows in a second file so you can check them.
How do I remove duplicates in Excel?
Data > Remove Duplicates works on exact matches. It treats "[email protected] " with a capital and a trailing space as different from [email protected], and it keeps the first row rather than the most complete one. This tool normalizes the values first, so those count as duplicates.
Which row is kept when there are duplicates?
The row with the most filled cells. When two rows are equally complete, the first one in the file stays. The removed file lists every dropped row next to the one it duplicates.
Are Gmail dots and plus signs really the same address?
For gmail.com and googlemail.com, yes. Gmail ignores dots in the username and everything after a +, so [email protected] reaches [email protected]. On other domains dots can matter, so the tool only lowercases and trims those.
Can I keep only one contact per company?
Yes. Choose domain as the duplicate key. Sort the file first so the person you want to keep is the most complete row or comes first, then run it.

More in CSV tools

14 tools.