JSON to CSV Converter
Convert JSON arrays to CSV with automatic header detection from object keys. Handles nested values and arbitrary delimiters.
How to use the json to csv converter
Paste a JSON array of objects on the left. The CSV equivalent appears live on the right, using each object's keys as column headers.
Formula & explanation
Headers = union of all object keys (left to right by first occurrence). Each row maps an object's values in header order. Values containing commas, quotes, or newlines are RFC 4180-quoted.
Examples
[{"name":"Alice","age":30}, {"name":"Bob","age":25}] becomes name,age\nAlice,30\nBob,25
Frequently asked questions
- What about nested objects?
- Nested objects and arrays are JSON-stringified into a single cell. Flatten with dot-notation keys ("address.city") before converting if you want them as separate columns.
- Can I customize the delimiter?
- Output is comma-delimited (the most portable). To re-import into Excel with a different delimiter, use Excel's Text Import Wizard or a one-line find/replace.
- Why does the first row become the header?
- That's the most common CSV convention. If your JSON has objects with different keys, every key across all objects becomes a column — missing values render as empty cells.
Related developer tools tools
- CSV to JSON ConverterConvert CSV to a JSON array of objects. Uses the first row as keys, handles quoted values, and detects common delimiters automatically.
- XML to JSON ConverterConvert XML to JSON for legacy API integration, SOAP responses, and config migration. Handles attributes, namespaces, and text content.
- JSON DiffCompare two JSON values semantically. Ignores key order; shows added, removed, and changed fields with their JSONPath — great for diffing API responses and config files.
- JSON to XML ConverterConvert JSON objects and arrays to well-formed XML. Maps object keys to elements, array items to repeated elements, with optional root wrapper.
- XML to CSV ConverterFlatten repeated XML elements into CSV rows with attributes and child text as columns. Great for opening XML data in Excel or Sheets.
- CSV to XML ConverterConvert CSV rows into XML elements with column headers as tag names. Useful for Excel exports, legacy systems, and ETL pipelines.