Skip to content
JSONRow
Colour theme

JSON Lines to CSV converter

For log files, event streams and exports where every line is a separate JSON record, also called NDJSON. Your file is processed on this device. Nothing is uploaded.

Choose a JSON Lines file, or drop it here

One JSON value per line (.jsonl, .ndjson, or .json). Large files are fine; very large ones depend on your device’s memory.

Your file is processed on this device. Nothing is uploaded.

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.

events.jsonl
{"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}
events.csv
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,,true

How to convert it

  1. Choose the file or drop it on this page.
  2. 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.
  3. 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.

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.