Free online JSON to XLS converter
Convert JSON records into an editable Excel 97–2003 workbook.
Convert JSON to XLS 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 .json file
Click to browse to select your file you want to convert or simply drag & drop your file into selected area.
-
2/3
Perform .json to .xls conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .xls file
Conversion result is ready to download.
Conversion statistics: JSON to XLS
Updated November 16, 2026, from conversions on 101convert.com
How to convert json to xls file
- Documents
- No ratings yet.
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.
| 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
Suggested software and links: json to xls converters
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.
Additional formats for
json file conversion
Reverse conversion
Convert to xls from
other formats
- qrp to xls
- dat to xls
- prnx to xls
- qpw to xls
- csv to xls
- et to xls
- ots to xls
- arff to xls
- odb to xls
- shs to xls
- 123 to xls
- _xls to xls
- aws to xls
- bak to xls
- cht to xls
- cwk to xls
- dif to xls
- doc to xls
- docx to xls
- dqy to xls
- ecsv to xls
- ett to xls
- excel to xls
- fods to xls
- fr3 to xls
- gct to xls
- gif to xls
- gsheet to xls
- hst to xls
- htm to xls
- html to xls
- imd to xls
- ios to xls
- iwa to xls
- jpeg to xls
- jpg to xls
- jrprint to xls
- lvm to xls
- mpp to xls
- nbib to xls
- numbers to xls
- odf to xls
- ods to xls
- odt to xls
- oxps to xls
- pages to xls
- pdf to xls
- pmd to xls
- pmv to xls
- png to xls
- por to xls
- prn to xls
- prt to xls
- pxl to xls
- qdf to xls
- rpt to xls
- rtf to xls
- sbp to xls
- sdc to xls
- sdw to xls
- shp to xls
- skv to xls
- slk to xls
- spbm to xls
- spo to xls
- sql to xls
- stw to xls
- sxc to xls
- tbl to xls
- tmp to xls
- txt to xls
- uos to xls
- vsd to xls
- wb1 to xls
- wb2 to xls
- wb3 to xls
- wbd to xls
- wdb to xls
- wk! to xls
- wk1 to xls
- wk3 to xls
- wk4 to xls
- wkq to xls
- wks to xls
- wkz to xls
- wmf to xls
- wps to xls
- wq1 to xls
- wq2 to xls
- wr1 to xls
- wri to xls
- xlc to xls
- xlk to xls
- xlsb to xls
- xlsm to xls
- xlsx to xls
- xlt to xls
- xltm to xls
- xltx to xls
- xlw to xls
- xml to xls
- xps to xls