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.
Related: All guides · FAQ