Data & CSV
CSV value recoder
Apply an explicit whole-cell value map without substring replacements.
A clear answer. Here’s how.
Maps exact case-sensitive From values to To values simultaneously. Duplicate From keys are rejected; empty mappings are allowed. Unmatched values follow the chosen keep/blank/error rule. This replaces complete cells and preserves identifiers; it does not use patterns, trim text or perform sequential find-and-replace.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV
ID,Name,Team,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07
- Column separator
- Comma
- Column to recode
- Team
- Value map: From,To
From,To Design,Creative Writing,Editorial
- Unmapped values
- Keep original
Example result
| ID | Name | Team | Amount | Date |
|---|---|---|---|---|
| 001 | Ada | Creative | 120 | 2026-01-05 |
| 002 | Sam | Editorial | 80 | 2026-01-06 |
| 003 | Jo | Creative | 150 | 2026-01-07 |
Exact, case-sensitive cell values are mapped simultaneously. No substring or pattern replacement.