Convert JSONL to NUMBERS

Turn JSONL files into NUMBERS. One sheet named after the file, cut to 31 characters, with a row per line under a header of every key in first-seen order, so a line without a key leaves that cell empty.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A spreadsheet from a log or dataset.Each line of the JSONL file becomes a row in one Numbers sheet.

  1. What you get

    One Numbers file with a single sheet. The sheet is named after the file and cut to 31 characters.

    The header holds every key found in the file, in the order each key first appears. Each line of the JSONL becomes one row under it. If a line does not have a key, that cell stays empty.

  2. How values are written

    Numbers, booleans and plain dates become typed cells, so they work as numbers, booleans and dates in the spreadsheet. Times with a zone stay as text.

    Nested objects and lists do not get their own columns. They are written into their cell as JSON text.

    Numbers keep 15 significant digits. Fonts that Numbers does not have become Helvetica Neue.

  3. Size limit

    A document of more than 300,000 cells fails with unsupported_elements. The cell count is rows times columns, so a file with many lines or many different keys can reach it.

    To join several files before converting, you can merge JSONL first.

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

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

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

terminal
$ cv convert report.jsonl report.numbers
$ cv convert report.jsonl report.numbers

Questions.What people ask about JSONL to NUMBERS.

01OF 04

It takes the name of the file and is cut to 31 characters.

The cell for that key in that row stays empty. The column still exists, because the header lists every key in the file.

They are written into their cell as JSON text. They are not split into separate columns.

The document has more than 300,000 cells. The conversion stops with unsupported_elements at that point.

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