ZippyToolkit

JSON to CSV

JSON to CSV turns an array of JSON objects into rows and columns. Nested objects are flattened into columns like “address.city”, arrays are kept as JSON text, and every key found in any row becomes a column.

  • JSON → CSV, XLSX
  • Runs in your browser
  • Free, no sign-up
Loading tool…

How to use JSON to CSV

  1. Paste JSON or drop a .json file.
  2. The tool validates it and previews the table.
  3. Choose a delimiter and whether to flatten nested objects.
  4. Download CSV or Excel.

Examples

  • Input: [{"name":"Ana","address":{"city":"Lisbon"}}] → columns “name, address.city”.

Supported formats

InputJSON
OutputCSV, XLSX
ProcessingOn your device, in the browser (no upload)

Limitations to know

  • The input must be a JSON array of objects (or a single object, treated as one row). Arrays of plain values become a single “value” column.
  • Very large files (over ~100 MB) may be slow on mobile devices.

Privacy: JSON to CSV runs entirely in your web browser. Your JSON data is not uploaded, stored or shared, and nothing about its contents is sent to analytics.

Frequently asked questions

How are nested objects handled?

With flattening on, {"user":{"id":1}} becomes a column named “user.id”. With it off, nested objects are written as JSON text in a single cell.

What if rows have different keys?

Every key that appears in any row becomes a column. Rows missing a key get an empty cell.

References

Last updated · Maintained by the ZippyToolkit team