How to use JSON to Excel
- 1
Paste or drop the JSON
Paste an API response or drop a .json file; arrays of objects, column objects and JSON Lines are recognized.
- 2
Review the columns
Nested objects are flattened into dot-named columns; the preview shows every row and column that will be written.
- 3
Download the workbook
Download an .xlsx (or .ods) with typed cells and sized columns, ready to filter and chart.
Limits and Pro
JSON files up to 500 MB; Excel's own limit of 1,048,576 rows and 16,384 columns per sheet applies.
Files up to 4 GB. See Pro
About JSON to Excel
JSON to Excel builds a spreadsheet from JSON so that people who live in Excel, Google Sheets or Numbers can work with data that came from an API, a database export or a log file. Each object in an array becomes a row and the union of all keys becomes the columns, so records with missing fields still line up correctly.
Real-world JSON is rarely flat. Nested objects are flattened into columns like address.city and address.country, arrays of values become items.0, items.1, and anything you choose not to flatten is kept as JSON text in a single cell. A wrapper such as {"data": [...]} or {"results": [...]} is unwrapped automatically, and other common layouts — an object keyed by ID, a column-oriented object of arrays, an array of arrays — are recognized too.
The workbook is written with proper types: numbers are numeric cells you can sum, ISO date strings become Excel dates, true and false become booleans, and each column is sized to its content. You can also choose OpenDocument (.ods) for LibreOffice, or CSV and TSV if a plain text file is all you need.
Everything runs in your browser, which matters when the JSON contains customer records or tokens. Very large arrays are processed in a background worker and previewed with a virtualized table.
Privacy
The JSON is parsed and the spreadsheet is generated inside this browser tab; no data is uploaded, which keeps API payloads, customer records and keys on your machine.