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 CSV

spreadsheet editor example

Prompt
"Expand state abbreviations to full names and status codes to labels"
Before
#customerstatestatus
1Acme CorpCAA
2Tech IncNYP
3Sales CoTXA
After
#customerstatestatus
1Acme CorpCaliforniaActive
2Tech IncNew YorkPending
3Sales CoTexasActive

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

Continue in the spreadsheet editor.

Use the spreadsheet editor, AI columns, and cleanup tools within the same Magic CSV account.

How to convert and transform column values in a CSV | Magic CSV