Loading…
Convert a JSON array of objects into a clean, correctly escaped CSV table — processed entirely in your browser.
Your CSV will appear here after you convert.
This tool turns JSON into CSV (comma-separated values) — the tabular format spreadsheets and data tools understand. The natural input is an array of objects, where each object becomes a row and each property becomes a column.
[
{ "name": "John", "age": 30 },
{ "name": "Jane", "age": 28 }
]name,age
John,30
Jane,28CSV is ideal for importing data into spreadsheets (Excel, Google Sheets), loading into databases and BI tools, or sharing tabular data with people who don’t work with JSON.
Nested objects are flattened into dotted column names such as user.name. Arrays inside objects are stored as JSON text in the cell so no data is lost. Values containing commas, quotes, or newlines are quoted and escaped per standard CSV rules, and values that look like spreadsheet formulas are neutralized to prevent CSV injection.
Going the other way? Use CSV to JSON. To tidy the input first, try the JSON Formatter.
An array of objects maps directly to rows and columns. A single object becomes one row, and an array of primitives becomes a single value column.
Nested objects are flattened using dotted column names such as user.name and user.age. Arrays inside objects are stored as JSON text in the cell so no data is lost.
Any value containing the delimiter, a double quote, or a newline is wrapped in double quotes, and inner quotes are doubled ("") — standard RFC 4180 CSV escaping.
Yes. To defend against CSV formula injection, values that begin with = + - @ and are not plain numbers are prefixed with a single quote so spreadsheet software treats them as text, not formulas.
If the top level mixes objects and non-objects, the tool explains that it cannot be represented as a single CSV table rather than producing misleading output.