JSON to CSV
What this is
Spreadsheets want rows. JSON to CSV here expects an array of objects (or a JSONPath that points at one, like $.items). First-level keys become headers; nested objects and arrays are stringified into a cell so you do not silently lose structure. This is the converter jsonformatter.org advertises as a separate tool — it belongs next to the formatter because that is the payload you just validated.
Open the formatter — paste stays in this tab.
[
{ "sku": "A-1", "qty": 3, "price": 19.5 },
{ "sku": "B-9", "qty": 1, "price": 4 }
]FAQ
- Excel mojibake?
- CSV here is UTF-8. Excel on Windows may need a BOM. Google Sheets import as UTF-8 is the reliable path.
- One object, not an array?
- Wrap it in [ ] or point JSONPath at an array field.