JSON to CSV Converter

Convert a JSON array of objects into a CSV spreadsheet.

verified_user100% Client-SidePrivacy Guaranteed: 100% Client-Side

Delimiter:

2 rows · 5 columns

JSON Input

[
  {
    "id": 1,
    "name": "Alice Johnson",
    "email": "alice@example.com",
    "address": {
      "city": "Austin",
      "zip": "78701"
    }
  },
  {
    "id": 2,
    "name": "Bob Smith",
    "email": "bob@example.com",
    "address": {
      "city": "Denver",
      "zip": "80202"
    }
  }
]

CSV Output

id,name,email,address.city,address.zip
1,Alice Johnson,alice@example.com,Austin,78701
2,Bob Smith,bob@example.com,Denver,80202

Frequently Asked Questions

How are nested objects handled?expand_more

Nested objects are automatically flattened into dot-notation columns — for example, {"address": {"city": "Austin"}} becomes a column named address.city. Arrays are converted to a JSON string within a single cell.

What if different objects have different fields?expand_more

The converter collects every unique field across all objects to build the column list. Rows missing a particular field simply get an empty cell for that column.

Why choose semicolon or tab instead of comma?expand_more

Semicolon-delimited CSVs are the default in several European locales where Excel uses a comma as the decimal separator. Tab-delimited (TSV) is useful when your data itself contains commas that shouldn't need escaping.

Is it safe to convert data I don't fully trust?expand_more

Yes — values that could be misread as spreadsheet formulas (starting with =, +, - or @) are automatically neutralized in the exported file, a protection against so-called "CSV injection" that many simpler converters skip.

Related Tools

table_chart

CSV to JSON

Convert a CSV spreadsheet into JSON data.

data_object

JSON Formatter

Prettify, validate and minify JSON data.

difference

Diff Checker

Compare two texts and highlight the differences.