JSONConverter
โ† Back to the tools
๐Ÿ“Š

JSON to CSV: Turn an Array of Objects into a Table

CSV is a table: the first row is the header and every row after it is one record. JSON is a tree. Converting JSON to CSV therefore means flattening an array of objects into columns. The free converter here does exactly that โ€” paste your JSON, pick CSV, and the headers are the object keys and each object becomes a row.

The shape that converts cleanly

The ideal input is an array of flat objects with the same keys: [{"name":"Alice","age":30},{"name":"Bob","age":25}] becomes name,age then Alice,30 then Bob,25. Every key is a column; every object is a row.

Values are coerced sensibly

Numbers become numbers in the table (30 stays 30, not "30"), booleans become true/false, and null stays empty. Strings that look like identifiers such as "007" keep their leading zero so no data is silently lost.

Nested objects and arrays are the tricky part

CSV has no concept of nesting. A value that is itself an object or array is written out as its text representation. Use the round-trip verification to see exactly which fields did not survive โ€” it converts out and back and lists every change.

Quotes, commas and newlines are handled by RFC 4180

A field containing a comma or newline is wrapped in double quotes, and embedded quotes are doubled ("say ""hi"""). This is what makes real-world CSV โ€” addresses, notes, quoted numbers โ€” round-trip safely.

Missing keys become empty cells

If one row has a key another lacks, the table still aligns: the missing cell is left empty. Run the free JSON to CSV converter and inspect the output column by column.

Convert your data free