Saved
Developer tools·Data Formats

JSON to CSV Converter

Turn JSON arrays into CSV or CSV into JSON with header detection. Fully client-side — no account, uploads, or remote storage.

Added Apr 29, 2026

Input

Result

Enter a value for json array to see your result.

How it works

Converts a JSON array of objects into CSV (Comma-Separated Values) format. The first row becomes the header row using all unique keys found across the objects. Useful for exporting data to spreadsheets.

Step by step

  1. 01Paste a JSON array of objects (each object becomes one row).
  2. 02All unique keys across all objects become the CSV columns.
  3. 03Values are escaped — strings containing the delimiter or quotes are wrapped in double quotes.
  4. 04Copy the CSV and paste into Excel, Google Sheets, or any CSV-compatible tool.

Examples

Simple user list

Each object becomes a row; unique keys become column headers.

Inputs

JSON array:
[{"name":"Alice","age":30},{"name":"Bob","age":25}]
Delimiter:
,

Result

CSV output:
name,age Alice,30 Bob,25
Note: Only flat (non-nested) objects are fully supported. Nested objects are serialised as JSON strings in the cell. The input must be a JSON array (starting with [), not a single object.

Related guides

  • What Is JSON?

    Learn what JSON (JavaScript Object Notation) is, how to read and write it, common syntax errors, and best practices for using JSON in APIs and configuration.

  • JSON vs XML — When to Use Each Format

    A direct comparison of JSON and XML covering syntax, verbosity, data types, namespaces, and schema validation — with clear guidance on when to use each format.

Frequently asked questions

Does this handle nested JSON?

Nested objects and arrays are converted to their JSON string representation in the CSV cell. For full nested support, flatten your JSON first.

Can I paste the result into Excel?

Yes — copy the CSV output and paste into Excel or Google Sheets. If your locale uses semicolons as decimal separators, choose the semicolon delimiter.