How to Find and Remove Duplicate Emails in Excel & Google Sheets

Built-in tools, formulas, and why they miss more duplicates than you'd expect.

Excel: Remove Duplicates tool

Select the column (or full table) containing the email addresses.
Go to the Data tab and click Remove Duplicates.
Confirm which column to check, then click OK. Excel removes exact matches and reports how many were deleted.

This only catches exact matches — identical casing, identical spacing. Jane@Company.com and jane@company.com are the same inbox but won't be caught, since email addresses aren't case-sensitive on the domain (and rarely on the local part either) but Excel's comparison is.

Google Sheets: same idea, slightly different path

Select the range with your email addresses.
Go to Data → Data cleanup → Remove duplicates.
Confirm the column and range, then remove.

Same limitation as Excel — case and formatting differences slip through as "unique" even though they're the same real-world address.

Using a formula instead

To flag duplicates without deleting anything (useful if you want to review before removing):

=COUNTIF(A:A, A2)>1

Applied as conditional formatting or a helper column, this highlights every row where the email in column A appears more than once — again, exact match only.

What spreadsheet tools miss

Beyond casing, the duplicates that matter most for actual deliverability are often invisible to a simple duplicate check:

Gmail dot variants — j.smith@gmail.com and jsmith@gmail.com deliver to the same inbox, but read as different strings.
Gmail +tags — jane+newsletter@gmail.com and jane@gmail.com are the same inbox.
Trailing whitespace or invisible characters from a copy-paste — invisible on screen, but enough to make two identical-looking addresses fail a duplicate check.

A free list cleaner catches all of the above automatically — Gmail dot and +tag collapsing, whitespace normalization, and exact-match dedup in one pass, plus syntax and MX validation. Paste your list in, nothing is uploaded.

Which approach should you use?

For a quick one-off clean of a small list, Excel or Sheets' built-in tool is fine. If the list came from a scrape, an old export, or multiple merged sources — where dot variants and formatting quirks are likely — a dedicated list cleaner will catch meaningfully more real duplicates than a spreadsheet's exact-match comparison ever will.

Frequently asked questions

Why doesn't Excel's Remove Duplicates catch every duplicate?

It only compares exact matches — different casing, extra whitespace, or Gmail's dot and +tag variations all read as unique even though they're the same real-world inbox.

Is Google Sheets' duplicate removal any different from Excel's?

No — Sheets' Data cleanup tool has the same exact-match limitation as Excel's Remove Duplicates.

What's the fastest way to find every real duplicate in a large list?

Paste the list into a dedicated list cleaner — it collapses casing, whitespace, and Gmail dot/+tag variants automatically, in addition to exact matches.