JSON to CSV Converter
Data & CSV · Done in 3 steps
- 1Paste your JSON
- 2
- 3
About
Convert JSON to CSV with nested objects flattened to dot paths and arrays joined, split into columns or exploded into rows.
How to use it
- 1Paste JSON or drop a .json file.
- 2Choose how nested arrays are handled: join, one column per item, one row per item, or raw JSON.
- 3Pick a delimiter and quoting style.
- 4Download the CSV or JSON preview of the flattened rows.
- You give
- JSON array of objects, a single object, or an API response containing an array
- You get
- CSV (or flattened JSON) with a union of all keys as columns
- Good to know
- Exploding works on one array field at a time; other arrays are joined. Column order follows the first time each key appears.
- Privacy
- Processed on your device. Nothing is uploaded, stored or logged.
- Last tested
- 2026-10-28
FAQ
What if records have different keys?
Every key that appears in any record becomes a column; records missing a key get an empty cell.
What does “explode” mean?
An order with three line items becomes three rows, each repeating the order’s other fields — the shape you need for pivot tables.
Go further with AI
Spreadsheet analysis prompt
Get a reliable first analysis of a CSV or sheet: data profile, stated assumptions, answers with working, and the formulas to reproduce them.
ChatGPT · Claude · Gemini
Structured JSON output
Get valid, schema-shaped JSON from free text every time, with nulls instead of guesses, ready to feed into code or a spreadsheet.
ChatGPT · Claude · Gemini
Research brief builder
Turn a vague topic into a scoped research plan with ranked questions, a source plan and a stop rule before anyone starts searching.
ChatGPT · Claude · Gemini
Meeting notes to action plan
Convert messy notes or a transcript into decisions, an owned action list, open questions and a ready-to-send follow-up email.
ChatGPT · Claude · Gemini