JSON tool

JSON to CSV — free online tool

Turn a JSON array of objects into a clean CSV file — perfect for Excel, Google Sheets, BigQuery, or any database import.

▶ Open in editor

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

Input must be an array of objects — common envelopes like `{ "data": [...] }`, `{ "rows": [...] }`, `{ "items": [...] }`, `{ "results": [...] }`, and `{ "records": [...] }` are auto-unwrapped. Nested objects are flattened with dot-paths.

Example: Users → spreadsheet

Input — JSON

{
  "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" } }
  ]
}

Output

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

▶ Try this example in the editor

More JSON tools

JSON to YAML

Convert any JSON document to YAML 1.2 in your browser — proper quoting, nested objects and arrays, multi-line strings.

JSON to XML

Convert any JSON document to well-formed XML in your browser — proper entity escaping, nested elements, attributes via the `@` prefix.

JSON Validator

Paste any JSON to instantly check if it's valid — get the exact error message, and one-click auto-repair for the common mistakes.

JSON Minifier

Shrink any JSON to the smallest valid form — strip every byte of whitespace, indentation, and line breaks while keeping the value identical.

Full JSON editor →

Pretty · Minify · Tree · YAML · XML · CSV · Schema · JSONPath · auto-repair