Duplicate Employee Finder
The same employee number on two rows, and the same person entered twice under two different numbers. Those are separate problems and this reports them separately.
Reads .xlsx and .csv inside your browser. Your file never leaves your computer.
The spreadsheet
Drop a spreadsheet here
One employee list. This tool looks inside a single file.
There is no merge button, and there will not be one
Deciding that two records are one person is an HR decision. It affects pay, benefits, service dates and headcount, and getting it wrong deletes somebody who works here. This tool groups candidates, says how confident it is and why, shows you exactly which fields the rows disagree about, and then stops.
What the three levels mean
Certain is mechanical. The same value appears twice in a column you said should never repeat. There is no judgement in it.
Likely means every column you chose agrees, ignoring case, punctuation and word order, so “Smith, Jane” and “Jane Smith” count as the same. Two people share a name often. Two people sharing a name and a hire date almost never happens.
Possible means a near match, and it is the one to read carefully. Smyth against Smith is usually a typo and occasionally two colleagues.
If it says it skipped some rows
Searching for near matches inside a group of similar names costs roughly the square of the group size, so a roster containing several thousand people called Smith would take longer than anyone would wait. Groups above a safe size are skipped for near-matching and reported instead of silently taking forever. Exact matches in those rows are still found. Adding a second column narrows the groups and brings them back into range.