{ } JSON Workbench0 network requests. Check DevTools

"JSON to Excel":{ }

Paste a JSON array of objects, preview it as a table, and download a real Excel (.xlsx) workbook: nested objects become dotted columns and numbers, booleans, and text keep their cell types. Runs 100% in your browser: zero network requests, so your data never leaves the page.

What is a JSON to Excel converter?

A JSON to Excel converter turns a JSON array of objects into a spreadsheet you can open in Excel, Google Sheets, or LibreOffice. Each object becomes a row and each key becomes a column, with nested objects flattened into dotted columns. It's the fastest way to hand an API response or export to a non-technical colleague, or to pivot, filter, and chart data that started life as JSON. This tool writes a real .xlsx workbook in your browser, so your data never leaves your machine.

Excel, or CSV?

  • Excel (.xlsx): keeps number/boolean/text cell types and opens cleanly with no import step. This page.
  • CSV: a plain-text table for scripts and bulk import: JSON to CSV.
  • Back to JSON: CSV to JSON.

How to use

  1. Paste a JSON array of objects into the JSON pane (or load the sample).
  2. A live table preview shows the columns and rows exactly as they'll appear in Excel.
  3. Nested objects become dotted columns (address.city); scalar arrays are joined; keys missing from some rows are left blank.
  4. Click Download .xlsx to save a real Excel workbook. Numbers, booleans, and text keep their cell types.
  5. Everything runs in your browser; verify zero network calls in DevTools.

Examples

Array of objects → columns

Input
[
  { "id": 1, "name": "Ada" },
  { "id": 2, "name": "Linus" }
]
Output
id | name
1  | Ada
2  | Linus

Nested object → dotted columns

Input
[{ "id": 1, "address": { "city": "Paris" } }]
Output
id | address.city
1  | Paris

FAQ

Does this create a real .xlsx file?

Yes. It builds a genuine Excel workbook (the same OOXML .xlsx format Excel, Google Sheets, and LibreOffice open natively), not a CSV renamed with an .xlsx extension. Numbers, booleans, and text are written with their correct Excel cell types.

How are nested objects and arrays handled?

Nested objects are flattened into dotted columns like address.city. Arrays of simple values are joined with commas; arrays of objects are written as compact JSON in the cell, so nothing is lost.

What shape should my JSON be?

An array of objects is ideal, one object per row. A single object becomes a one-row sheet, and an array of plain values becomes a single value column. Different objects can have different keys; the columns are the union of all keys.

Is my data uploaded?

No. The workbook is generated entirely in your browser and downloaded locally. Check DevTools: zero network requests, so spreadsheets with sensitive data never leave your machine.

Is there a row limit?

There's no hard cap; it's bounded by your browser's memory. The on-page preview shows the first 15 rows, but the downloaded file always contains every row.

Related tools