JSON to CSV
Turn JSON arrays into spreadsheet-ready CSV.
Use the JSON to CSV tool
What this json to csv does
JSON to CSV takes an array of objects and writes one row per object. Columns are the union of every key, in first-seen order, so records with different shapes still line up instead of dropping fields.
Values containing commas, quotes or line breaks are quoted and escaped according to RFC 4180, which is what spreadsheet programs expect. Nested objects and arrays are written as JSON text inside the cell rather than being flattened unpredictably.
Why use it
- Open API results in a spreadsheet for review.
- Hand data to someone who works in Excel rather than code.
- Produce a stable CSV fixture from a JSON sample.
How to use it
- 1Paste an array of JSON objects.
- 2Choose a delimiter if a comma is not appropriate.
- 3Copy the CSV or download it as a file.
Worked examples
Two records
Input
[{"name":"Ada","age":36},{"name":"Linus","age":56}]Output
name,age Ada,36 Linus,56
Nested value
Input
[{"id":1,"tags":["a","b"]}]Output
id,tags 1,"[""a"",""b""]"
Common mistakes
- Exporting deeply nested JSON and expecting separate columns; nested values stay as JSON text.
- Opening the CSV in a locale that uses semicolons and finding every row in one column.
- Losing leading zeros because the spreadsheet reinterprets numeric-looking text.
Frequently asked questions
Does it accept a single object?
Wrap it in an array first. CSV rows need a consistent record shape, and the tool expects an array of objects.
How are missing fields handled?
The cell is left empty. The column still exists because the header is the union of all keys.
Can I choose semicolons?
Yes. Pick the semicolon delimiter for locales where the comma is the decimal separator.