Open an Excel workbook or CSV, choose the sheet, confirm the header row, select the columns that define a duplicate, preview what will be kept or removed, compare against a second file when needed, then download a cleaned file.
Runs in browser memory after the page loads
Tested for .xlsx and UTF-8 .csv files up to 8 MB
Exports value snapshots, not formulas or workbook styling
Browser-local tool
Preview and delete duplicate rows
Drop an .xlsx or .csv fileTested up to 8 MB, 50,000 rows per sheet, and 200 columns.
Choose an XLSX workbook or UTF-8 CSV to start.
What This Excel Duplicate Remover Does
This tool removes duplicate rows from a selected worksheet or CSV table. It can match an entire row or a chosen set of columns, which is useful when a customer ID, email address, SKU, invoice number, or multi-column key should decide whether rows are duplicates.
It can also compare the selected rows with a second spreadsheet in the same browser session. That comparison uses the same column positions and match rules, so align the files before relying on cross-file matches.
For Excel workbooks, every worksheet is exported in the original sheet order. The selected sheet is cleaned; other sheets are copied as displayed values. The download is verified by parsing the generated file before a link is created.
Matching Rules
Default matching uses the displayed cell text. Values that display the same compare as duplicates.
Choose one or more columns for a combined duplicate key.
Optional trim ignores leading and trailing spaces while comparing.
Optional case-insensitive matching treats values like APPLE and apple as the same key.
Completely empty rows are kept and are not counted as duplicate groups.
Blank cells inside selected columns compare as blank values.
Export Limits
Version one supports `.xlsx` and UTF-8 `.csv`. It does not support password-protected files, `.xls`, `.xlsm`, `.ods`, macros, comments, external links, pivot tables, charts, images, formulas, or cell styling preservation. Formula cells are read from their cached displayed value when the workbook includes one.
Need Excel's Built-In Tool?
Excel's own Remove Duplicates command is still the best choice when you need to edit the original workbook inside Excel. Use this web tool when you want a browser-local preview, alternate keep strategies, or a quick cleaned copy without changing the source file.