Convert JSON to TSV

Turn JSON files into TSV. A list of objects becomes one row per object under a header of every key in first-seen order, and a single object becomes one row.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop JSON files on the dialor turn it to pick what to do

JSON rows in a tab-separated file.Each object becomes one row under a header of its keys.

  1. What you get

    A TSV file with one row per object. If your JSON is a list of objects, every object is a row. If it is a single object, you get one row.

    The header holds every key in the order it is first seen. The result is one file that opens as a table.

  2. How values are written

    Nested objects and lists are written into their cell as JSON text, so the structure is kept inside the cell instead of being spread across columns. A null leaves its cell empty.

    Cells that hold a tab, a quote or a line break are quoted. This keeps each value in its own cell.

  3. When it stops

    If the JSON file cannot be parsed, the conversion stops with input_corrupted. To go the other way, use TSV to JSON.

JSON and TSV.What each format is.

The formats

From · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data
To · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same JSON to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.json report.tsv
$ cv convert report.json report.tsv

Questions.What people ask about JSON to TSV.

01OF 04

It becomes one row under a header of its keys.

The columns follow the order in which each key is first seen in the JSON.

Each one is written into its cell as JSON text. It does not get its own columns.

The cell is left empty.

More conversions.Other ways in and out of JSON and TSV.