Find Duplicate Emails in Excel
To find duplicate emails in Excel, drop the workbook here. Every cell on every sheet is checked, so repeats across sheets and across several workbooks are caught, and capital letters, stray spaces or a name in the same cell don't hide them. You get the repeated addresses with a count for each, and a clean list with every address once. The file is read in your browser and never uploaded.
Drop in a workbook. See every repeated address, across all sheets.
100% free • No signup • Runs in your browser
How to use the Excel Duplicate Email Finder
- 1
Drop the workbook
Add one or more XLSX, XLS or ODS files, or paste a column copied from Excel. You don't need to pick the email column.
- 2
Duplicates are found
Every sheet is checked. Repeats are listed with how many times they appear and which files they're in.
- 3
Copy the clean list
Copy the deduplicated list or download it as a CSV to paste back into Excel.
Checking Excel files for duplicate emails
- Across sheets and workbooks
- Excel's Remove Duplicates works on one range of one sheet. Here every sheet of every file you add is checked together, so an address on a Leads sheet and a Customers sheet counts as a repeat.
- Messy cells
- An address with a trailing space, in capitals, or written as Jane Doe <jane@acme.com> is matched to the same address typed plainly.
- Gmail aliases
- Turn on "Treat aliases as duplicates" to catch jane.doe@gmail.com and janedoe+promo@gmail.com, which reach one inbox.
- Your workbook is untouched
- The tool reads the file and gives you a new list. Nothing in your workbook changes, so you can review the repeats before you delete anything.
Find duplicate emails elsewhere
The Duplicate Email Finder takes pasted lists and any mix of files at once. Each of these pages is set up for one kind of list:
Frequently Asked Questions
Does it check every sheet in the workbook?
Yes. Every cell on every sheet is read, including hidden sheets, so duplicates spread across sheets are found.
Can I compare two Excel files for duplicate emails?
Yes. Drop both workbooks. An address in both files is listed as a duplicate, with the names of the files it appears in.
Will it keep the other columns in my sheet?
The result is a list of email addresses, not rows. Your workbook isn't changed, so the other columns stay as they are there.
Does Jane@Acme.com count as a duplicate of jane@acme.com?
Yes. Addresses are compared regardless of capital letters and surrounding spaces, the way mail providers treat them in practice.
How big a workbook can I check?
Up to 25 MB per file, and up to 20 files at a time. For more files, put them in a ZIP and drop that.
Are my Excel files uploaded?
No. The workbook is read in your browser and never sent to our servers or stored.