Excel Duplicate Finder — Compound Key, Full Report
Tick any combination of columns as your key and highlight (or remove) every row that shares the same values. Downloads a ranked “Duplicates Report” sheet with row numbers — all in your browser.
Drop your Excel file here
.xlsx · .xls — up to 100 MB · stays in your browser
Your file is never uploaded · all processing runs in your browser
What is a compound-key duplicate?
A duplicate row in Excel is one where the identifying fields — the key — already exist in another row. The tricky part is that “the key” is rarely a single column. In a customer list, first name alone is not unique. Email alone may not be reliable (the same person with two accounts). But First Name + Last Name + Company together might be unique enough to catch real duplicates without false matches.
A compound key is that combination of two or more columns used together as the unique identifier. Excel's built-in Data → Remove Duplicates supports compound keys for deletion, but it cannot highlight matching rows for review — it only removes them silently. This tool gives you the review step: all duplicate rows are colour-coded so you can decide what to keep, and a ranked report sheet tells you which key combinations repeat most and exactly where they live.
When do you need compound-key duplicate detection?
Single-column duplicate checks miss the real duplicates. Here's when the multi-column approach matters.
CRM and contact list deduplication
A contact list might have "Alice Smith" entered twice — once as alice@company.com and once with a typo. Deduplicating on First Name + Last Name + Company catches the second entry without wrongly flagging two different people with the same name at different companies.
Invoice and order record reconciliation
An order export may legitimately have the same customer ID in multiple rows (multiple orders). The real duplicate is Order ID + Line Item — two rows with the same order and line item number indicate a double-entry error. A compound key on both columns catches it without false positives.
Inventory and SKU catalogues
A product catalogue may have the same SKU appear legitimately in multiple warehouses. The duplicate you are looking for is SKU + Warehouse — not SKU alone. Ticking both columns finds only the real double-entries.
Survey and form response deduplication
Survey exports often have no single unique ID column. The combination of Respondent Email + Survey Date identifies a genuine re-submission — the same person filling in the form twice on the same day — while legitimately allowing yearly repeats from the same email.
HR roster and payroll exports
Employee ID should be unique, but payroll exports often contain one row per pay period per employee. The duplicate you are looking for is Employee ID + Pay Period — not Employee ID alone, which would flag every legitimate monthly row.
Merging data from multiple systems
After combining two exports with VSTACK or copy-paste, the merged sheet has rows from both sources. Finding duplicates on the business key (not a system-generated ID, which differs between systems) locates the actual overlapping records before the merge goes to the database.
Excel Duplicate Detection: SimpleTool vs Built-in vs COUNTIFS Formula
Three approaches to the same problem — different trade-offs.
| Feature | SimpleTool | Data → Remove Duplicates | COUNTIFS helper column |
|---|---|---|---|
| Compound key (multiple columns) | Yes — tick any columns | Yes | Yes (complex formula) |
| Highlights duplicate rows with colour | Yes — two-colour or uniform | No — removes silently | Via conditional formatting rule |
| Distinguishes first occurrence from extras | Yes (yellow vs rose) | No | With extra formula column |
| Ranked report with row numbers | Yes — dedicated sheet | No | No |
| Non-destructive (keeps original file) | Yes — new download | No — modifies in place | Yes (formula-only) |
| Undo available if you make a mistake | Yes (original unchanged) | Only via Ctrl+Z | Yes |
| Works without Excel installed | Yes (browser) | No | No |
| Setup time for a new file | < 1 minute | < 1 minute | 5–15 minutes |
| Case-insensitive matching | Yes (built-in) | No (case-sensitive) | Yes with LOWER() |
Frequently asked questions
What does "compound key" mean?
A compound key is a combination of two or more columns that together uniquely identify a row. For example, "First Name" alone might not be unique, but "First Name + Last Name + Email" together might be. This tool lets you tick any set of columns and treats rows as duplicates only when ALL of those columns match — exactly like a multi-column COUNTIFS in Excel.
How is this different from Excel's built-in "Remove Duplicates"?
Excel's Data → Remove Duplicates can delete duplicate rows across multiple columns, but it cannot visually highlight them — it only removes. This tool can highlight (yellow for first occurrence, rose for extras) without removing anything, which lets you review duplicates in context before deciding what to keep. It also generates a ranked "Duplicates Report" sheet showing which key combinations repeat most and which row numbers they're on.
How is matching done — is it case-sensitive?
Matching is case-insensitive and trims leading/trailing whitespace. So "Alice", " alice ", and "ALICE" are all treated as the same key value. This catches the most common source of false non-matches in real-world data exports.
What does the "Duplicates Report" sheet contain?
The report sheet is added automatically to every downloaded workbook. It lists each duplicate group in a table: the group number, the key column values, how many times that key appears, and the exact row numbers in the original data sheet where those rows are. Groups are sorted by occurrence count so the worst offenders appear first.
Is my file uploaded to a server?
No. All processing runs entirely in your browser using JavaScript. Your file is never sent anywhere — not even temporarily. SimpleTool has no back-end that receives Excel files.
Does "Remove extra copies" change the original file?
No — the tool always produces a new downloaded file. Your original file is unchanged. "Remove extra copies (keep first occurrence)" means the downloaded output will contain only the first occurrence of each duplicate group; the extras are omitted from the download.
Which file formats are supported?
.xlsx and .xls files up to 100 MB. The output is always a .xlsx file. CSV files are not currently supported because they lack sheet and header structure.
More Productivity Tools
Explore our other privacy-focused tools designed to boost your productivity
Excel Password Remover
Remove password protection from Excel files safely in your browser
Excel Books Comparer
Spot differences between two Excel workbooks instantly — no uploads
Excel Data Cleaner
Trim whitespace, fix invisible characters, and remove blank rows — browser-only