Want to convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel file?
Try Withdata Data File Converter, a JSON lines to Excel converter for Windows, Mac, and Linux, Convert JSON Lines to Excel, Easy and Fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Convert files locally and privately, avoid uploading large JSON file(s) to online services.
Download Withdata DataFileConverter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
JSON Lines text format (JSONL), also called Newline-delimited JSON (NDJSON), or Line-delimited JSON (LDJSON). JSON Lines files may be saved with the file extension .jsonl, *.ndjson, *.ldjson.
Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel file
Choose JSON Lines (JSONL / NDJSON / LDJSON) file -> Set target Excel file -> Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel
Click “Start a New Convert” at task dialog.
then show the wizard.
Select source/target file type.
1. Open a JSON Lines (JSONL / NDJSON / LDJSON) file.
2. Config target Excel file.
3. Set rows options.
4. Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel.
See Excel file
Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel in command line
Save “JSON Lines (JSONL / NDJSON / LDJSON) to Excel” session, then you can:
- Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel in Windows command line.
- Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel in Linux command line.
- Convert JSON Lines (JSONL / NDJSON / LDJSON) to Excel in macOS command line.
Set scheduled tasks for converting JSON Lines (JSONL / NDJSON / LDJSON) to Excel
You can schedule and automate this converting task by:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “JSON Lines to Excel” conversion.
- Set scheduled task for “JSON Lines to Excel” conversion.
FAQ
More tools for JSONL / NDJSON / LDJSON.
Download Withdata DataFileConverter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
JSON Lines → EXCEL reference
Type mapping
| Value kind | in JSON Lines | in EXCEL |
|---|---|---|
| Int | 1234 (number) | 1234 (a real numeric cell) |
| Bigint | 9007199254740993 | 9007199254740993 (exact only while the cell stays text) |
| Decimal | 1234.56 (number) | 1234.56 (numeric cell, format controls the displayed decimals) |
| Float | 1.234e10 (number) | 1.234E+10 (numeric cell) |
| Text | "text" (string) | text cell; leading zeros survive only if the column is text |
| Long text | "multi-line\ntext" | text cell; wraps inside the cell rather than the row |
| Date | "2026-09-18" (string) | a serial number plus a date cell format |
| Datetime | "2026-09-18T14:30:00Z" (string) | a serial number plus a date-time cell format |
| Binary | "base64:..." (string) | not representable as data |
| Boolean | true / false (boolean) | TRUE / FALSE (a real boolean cell) |
| JSON | nested object on the same line | a text cell; the quotes are part of the value |
Dialect differences
Both JSON Lines and EXCEL are file formats, so what differs below is how each one chooses to represent a value.
| Property | in JSON Lines | in EXCEL |
|---|---|---|
| identifiers | Double quotes; backslash escapes (a newline inside a string... | Not applicable; a cell holds exactly one value |
| dates | No date type: dates arrive as strings | Stored as a serial number; only the cell format makes it lo... |
| binary | Not supported natively - base64 inside a string | Only as text or an embedded object, not as a data column |
| separator | Newline between records | Cells, not delimiters |
| encoding | UTF-8 by definition | UTF-8 internally, declared in the package |
| typing | Same as JSON, but records cannot nest across lines | Real cell types: text, number, date, boolean, error |
| shape | Flat stream | Multiple sheets, each a flat grid |
| ceiling | Streams, so it scales past what a single JSON document can ... | 1,048,576 rows x 16,384 columns per sheet; 255 sheets per w... |
Convert JSON to Excel the easy way
Use the JSON to Excel converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).