Convert JSON to CSV online free. Turn JSON arrays into Excel-ready CSV instantly. No upload, no signup — processed locally in your browser. Free online.
Keys are collected across rows in first-seen order. JavaScript orders integer-like object keys numerically within each object. Later new keys are added as further columns.
Missing keys, undefined values and null become empty cells. A false boolean becomes false, and a zero becomes 0; they are not treated as missing.
No. It displays Invalid JSON format for parse failures. A non-array input shows JSON must be an array of objects; an empty array shows Array is empty.
No. CSV is text without type metadata. Your spreadsheet decides whether values are dates, numbers or formulas. Inspect untrusted values before importing.
This free online converter transforms JSON arrays into CSV (comma-separated values) format. JSON is how APIs and web applications store data. CSV is what spreadsheets and databases understand. This tool bridges the gap between the two.
Data often comes in JSON format, but you need it elsewhere:
Paste your JSON array (e.g., [{"name": "John", "age": 30}, {"name": "Jane", "age": 25}]) into the input area. The tool automatically extracts all keys to create column headers. Each object becomes a row. String values containing commas, quotes or newlines are quoted. Headers and non-string values are not escaped; check them before copying or downloading.
The tool expects a JSON array of objects. Each object represents a row, and each key becomes a column. Nested objects are converted to their string representation. For best results with deeply nested data, flatten it first or use a different approach.
Business analysts exporting API data to spreadsheets. Developers creating data dumps for clients. Data scientists preparing datasets. Marketing teams analyzing campaign data. Product managers creating reports from analytics APIs.
If your JSON is invalid, the tool will show a clear error message. Common issues include missing brackets, trailing commas, or unquoted strings. Fix the JSON syntax and try again.
Conversion happens in JavaScript on your machine. The converter does not upload the pasted JSON.
Need to clean up your data first? Try our Remove Duplicate Lines tool. Working with PDFs? Check out PDF Compress.
Input: [{"name":"Mina","qty":2},{"name":"Omar","price":5}]. CSV Output has these three lines: name,qty,price
Mina,2,
Omar,,5. The price column is added when the second object is inspected. Each missing value leaves an empty cell, so both rows have the same header positions.
Input: [{"item":"Pen, blue","note":"Say "Hi"","qty":null}]. The header is item,note,qty. The data row is "Pen, blue","Say ""Hi""",. The comma-containing string is quoted, embedded quotation marks are doubled, and the null quantity leaves a trailing empty cell. No extra data row is added.
Nested objects are not flattened into dotted columns: String(value) produces [object Object]. Arrays also use String(value); [1,2] becomes 1,2 without CSV quoting and can shift columns. Flatten nested data yourself before conversion.
Only string values get comma, quotation-mark and newline escaping. Headers are joined without escaping, so keys containing those characters need cleanup. Keep each array entry a non-null row object; mixed entries are not reliably validated.
The page has no enforced text-length limit, but parsing and conversion run immediately in browser memory. This operation sends no conversion request. The download uses comma separators and newline-separated rows, with no option for semicolons or another delimiter.
Browse all free tools · Guides and tutorials · PDF tools · Developer tools · Text tools · SEO tools