What is JSON to CSV Converter?

JSON to CSV Converter turns JSON data into CSV. Enter an object or an array of objects to get CSV that opens in spreadsheet software. It is useful for reviewing API responses and configuration data in table form.

How to Use

1. Paste JSON data into the input.
2. Turn headers on or off as needed.
3. Review the CSV result.
4. Download the CSV if needed.

Main Settings

Include Headers

When this is on, the JSON keys become the first row of the CSV. Keep it on while reviewing the columns, and turn it off when the next process does not need a header row.

Input and Output Example

[
  {
    "name": "Taro Yamada",
    "age": 30,
    "address": { "city": "Tokyo" }
  }
]

This JSON becomes the following CSV.

name,age,address
Taro Yamada,30,"{""city"":""Tokyo""}"

Use Cases

• Reviewing an API response in table form
• Moving JSON data into Excel or a spreadsheet
• Checking the column structure before migrating data

Things to Keep in Mind

• The input must be an object or an array of objects. JSON made only of numbers or strings cannot be converted
• Nested objects and arrays are placed in a cell as JSON text
• Columns are the union of keys across all rows, and missing keys become empty cells
• null becomes an empty cell