Employee List Cleanup and Matching
Clean employee IDs without losing leading zeros. Match names and sites to the master list and find missing or duplicate records.
Macro-free .xlsx · Includes a worked example
Results from the sample workbook
- 0012
- Deniz · L01
- 0999
- NOT FOUND
- 0042
- DUPLICATE
Who can use it, and for what?
HR and timesheet teams
Reconcile imported rows against the employee master list.
Site and reporting owners
Resolve duplicate IDs before using matched names or site codes in reporting.
A worked example from the workbook
The workbook trims spaces around 0012 and matches Deniz at L01. The master list has no 0999 and contains 0042 twice, so the latter is marked as a duplicate.

| Measure | Sample result |
|---|---|
| 0012 | Deniz · L01 |
| 0999 | NOT FOUND |
| 0042 | DUPLICATE |
How do you start with your own data?
- Enter master IDs, names and sites on the right.
- Paste incoming IDs as text with a source label in the left-hand table.
- Resolve duplicate, missing and unmatched entries before reporting the OK rows.