How to remove duplicate rows from excel without the remove duplicates button
- Step 1Open the tool in any browser — On Chromebook, iPad, or any OS, open the Excel deduplicator — it loads the CSV/Excel deduplicator workspace. No Office install needed.
- Step 2Drop your file — Drag in the
.xlsx,.xls,.ods, or.csv. The header row is parsed locally to build the column picker. - Step 3Pick the key column — Choose the column whose values should be unique —
Email,SKU,Order ID. Two rows are duplicates only when this column matches. - Step 4Set case sensitivity — Leave
Case-sensitive keysoff for a normal match (this mirrors what most people expect), or tick it when casing is meaningful. - Step 5Remove duplicates — Click Remove duplicates. Processing happens in your browser tab, so even on a Chromebook nothing is uploaded.
- Step 6Download — Grab the deduplicated file. XLSX in ->
.deduped.xlsx; CSV in ->.deduped.csv. A 10-row preview confirms the result.
Browser deduplicator vs Excel's Remove Duplicates
What the desktop button does, and how this browser tool maps to it. Anything not listed here as a control does not exist in this tool.
| Capability | Excel Remove Duplicates (Desktop) | This browser tool |
|---|---|---|
| Where it runs | Excel for Desktop only | Any browser — Chromebook, iPad, Linux |
| Key selection | Tick one or more columns | Pick exactly one column from a dropdown |
| Multi-column composite key | Yes (tick several) | No — single column only (use a helper column) |
| Case sensitivity | Always case-insensitive | Case-insensitive default; case-sensitive checkbox |
| Whitespace handling | No trim; x ≠ x | Always trims the key before compare |
| Which row is kept | First occurrence | First occurrence |
| Blank-key rows | Collapsed to one | All kept (never collapsed) |
Supported inputs and what you get back
The same drop zone accepts all four formats. Output format follows the input.
| Input | Read behaviour | Output |
|---|---|---|
.xlsx / .xls / .ods | First worksheet only | .deduped.xlsx (single sheet, values only) |
.csv | Parsed as delimited text | .deduped.csv |
| Multi-sheet workbook | Sheets 2+ ignored | Single output sheet |
Tier limits for Excel deduplication
Real per-file limits applied when you drop an .xlsx onto the Excel hub. Row count is the parsed first-sheet body, not bytes.
| Tier | Max file size | Max rows | Files at once |
|---|---|---|---|
| Free | 5 MB | 10,000 | 1 |
| Pro | 50 MB | 100,000 | 5 |
| Pro-media | 200 MB | 500,000 | 20 |
| Developer | 500 MB | unlimited | unlimited |
Cookbook
Scenarios for people without Excel desktop — deduping on the go from a browser. Values anonymised; behaviour is exactly as implemented.
Dedupe an .xlsx on a Chromebook, no Office
A school-issued Chromebook can't install Office and Sheets keeps timing out on a big file. Drop the .xlsx in the browser, key on StudentID, and download a clean .xlsx.
Input (key column = StudentID): StudentID,Name,Class S-01,Ada,7A s-01,Ada,7A S-02,Ben,7B Output (.deduped.xlsx): StudentID,Name,Class S-01,Ada,7A S-02,Ben,7B -> case-insensitive default collapsed s-01 with S-01
The desktop button is greyed out (table object)
Remove Duplicates is disabled because the data is inside an Excel Table on a protected sheet. Export/save-as the file and dedup it in the browser instead — no protection state to fight.
Workflow: 1. File -> Save As -> .xlsx (or .csv) 2. Drop onto the browser deduplicator 3. Key column = InvoiceNo, default case-insensitive 4. Download .deduped.xlsx -> no table-object or sheet-protection restriction
iPad: dedupe a CSV before emailing it back
On an iPad with only Safari, dedup a CSV attachment by Email, then download and re-attach. Nothing uploads, so it works on cellular too.
Input (key column = Email): Email,Name a@x.com,Al A@X.com,Al b@x.com,Bo Output (.deduped.csv): Email,Name a@x.com,Al b@x.com,Bo
Stray space hidden in a key the desktop button would miss
Excel's Remove Duplicates does NOT trim, so 5012 and 5012 survive as two rows there. This tool always trims the comparison key, catching the duplicate the desktop button leaves behind.
Input (key column = OrderID): OrderID,Total 5012,49.00 5012,49.00 Excel desktop: keeps BOTH (no trim) This tool: keeps 1 ( 5012 verbatim) — trim caught it
Need a composite key the single column can't give
The desktop button lets you tick several columns. This tool keys on one — so build a helper column first, dedup on it, then delete it. This is the no-desktop equivalent of a multi-column dedup.
Add helper column 'key' = First + '|' + Last + '|' + DOB: key,First,Last,DOB ada|lee|2000-01-01,Ada,Lee,2000-01-01 ada|lee|2000-01-01,Ada,Lee,2000-01-01 bob|roy|1999-02-02,Bob,Roy,1999-02-02 Key column = key -> 1 duplicate removed. Delete the helper column afterward.
Edge cases and what actually happens
Excel desktop button is greyed out
Use this insteadRemove Duplicates is disabled inside Table objects, protected sheets, and some filtered states. Save the file as .xlsx or .csv and dedup it here — there's no protection or table state to satisfy.
Excel for the web lacks the feature
Browser alternativeExcel for the web doesn't expose the full Remove Duplicates dialog. This tool gives you key-column dedup in any browser without needing the desktop app.
Multi-column composite key
Single column onlyUnlike the desktop button (tick several columns), this tool keys on one column. Concatenate the columns into a helper column, dedup on it, then delete the helper.
Only the first worksheet is processed
First sheet onlyA multi-sheet workbook is deduplicated on sheet 1 only. Sheets 2+ are dropped from the output. Merge sheets with the sheet joiner first if needed.
Trim catches what the desktop button misses
SupportedExcel's Remove Duplicates does not trim, so a leading/trailing space makes two rows survive there. This tool always trims the comparison key, so those collapse. The kept cell still shows its original spacing.
Blank-key rows are kept
PreservedExcel collapses blank keys to one row; this tool keeps every blank-key row. Strip them afterward with the empty-row remover if you want Excel-like behaviour.
File too big for Free
RejectedFree caps at 5 MB / 10,000 rows / 1 file. A bigger workbook is blocked before processing — upgrade to Pro (50 MB / 100,000 rows) or split it.
XLSX output drops formatting
Values onlyThe deduplicated .xlsx is rebuilt as one values-only sheet, so colours, conditional formatting, and formulas are not carried over — same trade-off you'd accept exporting to CSV and back.
No header row
ErrorThe column picker needs headers. A sheet with no header row throws "No header row was found". Ensure row 1 has labels before dropping the file.
Near-duplicates won't collapse
Not supported hereExact-match only (after trim/case-fold). John Smith vs Jon Smith stay separate. For approximate matches use the fuzzy deduplicator (Pro).
Frequently asked questions
Does this work on a Chromebook or iPad?
Yes. It runs entirely in the browser, so any device with a modern browser works — Chromebook, iPad, Linux, locked-down work laptop. No Office install.
Why is Excel's Remove Duplicates button greyed out?
Usually because the data is inside a Table object, the sheet is protected, or you're in Excel for the web which lacks the full dialog. Save as .xlsx/.csv and dedup here instead.
How is this different from Excel's Remove Duplicates?
It keys on one column (Excel can tick several), keeps the first occurrence (same), is case-insensitive by default (same), but additionally always trims the key so spaced duplicates collapse — which the desktop button misses.
Can I deduplicate on multiple columns at once?
Not directly — single column only. Build a helper column that concatenates your columns, key on it, then delete the helper. That replicates a multi-column dedup.
What file formats can I upload?
.xlsx, .xls, .ods, and .csv. An XLSX-family input gives a deduplicated .xlsx; a CSV gives a .csv.
Does it open multiple sheets?
No — only the first worksheet of a workbook is read and deduplicated. Combine sheets first with the sheet joiner if your duplicates span tabs.
Is my data uploaded?
No. Everything runs in your browser tab via SheetJS, so it works offline once loaded and on metered connections. The file never leaves your device.
Which row is kept on a duplicate?
The first occurrence in row order, with original order otherwise preserved — identical to Excel's behaviour.
What happens to blank cells in the key column?
Rows with a blank key are all kept (not merged). Excel collapses them to one; if you want that, run the empty-row remover afterward.
How big a file can I dedupe for free?
5 MB / 10,000 rows / 1 file on Free. Pro raises it to 50 MB / 100,000 rows / 5 files; Pro-media to 200 MB / 500,000 rows; Developer to 500 MB / unlimited.
Will my formulas survive?
On XLSX output, no — the result is values-only. Formulas become their computed values and formatting is dropped, the same as a CSV round-trip.
Does it handle near-duplicates / typos?
No — this is exact-match (after trim/case-fold). For fuzzy matching by similarity, use the fuzzy deduplicator on Pro.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.