Can multiple arrays become multiple sheets?

Yes: a top-level object whose values are arrays becomes one sheet per key.

How large can the JSON be?

Up to Excel’s 1,048,576 rows per sheet; the browser handles tens of megabytes of JSON comfortably.

Are dates recognised?

ISO date strings are converted to Excel dates so they sort and filter correctly.

Data & Spreadsheets

JSON to Excel

Give an API export to someone who lives in Excel: records become rows, keys become a bold header row, numbers are real numbers you can sum.

Runs in your browser — files never leave your device.

Drop JSON, TXT files here

or click to browse · paste from clipboard · up to 100 MB each

Select files

Options

Path to the array (optional)

Arrays inside records

Freeze header row and auto-size columns

Why convert JSON to Excel (XLSX)

Compared with going through CSV, exporting straight to XLSX keeps data types (numbers, dates, booleans), sets column widths and freezes the header row, so the file is ready to use rather than ready to fix.

Nested objects are flattened into dotted columns; arrays are joined or split into columns, exactly as in JSON to CSV.

How it works

Drop JSON, TXT files onto the box above, click it to browse, or paste from the clipboard.
Adjust the options if you need to — the defaults suit most cases.
Press Convert. The work happens on your device, so speed depends on your computer or phone.
Download the Excel (XLSX) — individually or all at once.

About the formats

JSON · JavaScript Object Notation · .json

The data format of web APIs: nested objects and arrays in plain text, readable by every programming language.

JSON supports nesting; converting it to a flat table (CSV, Excel) requires flattening nested keys such as address.city.
JSON has no comments and requires double quotes around keys and strings.
A JSON array of objects maps naturally to a spreadsheet: one object per row, keys as column headers.

TXT · Plain text · .txt

Just characters, no formatting: the most portable format there is, opened by every editor ever written.

Plain text has no fonts, colours or images; only the words, line breaks and tabs survive.
Encoding matters: UTF-8 is the modern default; older Windows files may use Windows-1252 and show odd characters for accented letters.
Line endings differ between Windows (CRLF) and macOS/Linux (LF), which some tools care about.

Excel (XLSX) · Microsoft Excel workbook · .xlsx

The current Excel format: multiple sheets, formulas, formatting, charts and pivot tables in one file.

XLSX stores both the formula and its last computed value, so a converted CSV contains the values.
Maximum 1,048,576 rows and 16,384 columns per sheet.
XLSM is the same format with macros enabled.

Related conversions

Excel to JSONOn-deviceExcel sheets to JSON arrays with typed values.JSON to CSVOn-deviceJSON arrays flattened into CSV columns.CSV to ExcelPopularOn-deviceCSV into a proper Excel workbook, delimiter auto-detected.Excel to CSVPopularOn-deviceExcel sheets to CSV with chosen delimiter and encoding.CSV to JSONOn-deviceCSV rows into a JSON array of objects.ODS to ExcelOn-deviceLibreOffice Calc ODS to Excel XLSX.

More in Data & Spreadsheets · All converters