Skip to content

JSON to CSV converter

Convert JSON to CSV as you type. Nothing is uploaded, and the result can be previewed as a table, copied or downloaded.

Loading the converter… It runs locally in your browser.

How to convert JSON to CSV

  1. Paste your JSON into the input panel, drop a file onto it, or press “Open file”.
  2. Pick how arrays should be handled. Nested objects are flattened into dot-path columns automatically.
  3. Check the result: switch the output to “Table” view to see it as a grid.
  4. Press “Copy” or “Download .csv”. The conversion runs on your device, so large files never leave it.

TableForge finds the array of records inside your JSON (even when it sits under a key like "data" or "results"), flattens nested objects into dot-path columns such as address.city, and builds the header from the union of every key, so records with missing fields still line up.

About JSON

JavaScript Object Notation (RFC 8259): nested objects and arrays with strings, numbers, booleans and null. The default payload format of web APIs.

About CSV

Comma-separated values: one record per line, fields split by a delimiter, and fields that contain the delimiter, quotes or line breaks wrapped in double quotes (RFC 4180).

How a JSON tree becomes table columns

A table is flat: every row has the same columns. JSON is a tree. To fit one into the other, each leaf value gets a column named after its path from the top of the record, joined with dots. Toggle the options and watch the header change.

{
  "id": 7,
  "name": "Mae Jemison",
  "address": {
    "city": "Houston",
    "geo": {
      "lat": 29.76
    }
  },
  "missions": [
    "STS-47",
    "Endeavour"
  ]
}
ColumnValue
id7
nameMae Jemison
address.cityHouston
address.geo.lat29.76
missions.0STS-47
missions.1Endeavour

“Column per item” keeps every value searchable but widens the table when arrays are long. “Joined text” keeps one column and suits tags. “JSON text” is lossless, so you can parse it back later.

Why some CSV fields get quotes

A CSV field only needs double quotes when it contains the delimiter, a double quote or a line break. A quote inside a field is written twice ("Katherine ""Kay"" Johnson"). Our interactive CSV format guide lets you type a value and watch exactly which rule applies.

Questions people ask

Is my JSON data uploaded anywhere?

No. The JSON to CSV conversion runs entirely in your browser with JavaScript. The page works offline once it has loaded, and TableForge never receives your data.

How large a file can I convert?

The limit is your device's memory. Files of tens of megabytes (hundreds of thousands of rows) convert fine on a typical laptop. The preview shows the first 200 rows, but the download always contains every row.

How are nested JSON objects converted into columns?

Each value gets a column named after its path, joined with dots, for example address.city. Arrays can become one column per item (tags.0, tags.1), a single joined column (a; b), or JSON text. Records that lack a key simply leave that cell empty.

Can I convert CSV back to JSON?

Yes, use the CSV to JSON converter at tableforge.io/csv-to-json, or the universal converter on the home page.

Related converters