Remove duplicate rows from an Excel file online
Excel's Remove Duplicates edits your file in place and tells you only how many rows it deleted — not which ones. Here the duplicates come back on their own tab, so you can check what was dropped before you trust it.
The instruction to paste
Example instruction
Remove repeated Email values, keeping the first occurrence of each address
What comes back
| Name | Signed up | |
|---|---|---|
| ivan@example.com | Ivan | 2026-01-12 |
| maria@example.com | Maria | 2026-01-14 |
| ivan@example.com | Ivan K. | 2026-02-03 |
| petr@example.com | Petr | 2026-02-11 |
| maria@example.com | Maria | 2026-03-01 |
| Name | Signed up | |
|---|---|---|
| ivan@example.com | Ivan | 2026-01-12 |
| maria@example.com | Maria | 2026-01-14 |
| petr@example.com | Petr | 2026-02-11 |
How it works
- 01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
- 02
Paste the instruction, changing the column names to the ones in your own file.
- 03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.
Other ways to ask
The instruction is read as a sentence, not filled into a form. These all work on the same file.
Remove rows where Email and Signed up are both the same, keeping the last occurrence
Keep only rows whose Email appears exactly once in the file
The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.
Questions
Which of the duplicates is kept?
Whichever you ask for. Say "keeping the first occurrence" or "keeping the last"; the first is used if you do not say.
Can I match on more than one column?
Yes — name them and a row counts as a duplicate only when all of those columns match.
Are trailing spaces treated as a difference?
By default yes, because "ivan@example.com " really is a different string. Ask for the column to be trimmed first and they stop counting as different.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.