Remove Duplicates in Excel
Upload an Excel workbook, choose matching columns and rules, keep the first or last occurrence, and download a clean copy without uploading the file.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb · up to 50MB · or paste a file from your clipboard
Remove Duplicates in Excel Online
Duplicate rows creep into spreadsheets from merged exports, repeated imports, and copy-paste. This free tool lets you remove duplicates in Excel online without writing formulas or installing anything - it lets you compare all columns or selected fields, keep the first or last match, and control how letter case and surrounding spaces are compared. Matching uses the cleaned values, so trimming and text-case transformations run before duplicate comparison. Everything runs entirely in your browser.
How to Remove Duplicate Rows
- Upload your workbook - drag in an .xlsx, .xls, .xlsm, or .xlsb file.
- Choose what counts as a duplicate - all columns, or only specific matching fields like email or ID.
- Choose which occurrence to keep - retain the first match or the last match.
- Set cleanup and matching rules - matching uses cleaned values, so disable trimming when surrounding spaces should count; text-case transformations also run first.
- Remove duplicates - apply the rules and drop the other matching rows.
- Preview and download - review the cleaned sheet and download a new workbook.
In desktop Excel, the equivalent command is Data > Remove Duplicates: select the columns that define a match, then Excel keeps the first row it encounters. Use Conditional Formatting > Duplicate Values or a helper such as =COUNTIF($A$2:$A2,A2)>1 when you want to review repeats before deleting them. The preview above gives you that safety check without changing the original workbook.