How to convert and transform column values in a CSV
Your column values need to be transformed: codes need to be expanded, abbreviations spelled out, or values need to be mapped to new formats.
See it in action
Prompt
"Expand state abbreviations to full names and status codes to labels"
Before
| # | customer | state | status |
|---|---|---|---|
| 1 | Acme Corp | CA | A |
| 2 | Tech Inc | NY | P |
| 3 | Sales Co | TX | A |
After
| # | customer | state | status |
|---|---|---|---|
| 1 | Acme Corp | California | Active |
| 2 | Tech Inc | New York | Pending |
| 3 | Sales Co | Texas | Active |
Why use Magic CSV for this?
- Transform values based on your rules
- Expand codes and abbreviations
- Map old values to new standards
Ready to transform your data?
Upload your CSV, describe what you want, get clean data back.