Micro Tools
Advertisement

JSONL to XLSX converter

Convert JSONL to XLSX free in your browser. Paste your JSON Lines on the left, press Convert, and copy clean XLSX on the right. No sign-up, no uploads.

Converter

Paste JSON Lines below, press Convert, and copy the XLSX output.

Advertisement

How JSON Lines becomes XLSX

Each non-empty line is parsed as its own JSON object and treated as one row, so a 10,000-line file is simply 10,000 rows. The converter collects the union of all keys across lines to build the column set, which means ragged objects with different keys still convert cleanly, with blanks where a line lacked a key.

Tips for the spreadsheet output

Use the preview to sanity-check headers before downloading, especially after converting from JSONL, where column order follows first appearance. The .xlsx opens in Excel, Google Sheets and LibreOffice, so it is a handy handoff format when colleagues need to eyeball or edit the converted data.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

JSONL to XLSX FAQs

What exactly counts as JSON Lines input?
One complete JSON object per line, with no commas between lines and no outer array brackets. Each object becomes one row, and the union of all keys becomes the XLSX columns. Blank lines are ignored, and the tool tells you the exact line number if one line fails to parse.
How do I get the .xlsx file?
Press Convert, check the preview in the output box, then press Download .xlsx. The workbook has one sheet named data with your headers in row 1. It opens in Excel, Google Sheets and LibreOffice with types preserved.
What about nested objects inside a line?
Nested objects and arrays are kept as compact JSON strings inside their cell, so nothing is dropped. If you need them flattened into dotted columns, convert to JSON first and flatten there; this tool keeps the XLSX one row per line.
Is there a size limit for JSONL input?
No hard limit, but everything runs in your browser tab, so tens of thousands of rows convert in seconds while millions of rows may slow the page. For very large JSONL files, split them into smaller chunks and convert each separately.
Is my JSONL data private, and who uses this?
Yes. The conversion runs 100% in your browser with the SheetJS library loaded from CDN; nothing is uploaded to any server. Developers, analysts and DBAs use it to move JSONL data into XLSX for migrations, reports and config work without installing anything.
Advertisement