JSON to Excel Converter (XLSX)
Turn a JSON list of records, such as an API response or an export, into an Excel .xlsx sheet with one column per field, in your browser.
Results
What this tool does
Most JSON exports are a list of objects, and that maps neatly onto a sheet: each object becomes a row and each key a column, in the order the keys first appear, with gaps left empty where a record lacks a field. Numbers stay numbers and true/false become Excel's logical values, so sums and filters work straight away; a list of lists becomes the rows exactly as they are. Values that are themselves objects or lists are written into the cell as compact JSON rather than dropped. Numbers longer than 15 digits, such as IDs, are kept as text, because Excel would silently round them.
Formula
list of objects → one column per key and one row per object ; numbers, true/false and text keep their type
Variables
| Symbol | Meaning | Unit |
|---|---|---|
text | JSON | — |
OUT | Rows × columns | — |
NU | Cells stored as numbers | — |
EM | Empty cells | — |
Worked example
- JSON[ {"name": "Ana", "age": 31, "active": true, "city": "Porto"}, {"name": "Bruno", "age": 45, "active": false}, {"name": "Carla", "age": 28, "active": true, "city": "Lisboa", "tags": ["admin", "beta"]} ]
- Rows × columns4 x 5
- Cells stored as numbers3
- Empty cells3
Limitations
- The calculation runs entirely in your browser. The values you type are never sent to a server.