Convert JSON to CSV or Excel
Choose which JSON records and repeated items become rows, then save a table with text identifiers and a source-field map.
How to convert your JSON export
- Upload one UTF-8 JSON file. Choose its record collection and fields.
- Keep one row per record, or expand one array into item rows. Review the row count before saving.
- Save one ZIP containing your CSV or text-only Excel table, a field map, a summary and warnings.
Example: two orders, three rows
Choose /orders, expand /items, and keep /tags together as JSON text.
| /order_id | /buyer/name | /items/sku | /items/qty | /tags |
|---|---|---|---|---|
| 000781 | Mina | A | 2 | ["priority","gift"] |
| 000781 | Mina | B | 1 | ["priority","gift"] |
| 9007199254740993 | [] |
Order 000781 keeps its zeros. Order 9007199254740993 keeps every digit and stays as a row despite having no items. Extra columns _st_record, _st_item and _st_array_state show where rows came from.
Limits and privacy
Up to 5 MiB, 10,000 records, 50,000 rows, 200 selected fields, 1 million cells and 32 nesting levels. Schema discovery is limited to 5,000 fields, and expanded data to 32 MiB. Nothing is silently truncated.
Processing happens on SuperTool’s servers. See our privacy policy for file-handling details.
Questions
What becomes a row?
Each record in the collection you choose. Expanding one array makes each item a row, with the record’s other fields repeated.
What happens to empty items?
The record still gets one row, with blank item cells. _st_array_state explains why.
Why are quantities text?
Every Excel data cell is saved as text to keep its exact spelling. Quantities are text too; convert them in your spreadsheet for math.
Why a ZIP?
It holds the table, field-map.csv (each column’s source), summary.json (counts and settings) and warnings.csv.
Can CSV preserve Excel types?
CSV has no cell types, so spreadsheets may reinterpret values. Formula-like values, including negative numbers, get a leading apostrophe; warnings.csv lists each change. CSV does not protect leading zeros when a spreadsheet opens it. Choose Excel for exact identifiers: its Data, Field Map and Summary sheets use text cells and no formulas.
Are XML, NDJSON or API URLs supported?
No. Upload one UTF-8 JSON file.