Category Value Mapper (Standardise Messy Labels)
Standardises category labels: first see all distinct values with counts, then write mappings and apply them to all rows.
Use the tool
Why this tool exists
NY, ny and New York are one state to you and three values to a pivot table. Leave the mapping box empty to get the list of distinct values with counts, copy it, and write the mappings as old => new.
Values without a mapping are kept and listed in the summary, so you know what is left to fix. Matching can ignore case. For automatic grouping of similar spellings use the fuzzy match tool first and then map the results.
How to use it
- Paste the CSV and name the column.
- Leave the mapping box empty to list distinct values.
- Write old => new lines in the second box.
- Copy or download the mapped CSV.
Frequently asked questions
Can I map several values to one?
Yes, one line per old value.
Is matching case sensitive?
Yes unless you tick ignore case.
Does it trim?
With ignore case, surrounding spaces are ignored too.
Where is the mapping saved?
Nowhere; keep your mapping text.