Remove duplicate emails
Paste a list or a whole spreadsheet and get back each person once, with every column kept. Capital letters and stray spaces won't fool it, it spots Gmail addresses written differently that reach the same inbox, and it can fill in blanks from the copies it removes.
Runs entirely in your browser. Your list is never uploaded.
What counts as a duplicate?
Two entries are duplicates when they deliver to the same inbox. This tool compares addresses without caring about capital letters ([email protected] and [email protected] are the same) and ignores spaces before or after the address, which often sneak in when you copy from a spreadsheet or a web page.
The Gmail rule
Gmail ignores dots in the part before the @, so [email protected] and [email protected] reach the same person. Gmail also delivers [email protected] to [email protected]. With the Gmail option on, the tool keeps the first version it sees and removes the others. Leave it off if you'd rather keep every spelling exactly as people typed it.
Which copy is kept?
The first one in your list. Everything after it that matches is removed, and you can see exactly what was removed and which address it matched in the list under the results.
Spreadsheets keep every column
Paste or open a CSV with names, phone numbers, companies or notes, and the tool finds the email column on its own (you can pick a different one). Duplicate rows are removed as whole rows, so nothing gets out of line. With Fill blank cells from the duplicates on, details aren't lost either: if the first copy of a contact has no phone number but a later copy does, the phone number is moved onto the row that's kept. Download the result as a CSV, or copy it and paste straight into Excel or Google Sheets.
Working in a spreadsheet instead?
If your emails sit next to names, phone numbers and other details, removing rows in the spreadsheet itself keeps everything together. Follow our step-by-step guides for Excel and Google Sheets.
Frequently asked questions
Does it remove duplicates with different capital letters?
Yes. Email addresses are compared without regard to capital letters, so [email protected] and [email protected] count as one.
Will it change the addresses I keep?
Each entry is reduced to the email address itself, so "Jane Cooper <[email protected]>" becomes [email protected]. Letters are lowercased only if "Lowercase the emails" is on. In a spreadsheet, every other column stays exactly as it was.
Can I remove duplicate rows from a CSV and keep the other columns?
Yes. Open or paste the spreadsheet and the tool keeps every column, removes repeated people as whole rows, and can fill empty cells from the copies it removes.
Is it safe to use with customer lists?
Yes. The tool runs in your browser and nothing you paste is sent to a server.