JSON to CSV

Expected input and output

The input must be a JSON array containing objects. The converter collects the property names found across the records and uses them as CSV headings. Each object becomes one output row. Properties absent from a particular object produce an empty cell, while null values are also represented as empty text. Nested arrays and objects are written as JSON text inside a cell.

CSV does not carry a universal type system for strings, numbers, dates, nulls, or nested structures. A spreadsheet may guess types on import, possibly changing identifiers or dates. Treat the CSV as a text interchange format and coordinate its conventions with the system that will read it.

Why quoting matters

A cell containing a comma, quotation mark, or line break must be quoted under the converter’s common CSV convention; quote characters within a quoted cell are doubled. This keeps punctuation inside the value from being mistaken for a new column. Always test values that contain these characters.

Before sharing or importing

1. Confirm the JSON is an array of objects and includes the fields you expect.
2. Review the generated heading order and rows with missing properties.
3. Inspect nested values and cells containing punctuation.
4. Check leading zeroes, large identifiers, dates, and null handling in the target importer.
5. Keep the original JSON until the destination accepts and validates the table.

For the reverse conversion, see CSV to JSON. More context is available in the CSV data-quality article.