Remove duplicate rows in Excel online
Find duplicates in XLSX or XLS by one or more columns. Keep the first or last row, or mark duplicates without deleting them. Files are processed in your browser.
Drag an XLSX or XLS file here, or choose one below. Up to 10 MiB per file.
Set up your task
Your files are processed in this browser. Supported files: XLSX or XLS, up to 10 MiB each.
Excel file
Clear rules and traceable results
Review exactly which rows were grouped and what the tool kept.
Choose your key
Use one column, several columns, or every column to define duplicates.
Keep control
Keep the first row, keep the last row, or mark duplicates without removing them.
Audit each group
The output lists source row numbers, representative rows, and group IDs.
How to remove Excel duplicates
Three steps, all in your browser.
Choose a workbook
Upload an XLSX or XLS file and choose a worksheet and header row.
Set matching rules
Select key columns and decide which row to keep.
Review and download
Check the duplicate counts and download the result with its audit report.
Verwandte Konvertierungen
Zu einer umgekehrten oder verwandten Kontaktdatei-Konvertierung springen.
Excel duplicate remover FAQ
What counts as a duplicate?
Rows are grouped when all selected key columns match under your text matching settings.
Are empty keys removed?
No. Rows whose selected key columns are all empty stay separate.
Does the tool combine values from duplicate rows?
No. It keeps a complete original row or marks rows; it does not merge fields.
Are formulas recalculated?
No. The tool uses saved formula results. Recalculate and save the source if a result is missing.
Does this change my original file?
No. A new XLSX file is generated locally in your browser.
Are all Excel features preserved?
The result focuses on cell values and basic formats. Charts, macros, and other advanced workbook objects are not preserved.
Is this Excel duplicate remover free and private?
Yes. No account or installation is required. Workbook contents are processed in your browser and are not uploaded to a server. Download a new XLSX file when the result is ready.
Can I remove duplicates using multiple columns?
Yes. Select all columns that make up the record key. Selecting customer ID and order ID groups rows only when both values match. Select every column to find duplicate whole rows.
Can I remove duplicates from CSV files?
CSV is not accepted directly. Convert or save it as XLSX first, then select the worksheet and columns to check. The result is downloaded as XLSX.
Dieses Tool bewerten
Ein Klick genügt. So finden andere einen Konverter, der wirklich funktioniert.
Continue working with Excel
Merge, split, deduplicate, and compare your spreadsheets locally.