JSON to XLSX Converter

Overview

Turn a JSON file into an Excel spreadsheet. Open a file up to 50 MB: in an array of objects, each object becomes a row and its keys become the columns, and in an array of arrays, each inner array becomes a row. Check the preview, then download the XLSX. It all happens in your browser, so your data stays on your computer.

API Response to SpreadsheetShare API responses with people who work in Excel, not code.
Database Export ConversionTurn JSON database exports into Excel files for analysis, audits or non-technical teams.
Records to ColumnsTurn a list of records into a spreadsheet with one column per field, without writing a script.
Quick Data ReviewCheck a JSON dataset's structure in the table preview before you download.
Sensitive Data HandlingConvert confidential records to Excel without uploading them anywhere.

Key features

Convert JSON to XLSX
Works with arrays of objects
Works with arrays of arrays
Column headers from your keys
Preview before you convert

Guides

01 How to turn JSON into a spreadsheet someone can read

Set

Document Tools 20

Neighbours

01 Invoice Builder 02 CSV to JSON Converter 03 CSV to XLSX Converter 04 Email Viewer & Editor 05 EML to MSG Converter 06 EML Viewer

Specification

Command: document.json_to_xlsx
Set: Document
Input: JSON
Output: VND.OPENXMLFORMATS-OFFICEDOCUMENT.SPREADSHEETML.SHEET
Max file: 50MB
Batch: single file

Runtime

Engine: SheetJS · Intl.Segmenter
Threads: single
Isolated: —
WebGPU: —
Memory: —

Transport 0 B

Your file is opened, worked on and saved inside this tab. This tool has no upload step, so your file has nowhere else to go.

Keys

Search: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/

How it works

Open Your JSON File

Pick a JSON file that holds an array of objects or an array of arrays.

Preview the Table

See how your data will look as a spreadsheet, with columns taken from your JSON.

Download Excel File

Get an XLSX file with column headers, ready for Excel or any other spreadsheet app.

Frequently asked

What JSON formats are supported?

An array of objects, where each object becomes a row and its keys become columns. An array of arrays works too: each inner array becomes a row, and the first one is the header row.

How are nested JSON objects handled?

Each nested field gets its own column, with a dotted name: {"address": {"city": "Lisbon"}} becomes a column called address.city. A list, such as ["vip", "newsletter"], is kept as its JSON text in one cell.

Can I convert large JSON files?

Yes, files up to 50 MB. Bigger files take a little longer because the work happens on your own computer.

What happens to different data types?

Numbers stay numbers, text stays text, true and false become TRUE and FALSE, and null becomes an empty cell. JSON has no date type, so dates come through as text.

Are column headers automatically created?

Yes. With an array of objects, the keys become the column headers. With an array of arrays, the first inner array is the header row.

Can I preview the Excel structure before downloading?

Yes. You see a preview of the table, with its headers and first rows, before you download.

Keys

Search: ⌘K
Panels: ⌘1 · ⌘2
Full width: F
All keys: ⌘/