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.
This guide uses the spreadsheet editor. Jev adds decision columns instead.
Open Magic CSVspreadsheet editor example
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 the spreadsheet editor for this?
- Transform values based on your rules
- Expand codes and abbreviations
- Map old values to new standards
Related guides
- Prepare CSV for Import
Rename columns to match your system's requirements
Continue in the spreadsheet editor.
Use the spreadsheet editor, AI columns, and cleanup tools within the same Magic CSV account.