About JSON to CSV Converter
Converts JSON to CSV entirely in your browser. An array of objects becomes rows; the header is the union of every object’s keys, so objects with different or missing fields still line up (missing values are left blank). Nested objects are flattened to dot-notation columns (owner.team), and arrays or nested structures that cannot become a column are written as a JSON string in the cell. Every value is escaped to RFC 4180 — fields containing the delimiter, quotes, or newlines are quoted and inner quotes doubled — so the output opens cleanly in Excel, Sheets, or any CSV parser. Choose a comma, semicolon, or tab delimiter and download the result as a .csv file.
- Array of objects → rows; header is the union of all keys (missing values blank)
- Nested objects flatten to dot-notation columns (e.g. owner.team)
- Arrays / non-flat values are written as a JSON string in the cell
- RFC 4180 escaping: quotes fields with delimiter/quote/newline, doubles inner quotes
- Comma, semicolon, or tab delimiter; copy or download as .csv
- Runs fully client-side — your data never leaves the browser
Frequently Asked Questions
- What if my objects have different keys?
- The CSV header is the union of every key seen across the array, in first-appearance order. Objects missing a key simply get a blank cell in that column, so rows stay aligned.
- How are nested objects and arrays handled?
- Nested objects are flattened into dot-notation columns (owner.team). Arrays and other non-flat values that cannot map to a single column are written as a JSON string in the cell, so no data is lost.
- Will the CSV open correctly in Excel?
- Yes — output follows RFC 4180: any value containing the delimiter, a double-quote, or a newline is wrapped in quotes with inner quotes doubled. Pick the semicolon delimiter if your locale’s Excel expects it.
More Converters Tools
All Converters toolsURL Encoder Decoder
Encode and decode URL strings.
Color Code Converter
Convert colors between hex, RGB, HSL, and CMYK.
Data Storage Converter
Convert between bytes, KB, MB, GB, TB, and more.
Roman Numeral Converter
Convert between Roman numerals and regular numbers.