JSON to Excel Converter
Paste JSON or upload a .json file and download a ready-to-open Excel spreadsheet. Nested objects are flattened into columns, all in your browser.
About the JSON to Excel Converter
Our free JSON to Excel converter turns an array of JSON objects into a clean .xlsx spreadsheet you can open in Excel, Google Sheets or LibreOffice. Each object becomes a row and each key becomes a column header. Nested objects are flattened into dotted columns such as address.city, so API responses and exports are ready to sort, filter and analyse.
The conversion runs entirely in your browser, so your JSON is never uploaded to a server. That makes it safe for customer records, API output and internal data. There is no account and no row-count paywall. If you only need a text file, use our JSON to CSV converter, or go the other way with our XLSX to CSV converter.
How to Convert JSON to Excel
Step 1
Add your JSON
Paste JSON into the box or upload a .json file. It should be an array of objects, or an object that contains one.
Step 2
Check the preview
See how your data maps to columns. Nested fields are flattened, and you can name the worksheet.
Step 3
Download your Excel file
Click Convert and download the .xlsx file, ready to open in Excel or Google Sheets.
Frequently Asked Questions
What JSON structure works best?
An array of objects with similar keys works best. Each object becomes a row and each key becomes a column header. A single object converts to a one-row sheet.
How are nested objects and arrays handled?
Nested objects are flattened into columns with dotted names, such as address.city. Arrays of simple values are joined into one cell, and arrays that contain objects or other arrays are written as JSON text so nothing is lost.
Is my JSON uploaded to a server?
No. The conversion happens entirely in your browser, so your JSON never leaves your device.
Will it work with a large JSON file?
Yes, within your device's memory. A single sheet is limited to about 2 million cells (rows multiplied by columns) so your browser does not run out of memory, and very large files can be slow, so split them into parts if the page struggles.
What if my objects have different keys?
The columns are built from the union of all keys, in the order they first appear. Fields that an object does not have are left blank.
Can I open the result in Google Sheets or Numbers?
Yes. The file is a standard .xlsx workbook, so it opens in Excel, Google Sheets, Numbers and LibreOffice.
Are very long numbers, such as 64-bit IDs, kept exactly?
Not always. Excel keeps only 15 significant digits, and a browser's JSON parser rounds integers above 9,007,199,254,740,991, so the last digits of very long numbers can change. The tool warns you when it sees one. To keep every digit, put long IDs in quotes as strings in your JSON and they are written to Excel as text.