Find Duplicates in Excel
See which rows repeat and how many times - by the whole row or a key column like email or ID - without deleting anything or writing a COUNTIF. Everything runs in your browser.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB · or paste a file from your clipboard
How to Find Duplicates in Excel Online
- Upload your file - drop in an .xlsx, .xls, .xlsm, .xlsb, or .csv file.
- Choose what counts as a duplicate - the whole row, or key columns like email or ID.
- Review the highlights - duplicate rows are flagged and counted; first occurrences and repeats are shaded differently.
- Download - export just the duplicates (with counts) or an annotated copy of the whole sheet.
Find vs. Remove Duplicates
Excel's built-in Remove Duplicatesdeletes repeats immediately, which is risky when you haven't checked what will go. This tool does the opposite: it finds and counts duplicates so you can review them first. When you are ready to delete, use our Remove Duplicates tool. For the manual route, select a column and use Home > Conditional Formatting > Duplicate Values, or add =COUNTIF($A$2:$A2,A2)>1 as a helper column. Those methods flag one field at a time; the controls above can match on several key columns and export the reviewed rows.
Features
- Highlight and count duplicate rows without deleting
- Match on the whole row or selected key columns
- Ignore case and extra spaces
- Download only duplicates, or an annotated full sheet
- Works on .xlsx, .xls, .xlsm, .xlsb, and .csv - 100% in your browser