Convert JSONL to PARQUET

Turn JSONL files into PARQUET. A Parquet table with one row per line and its columns and types inferred by DuckDB; nested objects and lists become structs and lists.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

JSON Lines as a typed Parquet table.Each line becomes one row, with columns and types worked out for you.

  1. What you get

    One PARQUET file with a row for every line of the JSONL file. The columns and their types are inferred by DuckDB from the data in the lines.

    Parquet stores data in typed columns, so the result is a table you can load into analytics tools.

  2. Nested data

    Objects inside a line do not get flattened. A nested object becomes a struct, and a list becomes a list, so the shape of each record is kept in its column.

  3. When it fails

    If the file cannot be parsed, the conversion stops with input_corrupted. This happens when the JSONL file is not valid JSON Lines.

    To go the other way, use PARQUET to JSONL.

JSONL and PARQUET.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 · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

terminal
$ cv convert report.jsonl report.parquet
$ cv convert report.jsonl report.parquet

Questions.What people ask about JSONL to PARQUET.

01OF 04

It makes one PARQUET file.

DuckDB infers the columns and their types from the data in your file. You do not set them yourself, and this conversion has no options.

Nested objects become structs and lists become lists. They are not split into separate columns or rows.

NDJSON files use the same format as JSONL, and the extension ndjson is listed for it. They are read like any other JSON Lines file.

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