JSON Guide
Converting JSON to CSV correctly
Understand how object records map to rows, columns, and spreadsheet values.
Begin with records
The cleanest input is an array in which every object represents one record and uses the same set of keys. Those keys become the CSV header row.
If records have different keys, some rows will contain empty cells. Decide whether that is meaningful before distributing the file.
Nested data needs a policy
CSV cells cannot naturally contain object structure. Flatten nested keys, select specific fields, or create separate tables before conversion.
Spreadsheet software may also reinterpret identifiers, dates, and long integers. Review imported column types when exact values matter.