How to use
- Paste JSON or open a .json file.
- Check the preview. Every key found in any object becomes a column.
- Download the .xlsx file.
Options explained
- Supported shapes
- An array of objects ([{"a": 1}]), an array of arrays ([[1, 2]]), or an object that wraps an array such as {"data": [...]}. The first array property is used.
- Nested values
- Objects and arrays inside a record are written as JSON text in a single cell. Use the JSON formatter first if you want to flatten them.
- Types
- Numbers and booleans become Excel numbers and TRUE/FALSE; null leaves the cell empty.
Example: records with different keys
Say the array has two records that do not have the same fields:
[
{"name": "Ada", "age": 36, "tags": ["a", "b"]},
{"name": "Bob", "city": "Rome", "active": true}
]The columns are every key in order of first appearance, and a record that lacks a key leaves that cell empty:
| name | age | tags | city | active |
|---|---|---|---|---|
| Ada | 36 | [“a”,“b”] | ||
| Bob | Rome | TRUE |
The tags array is written as JSON text in one cell, and true becomes the Excel value TRUE. If the top level is an array of arrays, the first row is used as it is and no header is created.
Frequently asked questions
What is the column order?
Columns follow the order in which keys first appear in the array.
Can I create several sheets?
One sheet per conversion. Convert each array separately and combine them in Excel if you need more.
How do I keep long IDs exact?
Write them as strings in the JSON ("110101199003074514"). Unquoted numbers with more than 15 to 16 digits lose precision when any JavaScript program reads them, and strings are always written to Excel as text.
Privacy
This tool runs entirely in your browser. Your files and text are processed on your device and are never uploaded to our servers.