MurphkitschTHE ODDLY USEFUL TOOL LAB
한국어
Home / Text & data

CSV to JSON Converter

Run CSV to JSON Converter using the supplied input and options.

CSV has header row. XML conversion uses root/item with attributes under @attributes; mixed content is rejected. Reverse conversion is not always lossless.

Your workbenchInputs are not stored

Result

Enter your values and run the tool to see your result.

What this tool does

Converts between CSV and JSON. The first CSV row becomes the column names and each row becomes an object; in reverse, object keys become column names.

How to use it

  1. Paste the data.
  2. Choose the direction: forward for CSV to JSON, reverse for JSON to CSV.
  3. Run it and confirm the row count and column names.

Worked example

The two lines name,value and Ada,42 convert forward into a JSON array holding one object with name and value.

Frequently asked questions

Do commas inside values break it?
No. Quoted fields are treated as a single value including the comma, as in "Seoul, Korea".
Leading zeros in postcodes disappear.
They can be read as numbers on the way to JSON. Quote non-numeric identifiers in the CSV and check that they stay strings in the output.

What this tool does not cover

Input is processed in your browser. Nested objects and arrays cannot be fully represented in a flat table.

References