JSON Lines (JSONL) to CSV converter

How to use it

1. Enter json lines records and output csv delimiter.
2. The result appears straight away and updates as you edit.
3. Copy the result, or copy a link that keeps the same values to share it.

How it is calculated

Each non-empty line is read with JSON.parse and must be an object. Columns are all keys in order of first appearance. null becomes an empty cell, nested objects and arrays are written as JSON text, and the table is written with RFC 4180 rules.

Example

Inputs: Output CSV delimiter = Comma ,. Result: CSV: product,price,tags,stock Tea,12.5,"[""hot""]", Coffee,18,,; Records: 2; Columns: 4.

{"product":"Tea","price":12.5,"tags":["hot"]}
{"product":"Coffee","price":18,"stock":null}

product,price,tags,stock
Tea,12.5,"[""hot""]",
Coffee,18,,

Limits and caveats

• Nested objects are not flattened into separate columns; they are written as JSON text in one cell.
• A regular JSON array [ ] is not JSONL; put one object per line first.