How JSON Lines files are read
A JSON Lines file has one complete JSON value on each line, and each line becomes one row. Blank lines are skipped. Lines don’t need the same fields: any field that appears in at least one line becomes a column, in the order it first appears.
Many logging tools and data warehouses export JSON Lines with a .json extension. If the first lines of a file are separate JSON values, it’s read as JSON Lines whatever its name.
{"ts":"2026-11-02T09:14:03Z","level":"info","msg":"Started","user":{"id":42}}
{"ts":"2026-11-02T09:14:05Z","level":"warn","msg":"Slow query","ms":1840}
{"ts":"2026-11-02T09:15:11Z","level":"error","msg":"Timeout","user":{"id":42},"retry":true}ts,level,msg,user.id,ms,retry
2026-11-02T09:14:03Z,info,Started,42,,
2026-11-02T09:14:05Z,warn,Slow query,,1840,
2026-11-02T09:15:11Z,error,Timeout,42,,trueHow to convert it
- Choose the file or drop it on this page.
- Check that Rows says each line. If every line holds a list you want as rows instead, such as the items in an order, choose that list.
- Untick the columns you don’t need, rename any you want, then convert and download.
Common problems
An error on the last line
An export that was interrupted often ends with half a line. The error message gives the line number. Delete that line, or export the file again.
Each line holds an array of records
Some tools write a JSON array on each line. Under Rows, choose the list on each line and every element becomes a row.
Records spread over several lines
That works too. The converter reads one complete JSON value after another, whether or not each one fits on a single line, so pretty-printed records separated by line breaks convert the same way.
Questions
Is NDJSON the same as JSON Lines?
For practical purposes, yes. Both mean one JSON value per line. The file can end in .jsonl, .ndjson or .json; the converter looks at the content to tell.
Do all lines need the same fields?
No. Every line is read before the columns are listed, and any field that appears in at least one line gets a column. Lines without that field get an empty cell.
How many lines can a file have?
There is no line limit. Lines are converted in batches as the file is read, so files with millions of lines work. What limits you is free disk space for the CSV, which is usually about the size of the input or smaller.
Are my logs sent anywhere?
No. The file is read and converted in your browser. Nothing is uploaded, which matters for logs that contain user IDs, IP addresses or tokens.
Other converters
To see exactly what happens to your file, read how the converter works, including how to check that nothing is uploaded.
- JSON to CSV: Turn an API response or export into a spreadsheet, with nested fields as columns.
- Large JSON to CSV: Files of hundreds of megabytes, read in pieces so the page doesn’t run out of memory.