JSONL to CSV Converter
Paste JSON Lines (one JSON value per line) or upload a .jsonl / .ndjson file. Errors include the line number.
Convert JSON Lines (JSONL or NDJSON) to CSV
JSONL stores one JSON value on each line rather than wrapping every record in one large JSON array. This tool reads each non-empty line as a separate record, checks the JSON syntax line by line, and combines the records into a CSV table.
Example JSONL input
{"id":1,"name":"Ayesha","city":"Lahore"}\n{"id":2,"name":"Bilal","city":"Karachi"}Helpful JSONL conversion notes
Blank lines are ignored. If a line contains invalid JSON, the tool reports the line number so you can find and correct the problem. Nested object properties are flattened into dot-separated columns, while array values remain JSON text in a cell. Use files with .jsonl or .ndjson extensions.
Frequently asked questions
What is the difference between JSON and JSONL?
A standard JSON array contains multiple records inside one JSON document. JSONL places one JSON record on each separate line.
Can I convert NDJSON files?
Yes. NDJSON uses the same newline-delimited record format and can be pasted or selected as a file.
Why does conversion show a line error?
That line may contain invalid JSON, such as a missing comma, quotation mark or closing bracket.
Related Free JSON and Data Conversion Tools
Explore these related browser-based utilities to prepare, check, and convert structured data for your workflow.
Work with JSON Lines and NDJSON files
JSON Lines (JSONL), also called newline-delimited JSON (NDJSON), stores one complete JSON value on each non-empty line. It is commonly used for application logs, data exports and streaming pipelines because records can be processed line by line.
For conversion, each non-empty line should contain a valid JSON object. The converter reads the lines as separate records and builds CSV columns from the fields it finds. If a line contains malformed JSON, use the reported line number to locate and correct that record, then run the conversion again.
JSONL is different from a standard JSON array: do not wrap the entire file in square brackets or add commas between lines unless you are deliberately converting it to ordinary JSON first. Review the CSV preview to confirm that the records and columns look as expected.