Free online JSONL to XLSX converter
Convert line-delimited JSON records into an editable XLSX workbook.
Convert JSONL to XLSX online - free
Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.
Import a file from a URL
Paste a direct link to the file. We download it to our server and it is converted exactly like an upload.
How it works
-
1/3
Upload your .jsonl file
Click to browse to select your file you want to convert or simply drag & drop your file into selected area.
-
2/3
Perform .jsonl to .xlsx conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .xlsx file
Conversion result is ready to download.
How to convert jsonl to xlsx file
- Internet
- No ratings yet.
101convert.com assistant
6m
JSONL exports from APIs, log pipelines, and data tools often need conversion before staff can filter, edit, or share records in spreadsheet software. XLSX is a practical target when recipients use Excel or need a workbook for review and reporting.
What JSONL is
JSONL (JSON Lines) stores one JSON value per line, usually one object representing a record. Applications, API clients, and data-processing tools use it for streaming exports and logs because records can be read or appended line by line. Unlike a single JSON array, each line is a separate JSON document.
What XLSX is
XLSX is the spreadsheet workbook format used by Microsoft Excel and supported by LibreOffice Calc and other spreadsheet programs. It organizes data into rows and columns and supports sorting, filtering, formulas, formatting, and multiple sheets, making it useful for editing and sharing tabular records.
How to convert JSONL to XLSX
Online on 101convert.com
- Upload the JSONL file on the converter page.
- Select XLSX as the output format and start the conversion.
- Download the converted workbook when it is ready. Multiple files can be converted in one batch; the page shows the per-file size limit.
Offline with desktop software
Python and openpyxl work on Windows, macOS, and Linux. Install openpyxl with python -m pip install openpyxl, save the following as convert.py beside input.jsonl, then run python convert.py:
import json
from openpyxl import Workbook
rows = []
columns = []
with open("input.jsonl", encoding="utf-8") as source:
for line_number, line in enumerate(source, 1):
if not line.strip():
continue
record = json.loads(line)
if not isinstance(record, dict):
raise ValueError(f"Line {line_number} is not a JSON object")
for key in record:
if key not in columns:
columns.append(key)
rows.append(record)
workbook = Workbook()
sheet = workbook.active
sheet.title = "Data"
sheet.append(columns)
for record in rows:
for column_number, key in enumerate(columns, 1):
value = record.get(key)
if isinstance(value, (dict, list)):
value = json.dumps(value, ensure_ascii=False)
if isinstance(value, int) and not isinstance(value, bool) and abs(value) >= 10**15:
value = str(value)
cell = sheet.cell(row=sheet.max_row + 1, column=column_number, value=value)
if isinstance(value, str):
cell.data_type = "s"
workbook.save("output.xlsx")
This expects each nonblank line to contain a JSON object. It creates one worksheet, adds a column for every key found, and stores nested objects or arrays as JSON text in a cell. The script forces strings to remain text rather than spreadsheet formulas.
Microsoft Excel with Power Query can also load line-delimited JSON on desktop versions that include Power Query. Choose Data → Get Data → From Other Sources → Blank Query, open Advanced Editor, and replace the query with the code below; change the file path to your JSONL file. Choose Home → Close & Load, then save the workbook as XLSX using File → Save As.
let
Lines = Lines.FromBinary(File.Contents("C:\data\input.jsonl"), null, 65001),
Parsed = List.Transform(
List.Select(Lines, each Text.Trim(_) <> ""),
each Json.Document(Text.ToBinary(_))
),
Columns = List.Union(List.Transform(Parsed, each Record.FieldNames(_))),
Output = Table.FromRecords(Parsed, Columns, MissingField.UseNull)
in
Output
Quality and compatibility
Spreadsheet cells hold scalar values, so nested JSON objects and arrays must be flattened or kept as text; the Python example keeps them as JSON text. Excel has a limit of 1,048,576 rows and 16,384 columns per worksheet. Excel also has about 15 significant digits of numeric precision, so long IDs should be treated as text; the script converts large integers to strings, but other numeric values may still be rounded by spreadsheet software.
Note: This jsonl to xlsx conversion record is incomplete, must be verified, and may contain inaccuracies. Please vote below whether you found this information helpful or not.
Information about file extensions and file types is provided by File-Extensions.org
Frequently asked questions
Is the JSONL to XLSX converter free?
Yes, converting JSONL to XLSX on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.
How large can my JSONL file be?
You can upload JSONL files up to 3 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 100 MB per file and 20 files at once, see our plans.
What happens to my uploaded files?
Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.
Do I need to install any software to convert JSONL to XLSX?
No. The JSONL to XLSX conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.
Did the conversion fail?
In most cases, the cause is an incorrect file format. Please upload a valid JSONL file for this JSONL to XLSX conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.