NDJSON & JSON Lines (.jsonl) to Excel - Complete Guide
Last updated: 23 May 2026
NDJSON (Newline Delimited JSON), also called JSON Lines or JSONL, is one JSON value per line - common for logs, streams, and database exports. This guide explains how to turn those files into a single Excel worksheet you can filter and share.
NDJSON vs regular JSON
A standard JSON file is often one array or one object. NDJSON is many small JSON documents separated by newlines:
{"id":1,"event":"login"}
{"id":2,"event":"purchase"}Tools that only accept a single parse fail on NDJSON. A JSON Lines to Excel converter reads line by line and builds one row per object.
File extensions
Upload files named .jsonl or .ndjson. Content is the same format; the extension helps the parser choose the line-based strategy. Each line must be valid JSON (usually an object). Comment lines starting with # or // are skipped when present.
How to convert NDJSON to Excel
- Export or save your log stream as .jsonl or .ndjson.
- Upload to the online converter (up to 15 MB).
- Preview columns - keys from all lines are merged.
- Download the .xlsx file.
Troubleshooting
- Single-line file: If you only have one JSON object, save it as .json instead.
- Trailing commas: NDJSON does not allow commas between lines - only one value per line.
- Mixed schemas: Different keys per line become separate columns; missing keys leave blank cells.
Frequently asked questions
- How do I convert NDJSON to Excel?
- Open the converter, upload your .ndjson or .jsonl file (up to 15 MB) or paste the text, preview the merged columns, and click Download Excel. The tool reads each line as a separate JSON object and builds one row per line, so the result opens cleanly in Excel, Google Sheets, or LibreOffice.
- Can I convert JSONL or .jsonl (JSON Lines) to Excel?
- Yes. JSON Lines (.jsonl) and NDJSON are the same newline-delimited format - one JSON object per line. Upload either extension and the parser uses the line-based strategy automatically, turning every line into a spreadsheet row.
- What is the difference between NDJSON and a JSON array in Excel?
- A JSON array wraps all records in one [ ... ] block, while NDJSON lists one JSON object per line with no commas or surrounding brackets. Both become one row per object in Excel - NDJSON is simply the format used for logs and streaming exports. If you only have a single object, save it as .json instead.
- What is the difference between JSON and JSONL (JSON Lines)?
- A .json file holds a single JSON value - usually one object or one array of records. A .jsonl file (JSON Lines, also called NDJSON) holds many independent JSON objects, one per line, with no commas or wrapping brackets. Both convert to the same spreadsheet here, one row per record. JSONL is preferred for large logs and streaming exports because each line can be read on its own.
- Is the NDJSON to Excel converter free?
- Yes, it is completely free with no signup and no payment. Convert up to five files per batch, each up to 15 MB, and run as many batches as you need. Conversion happens entirely in your browser, so your data never leaves your device.
Related guides
- JSON to Excel
- Nested JSON to Excel
- Postman JSON to Excel
- API Response to Excel
- JSON to CSV vs Excel
- JSON Array to Excel
- MongoDB / Firebase to Excel
- GST JSON to Excel
- Best JSON to Excel Converter
- How to Open JSON
- JSON to Google Sheets
See all guides or the FAQ.