Skip to content
My Tiny Utils

Search tools

Type to find a tool, then press Enter to open it.

JSON to CSV

Convert a JSON array of objects to CSV. Nested objects flatten into dot-path columns, quoting follows RFC 4180, and you choose the delimiter.

Processed locally in your browser — nothing is uploaded.

0 characters

CSV

Output appears here…

Nested objects become dot-path columns (contact.email), the header is the union of all keys, and fields containing the delimiter, quotes, or newlines are quoted per RFC 4180.

About JSON to CSV

Turn a JSON array of objects into CSV you can open in a spreadsheet. Nested objects are flattened into dot-path columns (contact.email), the header is the union of every key across all rows in first-seen order, and cells containing the delimiter, quotes, or newlines are quoted exactly as RFC 4180 requires.

Common uses

  • Export an API response for analysis in Excel or Google Sheets
  • Hand structured data to a non-technical teammate
  • Convert seed data from JSON fixtures into CSV imports

Example

Input

[{"name":"Ada","contact":{"city":"London"}}]

Output

name,contact.city
Ada,London

Limitations

  • The input must be a JSON array of objects — a single object or array of primitives is rejected
  • Arrays inside a row are kept as JSON text in their cell rather than exploded into columns