Choose your tool

DATA TOOL

CSV Category Mapping Applier

Replace exact column values using an explicit JSON string dictionary.

â—‡ Browser only
0 lines · 0 characters
Ready when you are
Your results will appear here.
Copy or download your result below.
LESS BUSYWORK, MORE DONE

Three steps. That’s it.

A useful toolkit for text, data, images and calculations.

  1. 01

    Add your input

    Choose a tool, enter values or select a file.

  2. 02

    Make it yours

    Adjust the options and run the action.

  3. 03

    Take the result

    Copy the result or download its file.

Replace exact column values in CSV data online

Replace exact column values using an explicit JSON string dictionary. Use this when inspecting structured input or preparing a data or code artifact. Generated commands and configurations remain text until you review and use them yourself.

How to use it

Paste the multi-line input in the format shown below. Supply value mapping json in the second input. Set category column. Choose Run tool. Review the output, then copy or download it.

Options and example settings

OptionChoices / valueExample default
Category columnEnter category column.team

Worked examples

Use this when inspecting structured input or preparing a data or code artifact. Generated commands and configurations remain text until you review and use them yourself.

Reproducible worked example

Settings: Category column: team

Input:

name,team,amount
Anna,A,10
Ben,B,20
Cara,A,30

Value mapping JSON:
{"A":"Alpha","B":"Beta"}

With the input and settings above, the tool produces:

Output:

name,team,amount
Anna,Alpha,10
Ben,Beta,20
Cara,Alpha,30

The example output has 4 lines. Compare its order, separators and whitespace with the input before copying the result.

Limitations and common mistakes

  • Results reflect your supplied input and selected settings. Check the worked example and output before reuse.
  • Combined input is bounded to 150,000 characters; output text is bounded to 1.2 million characters. Some algorithms impose smaller limits, stated in their error messages.
  • Both inputs must follow their own documented format. Changing direction or mode can require different input; the example is for the displayed settings.

Frequently asked questions

What format should I enter?

Paste the multi-line input in the format shown below. The second input is value mapping json. The worked example shows the supported structure and actual output.

How can I replace exact column values in CSV data online?

Paste the multi-line input in the format shown below. Supply value mapping json in the second input. Set category column. Choose Run tool. Review the output, then copy or download it.

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.

Useful next tools

Explore other tools

Open a tool below, use the search, or choose a category to browse its full collection.