Convert JSONL to TSV

Turn JSONL 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 JSONL files on the dialor turn it to pick what to do

Log records as rows in a table.Each JSON object on a line becomes a row in a TSV file.

  1. What you get

    One TSV file. A list of objects becomes one row per object, under a header that holds every key in the order it first appears. A single object becomes one row.

  2. How values are written

    Nested objects and lists are written into their cell as JSON text. A null value leaves its cell empty.

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

  3. When it fails

    The conversion stops with input_corrupted when the file could not be parsed. Check that the input is JSON Lines before you convert it again.

    To go the other way, use TSV to JSONL.

JSONL and TSV.What each format is.

The formats

From · JSONL

JSON Lines

JSON Lines, one JSON object per line, the format of logs and datasets.

Extensions
.jsonl .ndjson
MIME type
application/jsonl
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 JSONL to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.jsonl report.tsv
$ cv convert report.jsonl report.tsv

Questions.What people ask about JSONL to TSV.

01OF 04

It lists every key from the objects, in the order each key is first seen.

Nested objects and lists are written into their cell as JSON text.

No. A null leaves the cell empty.

The file could not be parsed, so the conversion stops.

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