How to use JSON to Excel
- Click “Select JSON file” or drop a .json file onto the box.
- Decide whether ISO date strings (2026-03-31) should become real Excel dates.
- Press “Convert to Excel”.
- Download the .xlsx file and open it in Excel, Numbers, LibreOffice or Google Sheets.
About this tool
An array of objects becomes a table: the union of all keys forms the bold, frozen header row, so records with missing fields simply leave cells empty. Nested objects are flattened into dotted column names such as address.city, arrays of simple values are joined with commas and more complex arrays are written as JSON text. An array of arrays is written row by row.
An object whose values are all arrays – for example {"Customers": […], "Orders": […]} – becomes a workbook with one sheet per key, and an object that wraps a single array (such as {"data": […]}) is unwrapped automatically. Numbers and booleans keep their types so you can calculate with them straight away.
Frequently asked questions
What JSON structures are supported?
Arrays of objects, arrays of arrays, a single object, an object wrapping one array, and an object of arrays (one sheet per key).
What happens to nested data?
Nested objects become extra columns with dotted names (customer.name). Lists of values are joined with commas.
Are my files uploaded to a server?
No. The whole process runs inside your browser with JavaScript. Your files never leave your device, which also means the tool keeps working if you go offline after the page has loaded.
Is this tool really free?
Yes. There is no sign-up, no daily limit, no watermark and no paid tier. The site is supported by advertising shown on the page, not by charging for the tools.