JSON to CSV — free online tool

What does this do?

CSV is the universal data-exchange format for spreadsheets and databases. This converter takes an array of objects, unions the keys across every row to build the header line, flattens nested objects with dot-paths (e.g. `address.city`), and quotes cells per RFC 4180 when they contain commas, quotes, or line breaks.

When to use it

• ▸Export an API response for Excel / Google Sheets
• ▸Prepare data for BigQuery, Snowflake, or Postgres `COPY`
• ▸Make a quick CSV from log lines or analytics events
• ▸Extract a column from a JSON array for further processing

Tip

Give it an array of objects. An API envelope holding one array — `{ "data": [...] }`, `{ "rows": [...] }`, `{ "items": [...] }` — is unwrapped automatically, and a single object becomes one row. Nested objects are flattened with dot-paths. Use a JSONPath query such as `$.data[*]` to pick the rows yourself, or the JSON ⇄ CSV tool for other delimiters and CSV → JSON.

Example: Users → spreadsheet

{
  "rows": [
    { "id": 1, "name": "Alice", "email": "[email protected]", "address": { "city": "Cairo" } },
    { "id": 2, "name": "Bob",   "email": "[email protected]",   "address": { "city": "Berlin" } },
    { "id": 3, "name": "Carol", "email": "[email protected]", "address": { "city": "Tokyo" } }
  ]
}

id,name,email,address.city
1,Alice,[email protected],Cairo
2,Bob,[email protected],Berlin
3,Carol,[email protected],Tokyo