JSONL to CSV Converter

A JSON Lines dataset turned into a CSV table — one row per line.

Files never leave your device — everything runs in your browser

Looking at a dataset in a spreadsheet is the quickest way to spot problems: empty fields, wrong labels, odd values. The converter reads a JSON Lines or NDJSON file and builds a CSV table with one row per record. Nested objects unfold into dotted columns such as meta.source, and columns from all records are merged.

Pick which columns to keep and in what order, choose the delimiter and decimal separator your spreadsheet expects, and keep the BOM so Excel shows every language correctly. Long IDs are written in full, digit for digit.

A broken line stops the conversion with its line number, so the source can be fixed before the data goes further.

Nothing is uploaded: everything runs inside your browser, so API responses, configs, contact lists and datasets stay on your device.

Options

How to convert JSONL to CSV in 3 steps

  1. 1

    Load the JSONL

    A .jsonl or .ndjson file, pasted lines or the Sample.

  2. 2

    Choose columns

    Select columns, delimiter and flattening depth.

  3. 3

    Download the CSV

    Open it in Excel, Google Sheets or LibreOffice.

Frequently asked questions

Convert it to CSV here and open the CSV in Excel — each record becomes a row.
They become dotted columns like meta.stars; arrays become indexed columns.
Yes, pick them in the options before downloading.
Convert JSONL to JSON first, then use JSON to Excel for a formatted workbook.
Files up to 50 MB are converted in your browser; split bigger datasets into parts first.

Related tools