Remove duplicate rows in Excel
Upload your spreadsheet, choose which columns decide whether two rows are the same, and download the clean file. The original row order never changes.
When you need this
Duplicates almost always arrive the same way: somebody pasted two exports back to back, a form was submitted twice, or the same customer is stored both with and without a trailing space. The result is a report that adds up to more than it should, and nobody knows by how much.
Removing them by hand means walking through Data → Remove Duplicates, deciding column by column, and overwriting your file. Here you upload, check the result before downloading, and your original is never touched.
How a duplicate is decided
By default the whole row is compared: two rows match only if every column is identical.
You will usually want something narrower. If your sheet has an identifier — the customer email, a tax number, a product code — name it under "Columns to compare" and rows will be grouped by that value alone, even when the other columns differ.
You can type the column name, its Excel letter (A, B, AA) or its number.
All three work, so you don't have to go back and check how the header was spelt.
The two settings that change the result most
Ignore leading and trailing spaces is on, and you should leave it on. Stray
spaces are the number one reason duplicates go undetected: "Ana García" and
"Ana García " look identical to you and are different values to a computer.
Match upper and lower case is off. With it off, ANA, Ana and ana count
as the same value, which is what you normally want for names, emails and cities.
Turn it on only when you work with codes where case genuinely matters.
What is kept and what is not
Row order and data types are kept: numbers stay numbers, dates stay dates. The surviving row sits where the first occurrence was, even if you choose to keep the last one, so the downloaded file still lines up with the one you uploaded.
Colours, formulas and conditional formatting are not kept. This tool works with values, not with appearance.
Frequently asked questions
Is my file uploaded to a server?
Yes, processing happens on our server. Your file is held in memory only for the duration of the request and discarded when it finishes: it is never written to disk, never linked to your identity and never shared.
Does it change my original file?
No. The file you upload is never altered. What you download is a new file with a
-sin-duplicados suffix.
What if two rows match except for one extra space?
With "Ignore leading and trailing spaces" enabled — the default — they are detected as duplicates. That is exactly the case Excel does not solve on its own.
Can I choose which of the repeated rows survives?
Yes. "The first occurrence" keeps the earlier row, "the last occurrence" keeps the most recent one. Either way the surviving row stays in the position of the first, so your sheet is never reordered.
Does it work with CSV files?
Yes, and with legacy .xls files too. CSV delimiter and encoding are detected
automatically; the result comes back in the format you uploaded, except .xls,
which is delivered as .xlsx.
Is there a size limit?
Yes: 10 MB per file and 200,000 rows. For anything larger, split the file first or process it in desktop Excel.