Tool 02

🔍 Find and Remove Duplicates in Excel

Shows you every group of duplicate rows side by side. You decide what gets deleted — nothing is removed until you confirm.

🔒 Works offline — your file never leaves your computer

What the duplicate finder does

Before and after: duplicate rows

BeforeAfter
Row 2: Brightline Dental | info@brightline.comkept
Row 9: BRIGHTLINE DENTAL | info@brightline.com removed (you confirm)
Row 4: Harbor Logistics | ops@harbor.comkept (not a duplicate)
Matching on the columns Company + Email.
⬇ Download Tool — Free
or use it right here in your browser →
Single HTML file · opens in Chrome, Edge, Firefox or Safari · no installation, no sign-up

How to find and remove duplicates in Excel in 3 steps

1
Download the toolClick the red button and save the file to your computer.
2
Open it in your web browserDouble-click the downloaded file. It opens in your browser — not in Excel. No installation, no account.
3
Choose your Excel file and save the cleaned copyClick "Run", check the before/after examples on screen, then save. Your original file stays untouched.

Before you start: limits and backup

How this differs from Excel's Remove Duplicates

Duplicate rows creep into every list that is built from more than one source: the same customer from two exports, a contact entered twice, a copy-paste that went wrong. Excel's built-in "Remove Duplicates" deletes rows straight away without showing you what it removes.

This tool works the other way round. It first shows you every group of rows that match, side by side, with their row numbers. The first row of each group is marked to keep, the others to remove — and you can change every tick before anything happens.

You also decide what counts as a duplicate. By default every column must match. If you only want to compare Name and Email, for example, just click those two columns.

When you are happy, click "Remove selected rows" and save the cleaned copy. Your original file is not changed, and nothing leaves your computer.

Common questions about finding duplicates in Excel

How do I find duplicates in Excel without deleting them right away?

The tool first shows every group of matching rows side by side with their row numbers. Nothing is deleted until you confirm. The first row of each group is marked to keep, and you can change every tick before you click Remove selected rows.

Can I compare only some columns, like Name and Email?

Yes. By default every column must match. If you only want to compare Name and Email, click those two columns. Differences in upper and lower case and extra spaces are ignored.

Why are rows that look identical not found as duplicates?

Often the rows differ by invisible characters copied from a website. Run the Clean Whitespace tool first, then search for duplicates again.

More free Excel cleanup tools

← View all tools