JSON to CSV Converter

This converter turns a JSON array of objects into CSV. Each object becomes a row and each key becomes a column, so [{"name":"Ada","age":36}] gives a header line name,age followed by the row Ada,36. CSV (comma-separated values) is the plain-text table format that Excel, Google Sheets and most databases can import. It has no way to show nesting, so the converter makes a few choices for you. The header is built from every key found in any object, in the order they first appear. If a record lacks a key, that cell is left empty. Nested objects and arrays are written into a single cell as JSON text, such as ["a","b"].

Quoting follows RFC 4180, the common CSV standard. A value is wrapped in double quotes when it contains a comma, a double quote, a line break, or a space at the start or end. Quotes inside a value are doubled, so say "hi" becomes "say ""hi""". Null values become empty cells. The table below shows each case.

The input must be an array, and every item must be an object. A single object or a list of plain values shows an error. The tool also runs backwards: type CSV into the CSV panel and the JSON panel fills with an array of objects. That reverse direction splits on commas only. For semicolon or tab files, use the CSV to JSON Converter, which detects the delimiter. To get a real spreadsheet file, pass the result to CSV to Excel.