HR Utilities
← All tools

Employee Roster Comparator

Two employee lists in. Who arrived, who left, and which fields changed for everyone in both.

Reads .xlsx and .csv. Both files are read inside your browser and neither one leaves your computer.

Earlier file

Drop a spreadsheet here

The older snapshot. Last month's roster, or the HRIS export.

Later file

Drop a spreadsheet here

The newer snapshot. This month's roster, or the payroll list.

What it is for

Two snapshots of the same workforce, taken a month apart, and the question is what moved. Or two systems that are supposed to agree about who works here and do not, which is the version that matters on payroll day.

It tells you what it assumed. Which column it matched on, how it treated spacing and capitalization, which columns it could not compare because only one file had them, and which rows it excluded. Those choices change the answer, so they are shown with the answer and included in the download.