JSON-Utils

JSON to CSV

Turn a JSON array of objects into a spreadsheet ready CSV. Nested objects flatten into dot path columns, missing keys become empty cells (and are flagged), and nested arrays are stored as JSON text in a single cell.

JSON array
CSV
Result will appear here
Ready. Press Convert or Ctrl+Enter.

How to use the JSON to CSV

  1. Paste a JSON array of objects.
  2. Press Convert.
  3. Download the CSV for your spreadsheet.

Example

The active column is empty for the first row, and the tool says so.

[{"name":"Ada","role":"admin"},{"name":"Grace","role":"editor","active":true}]

Frequently asked questions

What input shape is needed?

An array of objects, one per row. A single object is treated as one row. Arrays of scalars have no keys, so they cannot become CSV columns.

How are nested objects handled?

They flatten with dot paths, so address.city becomes a column. Nested arrays become JSON text inside one cell.