About JSON to Excel
Paste an API response or upload a .json file and get a tidy spreadsheet. Nested objects become dotted columns (address.city), simple arrays are joined, and an object of arrays becomes one sheet per key.
How to use JSON to Excel
- Paste JSON into the box or drop a .json file.
- Click “Convert to Excel”.
- Review the preview and download the .xlsx file.
Limitations
- Everything runs in your browser’s memory, so the practical file size depends on your device. As a rough guide: up to ~50 MB or ~500,000 rows works well on a modern laptop; phones and tablets handle much less.
- Very large files can make the tab slow or crash. If that happens, split the file first or use a desktop computer.
- Outputs keep values and formulas’ results but not formatting, charts, images, pivot tables or macros.
Frequently asked questions
What JSON shapes are supported?
An array of objects, an array of arrays, a single object, or an object whose values are arrays (each becomes a sheet).
What happens to nested arrays?
Arrays of simple values are joined with commas; arrays of objects are kept as JSON text in the cell.
Is there a size limit?
Only your browser’s memory — see the limitations below.
Disclaimer: Excel Tools by gumber.ai is a hobby project and is completely free to use. It is provided “as is”, without warranty of any kind. Always double-check results before relying on them, and keep a copy of your original files.
Related tools
Excel to CSV
Convert XLSX/XLS sheets to CSV with your choice of delimiter. Export one sheet or all.
CSV to Excel
Turn CSV, TSV or delimited text into a proper .xlsx workbook. Auto-detects delimiters and numbers.
Excel to JSON
Convert spreadsheets to JSON arrays or objects. Supports nested keys like "address.city".
PDF to Excel
Extract tables and text from digital PDFs into rows and columns.