Convert JSON to CSV Online

JSON to CSV is the usual route from an API response to a spreadsheet. Most exports arrive as a JSON array of objects: a page of Stripe charges, a GitHub issues dump, or a mongoexport run with --jsonArray. Each object becomes one CSV row and each key becomes a column header. The header is the union of keys across all records, in the order they first appear, so a key that only some records carry still gets its own column.

The main trap is the wrapper object. Many APIs return {"data": [...], "next": "..."} rather than a bare array, and AWS CloudTrail files wrap everything in {"Records": [...]}. A wrapped file converts to a single row with one column per top-level key, not one row per record. Save only the inner array, or open the file in the SQL Query tool, run SELECT UNNEST(data, recursive := true) against the table named after your file, and export that result as CSV.

CSV cells hold flat text, so nested values are written as compact JSON inside a quoted field. An array like ["red","blue"] stays ["red","blue"], and an address object stays {"city":"Leeds","zip":"LS1"}. That keeps the data, but a spreadsheet user sees raw JSON. Run Flatten JSON first to split one level of objects into columns such as address_city, or select the nested fields you need with SQL before converting.