Developer Tools

JSON to CSV Converter

Turn an array of JSON objects into spreadsheet-ready CSV rows — headers derived from your keys, quoting handled per RFC 4180.

100% browser-side processing — nothing is uploaded

JSON → CSV: Convert an array of objects into CSV rows. Output updates live as you type — or press Ctrl/Cmd + Enter.

Results update live as you type.
14 lines · 0.29 KB
1 lines · 0.00 KB

Related tools

CSV to JSONTurn spreadsheets into JSONJSON Tools StudioAll tools in one workspaceJSON FormatterPretty-print and sort keysJSON to YAMLConfig-friendly output

How to convert JSON to CSV

  • Paste a JSON array

    Input should be an array of objects — the typical shape of an API list response or database export.

  • Convert

    Every distinct key across all objects becomes a column; each object becomes a row. Missing keys yield empty cells.

  • Download

    Copy the CSV or download it as a .csv file and open it directly in Excel or Google Sheets.

How the columns are decided

CSV is rectangular and JSON is not, so the converter takes the union of keys across every object in the array — if one record has an email field and another does not, the column still appears and the missing cell is left empty. Column order follows first appearance. Values containing commas, quotes, or line breaks are wrapped in double quotes with internal quotes doubled, per RFC 4180, so the file opens cleanly in Excel, Google Sheets, and standard CSV parsers.

What happens to nested objects

A nested object or array inside a record cannot become a flat cell honestly, so it is serialized as a JSON string in that cell — lossless, but not spreadsheet-friendly. When you want real columns like user.address.city, flatten first: run the Flatten action in the studio to convert nesting into dot-notation keys, then convert the flattened records to CSV. Each nested path becomes its own column.

JSON to CSV Converter FAQ

What input shape does the converter expect?

An array of objects is ideal — each object becomes a row. A single object becomes a one-row CSV. Arrays of plain values are wrapped in a "value" column.

How are nested objects handled?

They are embedded as JSON strings inside the cell, which preserves the data. For true one-column-per-field output, flatten the JSON first (dot notation), then convert.

Will commas inside values break the CSV?

No. Any value containing commas, double quotes, or newlines is quoted and escaped per RFC 4180, the standard Excel and Google Sheets expect.

What if objects have different keys?

The header row is the union of all keys found in any object. Records missing a key simply get an empty cell in that column.

Can I convert back?

Yes — the CSV → JSON action on this page reverses the trip, mapping the header row to keys and inferring number, boolean, and null types.