JSON to CSV converter

Turn a JSON array of objects into CSV, combining keys across records to form the table’s columns.

Ready to useIn your browser · no account

Use an array of objects. All keys become columns; nested objects and arrays become JSON text. Null and missing values become empty cells.

How to use

  1. Paste JSON whose top-level structure is an array containing at least one object.
  2. Choose comma, semicolon, or tab as the CSV delimiter.
  3. Convert and review the columns and values before copying the result into the destination app.

How it works

Input must be an array containing at least one object, with up to 100,000 characters and 10,000 records. Nested objects and arrays become JSON text within cells; output is limited to 500,000 characters.

An example

The records [{"name":"Ana","age":20},{"name":"Bia","city":"Recife"}] produce name, age, and city columns, even when a field appears in only one record.

Common questions

What happens when a record is missing a key?

The column remains because keys from all records are combined. Missing fields and null values become empty cells.

Do nested objects become multiple columns?

No. An object or array within a field is serialized as JSON text in a single cell, with the quoting needed for valid CSV.