JSON → Excel

JSON Input
Loading editor…
Workbook Preview

Paste JSON on the left to preview
the Excel workbook

JSON to Excel Converter

Paste your JSON into the editor and export it as a real, styled .xlsx workbook. Arrays of objects become tables with bold headers and auto-filters; nested objects and lists each get their own sheet — so the file opens ready to work with in Excel or Google Sheets.

Real .xlsx
A genuine Excel workbook, not a renamed CSV.
Multi-sheet
Each array or object becomes its own sheet.
Styled headers
Bold, colored header rows with auto-filter.
Private
Runs entirely in your browser.

What JSON Structure Works Best

The converter reads the shape of your JSON and builds the workbook accordingly:

A top-level array of objects becomes a single sheet named "data" — each object is a row, keys become column headers.

A top-level object is split across multiple sheets:

  • Scalar fields (strings, numbers, booleans) are collected into one Overview sheet — one column per field, one row of values
  • Each array of objects becomes its own table sheet with headers and an auto-filter
  • Each array of primitives becomes a list sheet with an index column
  • Each nested object becomes its own sheet, flattened with dotted paths (e.g. address.city) as column headers and a single row of values

This means a single JSON document with several nested collections turns into a proper multi-tab workbook instead of one flat, hard-to-read sheet.

How the Workbook Is Generated

Everything runs client-side using ExcelJS — no server, no upload.

Steps:

  1. Paste your JSON into the editor
  2. The tool analyzes its structure and shows a live preview of the sheets it will create
  3. Click Export Excel — the workbook is built in memory with styled header rows, column widths sized to fit content, and auto-filters on table sheets
  4. The file downloads immediately as output.xlsx

Because the file is a real .xlsx (OOXML) document, formatting like bold headers and column widths survives when it's opened in Excel, Google Sheets, or LibreOffice Calc — unlike a CSV, which is plain text with no styling at all.

JSON to Excel vs. JSON to CSV

Use JSON to Excel when you want a polished, ready-to-share file: multiple related tables in one workbook, bold headers, and column widths that don't need manual adjustment.

Use JSON to CSV when you need the simplest possible flat format — for example, importing a single table into a database or a script that only understands plain CSV rows.

Both tools run entirely in the browser, so your data never leaves your machine either way.

Frequently Asked Questions

How does the JSON to Excel converter work?

Paste your JSON into the editor. The tool analyzes its structure and previews the sheets it will create, then click Export Excel to download a formatted .xlsx workbook.

Does it create multiple sheets?

Yes. A top-level JSON object is split into multiple sheets: an Overview sheet for simple fields, plus one sheet per nested array or object. A top-level array of objects becomes a single table sheet.

Is the output a real Excel file or a renamed CSV?

It's a genuine .xlsx (OOXML) workbook generated with ExcelJS, including bold styled header rows, auto-sized columns, and auto-filters on table sheets — formatting that a CSV file cannot carry.

Is my JSON sent to a server?

No. The workbook is generated entirely in your browser using the ExcelJS library. Your data never leaves your machine.

Why is the Export Excel button disabled?

The button is only active once the input contains valid, non-empty JSON. If it stays disabled, check the error bar above the editor for a syntax issue.

Can I convert Excel back to JSON?

Not yet — this tool is one-way (JSON to Excel). For the reverse direction with CSV files, use the CSV to JSON tool on JSONbite.

More Tools