JSON ↔ CSV Converter

Convert between JSON arrays and CSV. Auto-converts as you type.

JSON Array
CSV

New tools every week

Get notified. No spam.

How to Convert JSON to CSV

When you need to move data from an API response or a JSON data dump into a spreadsheet, you need a JSON to CSV converter. This tool takes a JSON array of objects and flattens it into comma-separated rows, with the object keys as column headers. Everything runs client-side — your data stays in your browser.

This is particularly useful for exporting analytics data, user records, or any tabular data that's stored as JSON. Paste in an array like [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}] and get a clean CSV you can open in Excel, Google Sheets, or import into a database.

The converter handles nested objects by flattening them with dot notation (e.g., address.city) and arrays by joining values. If your JSON isn't a flat array of objects, you may need to reshape it first — the tool expects the top-level structure to be an array.

Tips

  • Your JSON must be an array of objects at the top level — a single object or a nested structure won't convert directly.
  • Fields containing commas, quotes, or newlines are automatically escaped in the CSV output.
  • For large datasets, consider using jq locally: jq -r '[.[] | {name, email}] | (first | keys_unsorted) as $keys | $keys, map([.[$keys[]]])[] | @csv'.
  • If columns are missing for some rows, the converter fills in empty values to keep the CSV rectangular.