CSV ⇄ JSON Converter

Guide: JSON vs YAML vs XML vs CSV: Choosing a Data Format

Delimiter

First row is the headerDetect numbers, booleans and empty values

CSV input

id,name,city,active,score
1,Ann Lee,"Austin, TX",true,9.5
2,Bob Ray,Lagos,false,7
3,"Cy ""CJ"" Jones",Paris,true,

id,name,city,active,score
1,Ann Lee,"Austin, TX",true,9.5
2,Bob Ray,Lagos,false,7
3,"Cy ""CJ"" Jones",Paris,true,

JSON output (3 rows)

[
  {
    "id": 1,
    "name": "Ann Lee",
    "city": "Austin, TX",
    "active": true,
    "score": 9.5
  },
  {
    "id": 2,
    "name": "Bob Ray",
    "city": "Lagos",
    "active": false,
    "score": 7
  },
  {
    "id": 3,
    "name": "Cy \"CJ\" Jones",
    "city": "Paris",
    "active": true,
    "score": null
  }
]

[
  {
    "id": 1,
    "name": "Ann Lee",
    "city": "Austin, TX",
    "active": true,
    "score": 9.5
  },
  {
    "id": 2,
    "name": "Bob Ray",
    "city": "Lagos",
    "active": false,
    "score": 7
  },
  {
    "id": 3,
    "name": "Cy \"CJ\" Jones",
    "city": "Paris",
    "active": true,
    "score": null
  }
]

Nothing you enter or choose here leaves your device. This tool runs in your browser.

How to use

1Choose CSV to JSON or JSON to CSV.
2Paste your data. The delimiter is detected, or you can pick one.
3Set whether the first row is a header and whether to detect numbers and booleans.
4Click Copy output or Download.

Frequently asked questions

Does it handle commas and line breaks inside fields?

Yes. Fields wrapped in double quotes can contain commas, line breaks and doubled quotes (""), as in the CSV standard (RFC 4180).

What does "detect numbers, booleans and empty values" do?

It turns 42 into a number, true and false into booleans, and empty cells into null. Turn it off to keep every value as text, which keeps leading zeros such as 007.

What JSON can be turned into CSV?

A list of objects (columns are the keys from all objects) or a list of lists. Nested objects and arrays are written into the cell as JSON text.

Is my data uploaded?

No. Conversion runs in your browser, so private spreadsheets stay on your device.

Read the guide

Learn how this works and how to get the most from it.

Developer

JSON vs YAML vs XML vs CSV: Choosing a Data Format

The strengths and weaknesses of JSON, YAML, XML and CSV, with simple advice on which to use for APIs, config files and spreadsheets.

1 min read

JSON Formatter & Validator

Prettify, minify and validate JSON, with error line numbers.

YAML ⇄ JSON Converter

Convert YAML to JSON and JSON to YAML with error line numbers.

Sort & Dedupe Lines

Sort lines A-Z, reverse them, remove duplicates and trim whitespace.

Text Diff Checker

Compare two texts side by side and see exactly what changed.