Enter JSON in the editor and click 'Convert' to get CSV output.
A valid JSON input is an array of objects. Each object represents a row and the keys become column headers. For example:
[
{
"product": "Excel",
"company": "Microsoft",
"price": 159.99
},
{
"product": "Google Sheets",
"company": "Google",
"price": 0
}
]The output will be a CSV file with headers derived from the JSON keys. Each object becomes a row. The output of the above JSON will be:
product,company,price Excel,Microsoft,159.99 Google Sheets,Google,0
Note: By default, the CSV output will be displayed as a table so that it's easier to read. You can switch to comma separated values by clicking on the 'Raw' button on the output panel.
If your JSON has empty/null, these values will be converted to empty values in the CSV output. For example:
[
{
"product": "LibreOffice Calc",
"company": null,
"price": ""
}
]is converted to
product,company,price LibreOffice Calc,,
The converter will collect all unique keys from all objects to create the CSV headers. Missing values in any object will be represented as empty cells. For example:
[
{ "product": "Notion", "price": 10 },
{ "product": "Airtable", "platform": "Web" }
]is converted to
product,price,platform Notion,10, Airtable,,Web