MMaxTools

JSON to CSV

Convert a JSON array of objects into a clean CSV file in one click.

The JSON to CSV converter transforms a JSON array of objects into a spreadsheet-ready CSV file. Keys become headers automatically, values are quoted and escaped correctly (including commas, quotes and newlines inside values), and the result can be copied or downloaded as a .csv that opens cleanly in Excel, Google Sheets and Numbers.

This is the everyday bridge between APIs and analysis: an endpoint returns JSON, and you need rows in a table to filter, chart or share. The converter collects every key present across all objects (missing values become empty cells), so irregular records still produce a usable grid.

Conversion happens locally in your browser — API responses and datasets never leave your machine. For the reverse direction, the CSV to JSON tool rebuilds objects from a spreadsheet export.

How to use the JSON to CSV

  1. Paste a JSON array of objects (each object becomes a row).
  2. Click 'Convert to CSV'.
  3. Copy the CSV text or download the .csv file.
  4. Open the file in Excel, Google Sheets or Numbers.
  5. Watch for the header row — it is built from the union of all keys.

Frequently asked questions

What input format is expected?

A JSON array of objects: [{"name":"Ada","role":"Dev"}, …]. Each object becomes one row and its keys become columns. Nested objects or arrays in values are serialized as JSON strings inside the cell so nothing is lost.

How are special characters handled?

Values containing commas, double quotes, or line breaks are wrapped in quotes with internal quotes doubled, following the standard CSV rules. This keeps the file importable even with messy free-text data.

Will my CSV work in Excel?

Yes. The output follows RFC 4180 conventions that Excel, Google Sheets and Numbers all import correctly. If your locale expects a semicolon delimiter, Excel's import wizard can still parse this file correctly by choosing 'comma'.

Related tools

View all developer tools →
Dev Tools

JSON Formatter & Validator

Format, minify and validate JSON instantly with clear error messages that point at the exact problem.

Dev Tools

JSON Validator

Check if your JSON is valid and find syntax errors with exact line and column.

Dev Tools

JSON Minifier

Compress JSON to its smallest valid form for storage and transport.

Dev Tools

CSV to JSON

Convert CSV (from Excel or Google Sheets) into a JSON array of objects.

Dev Tools

Base64 Encoder

Encode text or files to Base64 — standard or URL-safe — in your browser.

Dev Tools

Base64 Decoder

Decode Base64 back to readable text — UTF-8 safe, instant and private.