happytails.ai

Dataset value mapper

Replace values in one CSV column using an explicit dictionary. Keep every other field and report values without a match.

Select a column and provide a comma-separated replacement CSV with exactly the headers from,to. Each source value must appear once in the dictionary. Matching is exact, case-sensitive and does not trim spaces. An empty source value is allowed. Values in every other column stay unchanged. Keep unmatched values as they are, replace them with empty strings, or stop with an error until the dictionary is complete. The unmatched-values CSV lists each missing value, its record count and its first source-record number. Nothing is guessed from similar spelling or inferred types. Compare the mapped, changed and unmatched record counts with the result preview. Download the mapped CSV, unmatched-values CSV and JSON report. Default formula protection prefixes potentially executable strings with an apostrophe; choose original-string export for trusted machine processing. Change the input or settings to update your result. Results update as you type. Up to 1,000,000 characters.

Your result

Report a problem or share an idea.

How to use Dataset value mapper
  1. Paste CSV and enter the exact column name to map.
  2. Paste a from,to replacement dictionary and choose how unmatched values are handled.
  3. Review the changed records and unmatched report, then download the result.

Useful next steps

CSV row filterCSV cell expansionCSV formula injection checkerCSV unpivot

What to expect

Replace values in one CSV column using an explicit dictionary. Keep every other field and report values without a match. Select a column and provide a comma-separated replacement CSV with exactly the headers from,to. Each source value must appear once in the dictionary. Matching is exact, case-sensitive and does not trim spaces. An empty source value is allowed. Values in every other column stay unchanged. Keep unmatched values as they are, replace them with empty strings, or stop with an error until the dictionary is complete. The unmatched-values CSV lists each missing value, its record count and its first source-record number. Nothing is guessed from similar spelling or inferred types. Compare the mapped, changed and unmatched record counts with the result preview. Download the mapped CSV, unmatched-values CSV and JSON report. Default formula protection prefixes potentially executable strings with an apostrophe; choose original-string export for trusted machine processing.

Try a small example

id,status
001,pending
002,done
003,unknown