JSON to Excel
Convert JSON data to an Excel workbook. Supports arrays of objects, arrays of arrays, or multi-sheet format.
About JSON to Excel
JSON to Excel turns a JSON file into a real .xlsx workbook you can open in Excel, Google Sheets, or Numbers. It accepts the three shapes you actually get from an API or a database export — an array of objects, an array of arrays, or a multi-sheet map — and lays them out as rows and columns. Conversion happens in your browser, so the data never leaves your machine.
- Category
- convert
- Input
- Accepts: application/json or text/plain.
- Output
- Outputs: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.
- Cost
- Free, runs in your browser
- Memory
- low
Common uses
- Hand a non-technical colleague the response from a REST API as a spreadsheet instead of a wall of JSON
- Turn an array of order objects into a workbook where each key becomes a labelled column header
- Build a multi-tab workbook in one pass by feeding a JSON object whose top-level keys are sheet names
- Convert a NoSQL export (array of documents) into Excel for ad-hoc filtering and pivot tables
- Drop a JSON config or inventory list into a sheet so a client can edit values without touching code
- Stage data for a colleague who only works in Excel, keeping nested arrays-of-arrays as plain grids
Frequently asked questions
What JSON shapes are supported?
Arrays of objects (keys become columns), arrays of arrays (positional rows), and a multi-sheet object where each top-level key maps to one sheet's data.
What format is the output?
A standard .xlsx workbook (the OpenXML spreadsheet format), which opens in Excel, Google Sheets, LibreOffice, and Apple Numbers.
Does my JSON get uploaded anywhere?
No. The conversion runs entirely in your browser — the file is parsed and the workbook is built locally, with no server round-trip.
How are deeply nested objects handled?
Cells hold scalar values cleanly; deeply nested objects are best flattened first. Run JSON Flatten to get dot-notation columns before converting.
Is there a size limit?
There is no hard cap, but very large arrays are held in memory in the browser tab, so multi-hundred-megabyte inputs can be slow on low-RAM devices.
Keywords
- json
- excel
- xlsx
- convert
- spreadsheet
- table
- data