How to remove duplicate contacts in Excel, including the ones Excel misses
Excel has a built-in Remove Duplicates button, and for perfectly identical rows it works fine. Contact lists are rarely that tidy. The same person turns up as "Bob Brown" and "Robert Brown", with one phone written as (646) 555-0142 and another as +1 646 555 0142, or with a work email in one row and a Gmail address in the next. Excel treats all of those as different people.
This guide shows what the built-in tools can do, where they stop, and how to clean the rest without copying the list into a website that keeps it.
Step by step
- Make a copy of the sheet
Before you delete anything, duplicate the workbook. If something goes wrong you can always go back.
- Remove exact duplicates first
Select your data, open the Data tab and click Remove Duplicates. Tick only the columns that should identify a person, usually email. This clears rows that are truly identical.
- Look for near-duplicates
Sort by last name or company and scan for pairs that are clearly the same person written differently. Conditional formatting (Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values) helps for exact repeats, but it won't see nicknames or different phone formats.
- Let a matcher do the fuzzy part
Save the sheet as .xlsx and open it in Contact Dedup. It compares names (including nicknames and accents and spelling variants), emails and phone numbers, shows each likely pair with the reasons, and gives you back an .xlsx file. The file is processed in your browser, so it isn't uploaded anywhere.
- Check the groups and download
Confident pairs, which share an email or phone and have matching names, are ticked for you. Pairs that only look alike wait for your decision. The cleaned file has a column showing which original rows were merged.
Things to watch out for
- Remove Duplicates keeps the first row of each set and deletes the rest. If the later row has the newer phone number, you lose it. Sort by date first, or merge instead of deleting.
- Phone numbers stored as numbers lose their leading zeros and the plus sign. Format the phone column as Text before you edit it.
- Two people can share an office phone or an info@ address. Don't treat those as duplicates on their own.
Questions
Does Excel's Remove Duplicates catch typos?
No. It compares cell values exactly, so "Jon Smith" and "John Smith" stay as two rows.
Will merging lose any data?
Contact Dedup keeps the most complete row, fills its empty cells from the other rows and keeps every distinct email and phone number in the group.
Is my spreadsheet uploaded?
No. The file is read and cleaned inside your browser tab. You can disconnect from the internet after the page loads and it still works.
More guides
- What Contact Dedup understands, with examplesWhich pairs are the same person, and which are kept apart.
- How to find and merge duplicate contacts in a CSV fileWhat to compare, and how not to merge two different people.
- How to clean up duplicate contacts from your phone (vCard / .vcf)Export, merge without losing photos or notes, import back.
- How to dedupe a Google Contacts exportWhen Google's Merge & fix isn't enough.
- Cleaning duplicate contacts out of a CRM exportCustomer data, sales history and why you shouldn't upload it.
- How to remove duplicates from a mailing list before you import itFewer double sends, cleaner stats, lower bills.
- How to find duplicate companies in a CRM or spreadsheetLegal forms, websites and branches in different cities.