← All tools
Duplicate Remover
Find and remove duplicate rows in seconds — across one sheet or every sheet in the workbook.
100% Private — files never leave your browser
Click to choose or drag your file here
.xlsx · .xls · .xlsm · .csv — processed locally, never uploaded.
Match treats first row as header
Header row is preserved untouched; data rows are deduped against each other only.
Case-insensitive match
"North" and "north" are treated as duplicates.
Ignore invisible whitespace
Strip non-breaking spaces and zero-width characters before matching, so visually-identical rows are recognised.
Enter to dedupe · Esc to clear
How it works
- Every data row is hashed by joining its cell values with a separator that can't appear in real data.
- If options are on, values are first normalized — case lowercased, invisible characters stripped — so visually identical rows are detected as duplicates.
- Rows are scanned top-to-bottom. The first occurrence of each row is kept; every later occurrence with the same hash is removed.
- Cell styles (bold, colors, borders, number formats), formulas, and dates are preserved through the process.
Every sheet in the workbook is processed independently. The first row of each sheet is kept untouched if “treats first row as header” is on (default). Empty rows are skipped, not counted as duplicates of each other.
You might also need…
Other tools in the ExcelCleansing suite that pair well with this one.