Skip to content

Free online JSONL to XLSX converter

Convert line-delimited JSON records into an editable XLSX workbook.

Convert JSONL to XLSX online - free

Uploading…

Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.

How it works

  1. 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. 2/3

    Perform .jsonl to .xlsx conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .xlsx file

    Conversion result is ready to download.

How to convert jsonl to xlsx file

101convert.com assistant

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

  1. Upload the JSONL file on the converter page.
  2. Select XLSX as the output format and start the conversion.
  3. 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.

Was this information helpful?

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.

Additional formats for
jsonl file conversion

Convert to xlsx from
other formats

Share on social media:

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.