Turn a list of JSON objects into a table that Excel, Numbers or Google Sheets open directly. The columns come from the keys, and every key that appears in any of the objects is collected.
Nested objects are flattened with dot notation, so {"address": {"city": "Girona"}} becomes a column called address.city.
How to use it
- Paste the JSON or open a file.
- Choose the separator your spreadsheet expects.
- Copy the result or download it as .csv.
Frequently asked questions
- Which separator should I pick?
- The comma is the standard, but Excel in many European locales expects a semicolon. If everything lands in one column when you open the file, switch.
- Excel mangles my accents — why?
- Because it does not detect that the file is UTF-8. Tick the BOM box: it adds an invisible marker at the start that makes Excel get it right.
- What happens to values that are lists?
- They are stored inside the cell as JSON text. A table has no way to represent a list in a single cell, so showing it plainly is the honest option.
Related tools
CSV to JSONDetects the separator, respects quotes and types the values.
JSON to YAMLA straight conversion that keeps the key order.
YAML to JSONTakes files with several documents in them.
Format and validate JSONIndent, minify or sort keys, and get the error’s line and column.
Decode a JWTHeader, payload and expiry. The signature is not verified.