Free converter
JSONLCSVJSONL to CSV Converter
JSON Lines is what logs and event streams are written in: one JSON object per line, appended forever. DataTray reads them line by line, unions the fields across records, and gives you a table.
Windows 10/11 (x64) · Free · No account
Drop in your files — CSV comes out Excel-ready by default; switch encoding and delimiter in one click.
Why convert
Why JSONL files defeat ordinary tools
A JSONL file is not valid JSON as a whole — only each line is — so anything that tries to parse the file in one go fails immediately. They are also frequently enormous and rarely consistent: records written last month may have fields this month's do not.
- Turning an application log into something sortable in a spreadsheet.
- Converting an event or analytics export for analysis.
- Flattening a bulk API dump into a table.
- Reading a JSONL file too large for a text editor to open.
How it works
Convert JSONL to CSV in a few clicks
- 1
Open the JSONL
Read line by line, so file size is not a barrier and a malformed line does not sink the run.
- 2
Review the unioned columns
Fields present in some records and not others become columns that are null where absent, rather than causing a failure.
- 3
Write the CSV
Or Parquet, which usually suits a large log far better.
The details
JSONL to CSV, at a glance
- Input
- .jsonl, .ndjson, or newline-delimited .json
- Inconsistent records
- Unioned by field name; missing values become null
- Bad lines
- Collected in a rejects file rather than failing the run
- Size
- Streamed line by line — no whole-file parse
Questions
JSONL to CSV Converter, answered
More converters
Convert something else
Convert JSONL to CSV — free
Converting more than one file? Data Converter does whole folders at once, on your own machine.
Windows 10/11 (x64) · Free · No account
Runs on your own machine · No upload · No watermark