Tools / Data

JSON to CSV

Turn a JSON array of objects into a CSV table. Headers are the union of keys in first-seen order. A single object is not a table.

Example: Records

[{"name":"Ada","role":"admin"},{"name":"Grace","role":"user","city":"New York"}]

A common error

Valid JSON that is not an array of objects, such as {"a":1}, is rejected. Nested values are written as JSON text inside a quoted field, not as extra columns.

The editor runs in the browser after this page loads. Nothing you paste is uploaded unless you save a Pro project.