What JSON shape does it accept?

An array of objects — [{...}, {...}] — the shape every API returns. The column headers are the union of all keys across all objects, in the order first seen; an object missing a key simply leaves that cell empty. A top-level object on its own is treated as a one-row table.

How are nested objects and arrays handled?

Cells must be text, so a nested value is written as compact JSON inside the cell (for example {"a":1} or [1,2]). Flattening rules vary too much by use case to guess — keeping the JSON is lossless, and you can split it later if needed.

Will it open cleanly in Excel?

Yes. Fields containing commas, quotes or line breaks are quoted by the standard rules, so Excel, Google Sheets and LibreOffice all open the download with columns intact. Download it as a .csv file rather than copying, for the cleanest import.

No. Parsing and conversion happen on your device in this tab.

JSON to CSV Converter

Turn a JSON array into a spreadsheet-ready CSV — then download it and open it straight in Excel or Sheets.

Your JSON array

CSV —

How to use it

Paste a JSON array — an API response, an export, a fixture file's contents.

Convert. Headers are the union of every object's keys; invalid JSON gets a clear error with the position.

Download the .csv and open it in Excel, Google Sheets or LibreOffice — properly quoted, columns intact.

APIs answer in JSON; humans audit in spreadsheets

The moment data needs eyes on it — a manager checking orders, an accountant reconciling records, anyone sorting and filtering — it has to become rows and columns. Hand-converting an API response invites the classic spreadsheet disasters: a comma inside a product name splitting a row, a quote mark ending a field early. This converter applies the real CSV quoting rules to every cell, takes the union of keys so no field silently disappears when one record has an extra property, and runs entirely in your browser.

JSON to CSV Converter

How to use it

APIs answer in JSON; humans audit in spreadsheets

Related tools