Skip to content
Burrows Tools

JSON to CSV Converter

Paste an API response and get a CSV you can open in Excel, Numbers, or Google Sheets. An array of objects becomes one row per object, with the union of every key as the header row, so rows that are missing a field leave an empty cell instead of shifting the columns. Nested objects flatten to dotted column names such as user.name, and arrays get bracketed indexes such as tags[0], which is the notation the CSV to JSON converter reads back — so a file can make the round trip without losing its shape. Quoting follows RFC 4180: any value holding a comma, a quotation mark, or a line break is wrapped and its inner quotes doubled, which is the part hand-written converters usually get wrong. Everything runs in this tab. Your JSON is never uploaded, never logged, and never leaves the device you are reading this on.

Converted in your browser — the text never leaves this tab and nothing is uploaded.

Paste your data and choose Convert to CSV.

Need the other direction? Convert CSV to JSON

How to use the json to csv converter

  1. Paste your JSON — an array of objects, a single object, or an object wrapping one array.
  2. Pick a delimiter if you need semicolons, tabs, or pipes instead of commas.
  3. Press Convert to CSV and check the row and column count under the button.
  4. Copy the result, or download it as a .csv file ready to open in a spreadsheet.

Frequently asked questions

What happens to nested JSON?
Nested objects are flattened into dotted column names, so {"user":{"name":"Ada"}} becomes a column called user.name. Arrays get an index in brackets, such as tags[0] and tags[1]. Empty objects and arrays still get a column so the shape is visible.
Will commas and quotes inside my data break the CSV?
No. Any value containing the delimiter, a double quote, or a line break is wrapped in quotes, and inner quotes are doubled, exactly as RFC 4180 specifies. That is what lets a value like 'Smith, John' survive being opened in a spreadsheet.
My rows have different keys. What does the header look like?
The header is the union of every key across every row, in the order the keys are first seen. A row that does not have a given key gets an empty cell for it, so the columns stay aligned.
Is my data uploaded anywhere?
No. The conversion is JavaScript running in your browser. There is no server call, so this is safe to use on data you would not paste into a hosted converter.
Can I convert the CSV back to JSON?
Yes — the CSV to JSON converter reads the same dotted and bracketed column names and rebuilds the nested objects and arrays they came from.

Related tools