Conversion Plan: Non-Registered User
File Size Limit: 10 MB
Conversions: 5 / Daily (up to 50 / Monthly)
Online Converter: Convert JSON Lines (NDJSON) file to Excel (XLSX) format
Set options and click 'Run Conversion' button
Need a custom converter? Build it yourself with AI in minutes!
Chat-based converter creation • Ready in minutes • 100 free AI credits/month, buy more anytime
You may help others to find this website - Share your experience!
Convert JSON Lines (JSONL/NDJSON) files to Excel spreadsheets for data analysis, reporting, and visualization. Transform log files, ML datasets, and streaming exports into formatted Excel workbooks with proper data types.
Perfect for data analysts who need to explore JSONL data using Excel's powerful features like pivot tables, charts, and conditional formatting.
Each JSONL record is a JSON object, and nested fields rarely map cleanly onto a single flat table. The Output layout option lets you choose exactly how nested fields become rows and columns in the Excel. Pick the shape that matches how you will use the data:
One column per field, one row per record. The default, and the best fit for flat or lightly nested JSON.
For JSONL this default uses a fast engine that keeps nested arrays compact. To expand nested fields into rows or columns, pick one of the layouts below.
{"id":"1001","item":[{"sku":"A1"},{"sku":"B7"}]}{"id":"1002","item":[{"sku":"C3"}]}
| id | item |
|---|---|
| 1001 | [{'sku': A1}, {'sku': B7}] |
| 1002 | [{'sku': C3}] |
Two columns, the field path and its value, with one row per value. Ideal for deeply nested or irregular JSON where a fixed set of columns does not fit.
{"id":"1001","item":[{"sku":"A1"},{"sku":"B7"}]}{"id":"1002","item":[{"sku":"C3"}]}
| key | value |
|---|---|
| record/id | 1001 |
| record/item/sku | A1 |
| record/item/sku | B7 |
| record/id | 1002 |
| record/item/sku | C3 |
Every value on its own row alongside its full path. Useful for flattening or auditing all values in one long list.
{"id":"1001","item":[{"sku":"A1"},{"sku":"B7"}]}{"id":"1002","item":[{"sku":"C3"}]}
| path | text | attributes |
|---|---|---|
| record/id | 1001 | |
| record/item/sku | A1 | |
| record/item | ||
| record/item/sku | B7 | |
| record/item | ||
| record | ||
| record/id | 1002 | |
| record/item/sku | C3 | |
| record/item | ||
| record |
The path is split across columns (level 1, level 2, and so on) followed by the value. Good for pivot-style analysis by depth.
{"id":"1001","item":[{"sku":"A1"},{"sku":"B7"}]}{"id":"1002","item":[{"sku":"C3"}]}
| level_1 | level_2 | level_3 | value | attributes |
|---|---|---|---|---|
| record | id | 1001 | ||
| record | item | sku | A1 | |
| record | item | |||
| record | item | sku | B7 | |
| record | item | |||
| record | ||||
| record | id | 1002 | ||
| record | item | sku | C3 | |
| record | item | |||
| record |
Keeps each record on a single row and spreads repeating nested lists into indexed columns (for example line_items/0/amount, line_items/1/amount). The best fit when every record must stay one row even with nested arrays.
{"id":"1001","item":[{"sku":"A1"},{"sku":"B7"}]}{"id":"1002","item":[{"sku":"C3"}]}
| record | id | item/0 | item/0/sku | item/1 | item/1/sku |
|---|---|---|---|---|---|
| 1001 | A1 | B7 | |||
| 1002 | C3 |
The converter creates an XLSX file (Excel 2007+) with your JSONL data organized in rows and columns. JSON keys become column headers, and each JSONL record becomes a row.
For larger datasets, consider JSONL to CSV which has no row limits.
Yes, the converter detects numbers, dates, and text in your JSONL data and formats Excel cells appropriately for accurate calculations and sorting.
It depends on the Output layout. The default table keeps nested arrays compact in a single cell; the key/value, one-row-per-element, nested-levels and one-row-per-record layouts expand array items into their own rows or indexed columns - no manual flattening needed.