TF

Converters

JSON to CSV Converter

Convert a JSON array into CSV for spreadsheets.

Runs locally in your browser — your input is not uploaded.

JSON files only (.json) — drag and drop supported
Paste a JSON array or upload a .json file.

What is this tool?

This converter takes a JSON array, typically an API response or database export, and turns it into CSV that opens cleanly in Excel, Google Sheets, or Numbers. Every key found across your objects becomes a column, so rows with missing fields still line up.

CSV is a simple tabular format that spreadsheets understand well. Converting JSON arrays into CSV flattens each object into a row using the union of all keys as headers.

Nested objects are stringified as JSON inside the cell so no data is silently dropped. For deeply nested structures, consider flattening your data first.

Conversion runs locally — your dataset stays on your device.

How to use the JSON to CSV

  1. Paste a JSON array of objects (or an array of arrays), or upload a .json file.
  2. Choose a delimiter if needed (comma is the default).
  3. Click Convert to generate CSV.
  4. Copy or download the result.

Examples

Simple object array

[{"name":"Ada","year":1815},{"name":"Grace","year":1906}]
name,year
Ada,1815
Grace,1906

Frequently asked questions

What JSON shapes are supported?

An array of objects or an array of arrays. A single object or nested-only structures are not converted automatically.

What happens to nested objects?

They are written into the cell as a JSON string, so nothing is silently dropped. If you want separate columns instead, flatten the data first with the Flatten action in the JSON Editor.

Which delimiter should I use for Excel?

Comma works in most locales. If your Excel uses a comma as the decimal separator, which is common in Europe, choose semicolon so the columns split correctly.

Want more power later?

Premium tools, higher limits, and API access are on the roadmap. V1 stays free and private in your browser.