Job Title Normalizer
One job, written a dozen ways, counted as one. Every change is listed, and none of them is a guess.
Reads .xlsx and .csv inside your browser. Nothing is uploaded.
The file with job titles
Drop a spreadsheet here
Any roster, export or pay file with a job title column. Every other column comes back untouched, with the clean title added beside the original.
Why a pivot table by title is usually wrong
“Sr. Mgr, Ops”, “Senior Manager - Operations” and “Operations Senior Manager” are one job and three rows in a pivot table. Headcount by title, pay by title and any job architecture work all start by counting them apart, and the smaller jobs vanish into dozens of rows of one or two people. So titles are grouped by the words they use, ignoring case, spacing, punctuation, word order, and singular or plural.
Some differences are the job
Engineer II and Engineer III are different jobs. So are Analyst and Senior Analyst. A tool that merges “similar” titles will happily fold them together, and the pay analysis that follows compares people who were never meant to be paid alike. Here the level and the seniority word are always part of the title, so nothing is merged across them. Engineer 2 and Engineer II do join, because they are the same level written two ways.
An abbreviation with two meanings is not guessed
Sr is Senior and Mgr is Manager wherever they appear, so they are expanded. Acct is Accountant in one department and Account in another; Tech is Technician or Technology; Admin is Administrator or Administrative. Those are left exactly as written and listed, so the person who knows the organization makes the call. Rename the group to the full title and it joins the one it belongs with.
Acting, interim and contract are not job titles
“Interim Finance Director” and “Finance Director (Contract)” are finance directors. The status moves to a column of its own, so they count with every other finance director and the status is still there to filter by.
Your file’s own style
Each title is named after the spelling most of your file already uses, tidied, not a list of titles from somewhere else. Any title can be renamed, and any spelling taken back out if it is a different job. The download is your file with four columns added beside the original title: the clean title, seniority, level and status. The Employee Data Cleaner handles the rest of the file’s formatting.
What this does not do
It does not match your titles to a market survey or a job catalog, decide which jobs are equivalent across departments, or set levels. It groups the titles that are plainly the same, lists everything it did, and leaves the judgment calls to you.