Convert JSONL to XLSX

Turn JSONL files into XLSX. 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

Log lines as rows in a sheet.Each line becomes a row, and each key becomes a column.

  1. What you get

    One XLSX file with one sheet. The sheet is named after the file and cut to 31 characters.

    The first row is a header with every key found in the file, in the order each key first appears. Each line of JSONL becomes a row under it.

  2. How values are written

    Numbers, booleans and plain dates become typed cells, so Excel treats them as numbers, booleans and dates. Times with a zone stay as text.

    Nested objects and lists are written into their cell as JSON text. They are not split into extra columns.

    A line that lacks a key leaves that cell empty. Lines do not need to have the same keys.

  3. When it stops

    A file that cannot be parsed stops the conversion with input_corrupted. The conversion does not produce a sheet for it.

    To combine several files first, merge JSONL. To combine workbooks afterwards, merge XLSX.

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

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

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

terminal
$ cv convert report.jsonl report.xlsx
$ cv convert report.jsonl report.xlsx

Questions.What people ask about JSONL to XLSX.

01OF 04

Yes. NDJSON files use the same line-by-line layout, and the extension is listed as JSONL input.

The header holds every key in first-seen order. A line without a key leaves that cell empty.

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

Plain dates become typed cells. Times with a zone stay as text.

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