Guides

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

  1. Make a copy of the sheet

    Before you delete anything, duplicate the workbook. If something goes wrong you can always go back.

  2. 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.

  3. 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.

  4. 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.

  5. 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

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