Find duplicates in Excel
Spot repeated rows across sheets and files, with the originals kept.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Find duplicates in Excel
- 1Select your files, or drop them on the page
- 2Run it — nothing to set up
- 3Download duplicates.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
Does it compare whole rows or single columns?
Whole rows by default, which is the safe answer — two customers can share a name without being the same record. You get the repeated rows listed with how many times each appeared.
Can it find duplicates across two different files?
Yes. Upload both and the comparison runs across all of them together, which is the usual case: this month's export against last month's.
Does it delete anything?
No. You get two things: a list of what was repeated, and a de-duplicated copy. The original is untouched, so nothing is lost if the match was wrong.
Will it treat 'ACME Ltd' and 'acme ltd' as the same?
Yes for case and surrounding spaces, which are the differences that come from typing rather than from meaning. Genuinely different spellings are left alone rather than guessed at.

