Remove Duplicates in Excel
The file without its repeated rows: whole rows, or rows repeating in the columns you name.
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 Remove Duplicates in Excel
- 1Select your file, or drop it on the page
- 2Choose how, then run it
- 3Download no-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
How do I remove duplicates in Excel online?
Upload the file, optionally name the columns that make a row a duplicate (an email, an order id), and download it without the repeats.
Does "A@x.com" count as the same as "a@x.com "?
Yes. Values are compared trimmed and without case, the way a person reads them.
Can I see what was removed?
Yes. The removed rows are on their own sheet, so nothing disappears without a trace.
Can I find duplicates across several files?
Use Find duplicates for that: it compares rows across files and sheets.