JSON to CSV

Turn a JSON array of objects into a spreadsheet-ready CSV. Nested objects are flattened with dot paths, values are escaped per RFC 4180, and nothing leaves your browser.

JSON input (array of objects) CSV output

Walkthrough

How to use it

Paste a JSON array of objects, or click Paste JSON to grab it from the clipboard.
Headers are collected from every object and ordered by first appearance.
Arrays like skills become JSON strings in the cell; nested objects become dot paths like meta.remote.
Click Download .csv to get a UTF-8 file with BOM for Excel compatibility.

Use cases

When you'd use this

API data to spreadsheets. Dump a REST collection endpoint into CSV for reporting or stakeholder review.

Database export. Turn a small query result (as JSON) into a CSV you can import into numbers tools or mail filters.

Bulk operations. Generate CSV for bulk upload forms that accept spreadsheet input.

FAQ

Common questions

How are nested objects handled?

Keys become dot-paths: meta.remote becomes a column, and meta.team another. Arrays are JSON-serialized into a single cell, matching how most ETL tools flatten data.

What if the array is empty or values are missing?

An empty array or object produces a CSV with just a header. Rows missing a key leave the cell empty; extra keys in later rows add columns, so no data is dropped.

Does it handle Excel-friendly escaping?

Yes. Values containing commas, quotes or newlines are quoted per RFC 4180, embedded quotes are doubled, and the downloaded file includes a UTF-8 BOM so Excel opens it correctly.