JSON to CSV Converter

Free JSON to CSV converter. Convert a JSON array of objects into CSV with proper escaping of commas, quotes, and newlines, aligning columns across sparse objects.

AI-ready Use this tool with AI

This tool has a free JSON API. Copy a prompt or skill below to use it with ChatGPT, Claude, or any AI agent โ€” no API key needed.

API docs
โ€”
Paste your JSON above.

How json to csv converter works

JSON and CSV are two common formats for tabular data. JSON is hierarchical and nested; CSV is flat, with one row per record and one column per field. Converting JSON to CSV means flattening each object into a row and collecting every key that appears across all objects into the column header.

This converter accepts a JSON array of objects (or a single object) and produces CSV with the first object's keys as the header row in their original order, followed by one row per object. Fields containing commas, double quotes, or newlines are wrapped in quotes and internal quotes are doubled, following RFC 4180. Missing keys become empty cells, so sparse objects align correctly.

Paste your JSON and click Convert. The tool reports the number of rows and columns. Nested objects are flattened with dot notation by default (so {"address": {"city": "NYC"}} becomes a column named address.city). Use it to export an API response or a JSON dataset into a spreadsheet.

Frequently asked questions

What JSON shapes are supported?
An array of objects (most common) or a single object, which is treated as a one-row array. Nested objects are flattened with dot notation, and arrays inside values are joined with semicolons.
How are special characters handled?
Per RFC 4180: any field containing a comma, double quote, or newline is wrapped in double quotes, and any double quote inside is doubled. This keeps the CSV valid when opened in Excel or Google Sheets.
What if objects have different keys?
The converter collects every key across all objects into the header, in the order they first appear. Objects missing a key get an empty cell for that column, so all rows align.
Can I convert CSV back to JSON?
Yes โ€” use the companion CSV to JSON Converter. The two tools are designed as a matched pair for round-tripping tabular data.