JSON to CSV
Convert a JSON array of objects into a spreadsheet-ready CSV file.
Related Tools
Convert CSV to JSON with delimiter detection and header toggle.
Beautify and pretty-print JSON with configurable indentation.
Convert JSON to YAML while preserving key order.
Convert YAML to JSON with instant syntax validation.
Convert JSON to well-formed XML.
Convert XML to JSON, preserving attributes and namespaces.
Documentation
What is JSON to CSV?
It converts a JSON array of objects into a spreadsheet-ready CSV file — the most common shape for exporting API responses into Excel or a database import tool.
Example
Input: [{"name":"Alice","age":30},{"name":"Bob","age":25}]
name,age Alice,30 Bob,25
Common errors
The input must be a JSON array at the top level — a single object or a deeply nested structure without a flat array of records won't convert cleanly.
Frequently Asked Questions
What JSON shape does this expect?▾
An array of flat-ish objects, like [{"name":"Alice","age":30}]. Each object becomes a row; the union of all keys across every object becomes the column headers.
What happens to missing fields?▾
If an object is missing a key that other objects have, that cell is left blank in the output row — the column still exists.
What happens to nested objects or arrays?▾
A nested value is serialized as a compact JSON string inside its cell, so no data is lost, though it won't be split into further columns.
Can I open the output in Excel or Google Sheets?▾
Yes — the output is standard RFC 4180 CSV. Download it as a .csv file and open it directly in any spreadsheet application.
Does this tool upload my data?▾
No. The conversion runs entirely in your browser; nothing is sent to a server.