ZeroTool Workbench

JSON to CSV Converter

Convert JSON arrays to CSV instantly. Supports nested object flattening (dot-path), custom delimiters, and RFC 4180 escaping. Free, 100% client-side.

100% Client-Side Your data never leaves your browser Free · No Sign-Up
Delimiter
Flatten nested objects
Include header
JSON Input
CSV Output

Related Tools

JSON Formatter Prettify, minify, and validate JSON instantly in your browser. CSV to JSON Converter Convert CSV to JSON and JSON to CSV instantly. Handles quoted fields, auto-detects headers. YAML to JSON Converter Convert YAML to JSON and JSON to YAML instantly. Supports nested objects, arrays, and all YAML 1.2 features. XML Formatter Format, beautify, and minify XML documents with syntax validation. TOML to JSON Converter Convert between TOML and JSON formats instantly with validation. JSON Diff Compare two JSON objects and visualize differences. Outputs RFC 6902 JSON Patch and a color-coded tree diff.

How to Use

  1. Paste a JSON array of objects into the left panel. The tool converts automatically.
  2. Choose a delimiter: comma (default), semicolon, or tab.
  3. Toggle Flatten nested objects to expand nested keys into dot-path columns (e.g. address.city).
  4. Toggle Include header to add or suppress the header row.
  5. Click Copy to copy the CSV or Download .csv to save the file.

Worked Examples

Basic conversion

Input JSON:

[{"id":1,"name":"Alice"},{"id":2,"name":"Bob"}]

Output CSV:

id,name
1,Alice
2,Bob

Nested object flattening

Input JSON:

[{"user":{"name":"Alice","age":30}}]

Output CSV (flatten on):

user.name,user.age
Alice,30

Fields with commas

A field value containing a comma is automatically quoted:

name,description
Widget,"Small, round widget"

RFC 4180 Compliance

This tool follows the RFC 4180 CSV standard. Fields containing the delimiter, double quotes, or line breaks are enclosed in double quotes. A literal double-quote is escaped as "".

FAQ

What JSON format is accepted?

The tool accepts a JSON array of objects, e.g. [{"id":1,"name":"Alice"},{"id":2,"name":"Bob"}]. Each object becomes one CSV row.

How does nested object flattening work?

When 'Flatten nested objects' is on, a field like address.city becomes a separate CSV column named address.city. When off, the entire nested object is serialized as a JSON string in a single column.

What happens if objects have different keys?

The tool collects the union of all keys across every row and uses that as the header. Missing values for any row are output as empty strings.

How are special characters handled?

Fields containing the delimiter, double quotes, or newlines are automatically wrapped in double quotes per RFC 4180. A literal double-quote inside a field is escaped as two consecutive double-quotes.

Is my data sent to a server?

No. All conversion happens entirely in your browser. No data leaves your machine.