Skip to content

Free online JSON to XLS converter

Convert JSON records into an editable Excel 97–2003 workbook.

Convert JSON to XLS 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 .json 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 .json to .xls conversion

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

  3. 3/3

    Download converted .xls file

    Conversion result is ready to download.

Conversion statistics: JSON to XLS

JSON files are most often converted to PLIST 23% TXT 23% XML 23% SQLITE 15%

Updated November 16, 2026, from conversions on 101convert.com

How to convert json to xls file

Applications and APIs often provide records as JSON, while older business systems or spreadsheet workflows may require an Excel 97–2003 workbook. Converting the data to XLS lets recipients open and edit it in spreadsheet software that does not accept JSON.

What JSON is

JSON (JavaScript Object Notation) is a text format for structured data used by web APIs, applications, and configuration files. It represents values as objects, arrays, strings, numbers, booleans, and null; arrays of objects can map naturally to table rows, but nested values need to be flattened or stored as text.

What XLS is

XLS is Excel’s binary workbook format for Excel 97–2003. It supports worksheets, formulas, and cell formatting, and remains useful when a recipient or older system specifically requires that format. Each worksheet is limited to 65,536 rows and 256 columns, including a header row; XLS is not the newer XLSX format.

Online on 101convert.com

Select the JSON-to-XLS converter on this page, upload one or more JSON files, and start the conversion. Download the resulting XLS file or files when it finishes. Batch conversion is supported, and the per-file size limit is shown on the page. The conversion runs on the service’s server with LibreOffice.

Offline with desktop software

Python with xlwt (free): Python runs on Windows, macOS, and Linux, and the xlwt package writes legacy XLS files. This example expects a top-level JSON array of objects. Each object becomes a row, and the union of their keys becomes the columns. Install the package with python -m pip install xlwt, save the script as convert.py beside input.json, then run python convert.py.

import json
import xlwt

with open('input.json', encoding='utf-8') as f:
    records = json.load(f)
if not isinstance(records, list) or any(not isinstance(r, dict) for r in records):
    raise ValueError('Expected a JSON array of objects')

columns = list(dict.fromkeys(k for record in records for k in record))
if len(records) + 1 > 65536 or len(columns) > 256:
    raise ValueError('Data exceeds the XLS worksheet row or column limit')

book = xlwt.Workbook()
sheet = book.add_sheet('Data')
for col, name in enumerate(columns):
    sheet.write(0, col, name)
for row_num, record in enumerate(records, start=1):
    for col, name in enumerate(columns):
        value = record.get(name)
        if isinstance(value, (dict, list)):
            value = json.dumps(value, ensure_ascii=False)
        if value is None:
            value = ''
        if isinstance(value, str) and len(value) > 32767:
            raise ValueError('A cell exceeds the XLS text limit')
        sheet.write(row_num, col, value)
book.save('output.xls')

Nested values are saved as JSON text in one cell, not expanded into columns. Convert identifiers with leading zeros or long integers to text if they must remain exact; spreadsheet numeric cells can alter their representation.

Navicat Premium (commercial): Import the JSON file into a database table, map its fields to table columns, then export the table as Excel 97–2003. In Navicat, use Tools → Import Wizard to select the JSON source and load the data; select the resulting table and use Tools → Export Wizard, choosing the Excel 97–2003/XLS output option. The data must fit a tabular structure, and available labels can vary by version.

Data and compatibility limits

Review the output for inferred types, missing fields, and nested data. XLS allows at most 65,536 rows and 256 columns per worksheet, and a cell can contain at most 32,767 characters. If the data exceeds these limits, use a format such as XLSX instead when the receiving system allows it.

JSON vs XLS: format comparison

How the JSON and XLS formats compare on the properties that matter most for this conversion.

Comparison of the JSON and XLS file formats
Property .JSON JavaScript Object Notation .XLS Microsoft Excel Spreadsheet
Open standard Yes No
Compression Uncompressed Both
Typical file size Small Medium
Opens in a web browser Yes, natively Partial
Further editing Easy Limited
Metadata support None Basic
Plain-text readable Yes No
Best used for Data exchange Data exchange
Introduced 2001 1987
Developer Douglas Crockford / ECMA International Microsoft
MIME type application/json application/vnd.ms-excel

Information about file extensions and file types is provided by File-Extensions.org

Frequently asked questions

Is the JSON to XLS converter free?

Yes, converting JSON to XLS 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 JSON file be?

You can upload JSON files up to 10 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 1000 MB per file and 100 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 JSON to XLS?

No. The JSON to XLS 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 JSON file for this JSON to XLS 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.

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.