About JSON to Excel
JSON to Excel gets data out of developer land and into a sheet people can filter, sort and chart: an API response, an export from MongoDB or Firebase, a log file, a list of orders from a web shop. Upload the .json file and each object in the array becomes a row, with a column for every key that appears anywhere in the data.
Nested objects are flattened into dotted column names such as address.city, lists of plain values are joined into one cell, and lists of objects get numbered columns like items[0].sku. If the records sit under a key like data, items or results, that list is used, and an object made of several arrays gets one sheet per array. A .json file with one object per line, known as JSON Lines, works too.
How to use JSON to Excel
- 1Upload the JSON file
Choose or drop a .json file saved from an API, a database export or a script.
- 2Click JSON to Excel
Records are found, nested fields are flattened and the workbook is built on our server.
- 3Download the .xlsx
Open it to find a bold, frozen header row and columns already sized to their contents.
Why use Cubfile for this
- Nested data, flat columns
address.city, address.zip and items[0].price each get their own column, so nothing hides inside a cell.
- Every key becomes a header
Records with different fields still line up; missing values are simply left blank.
- Finds the records for you
Arrays under data, items, results, records or rows are picked up without you editing the file.
- One sheet per list
A JSON object holding several arrays, like users and orders, becomes a workbook with a sheet for each.