JSON to CSV Converter
Convert JSON arrays to CSV spreadsheet format instantly
JSON arrays to CSV in seconds
Paste any array of objects and get a properly formatted CSV file. Column headers are detected automatically from your JSON keys.
Handles nested objects
Nested JSON objects can be flattened using dot-notation (e.g. address.city) or stringified inline. Arrays within objects are always stringified.
Ready for Excel and Google Sheets
Choose comma or semicolon delimiter to match your regional settings. Quoting options ensure fields with commas or line breaks are handled correctly.
Frequently asked questions about JSON to CSV conversion
Arrays, nested data, Excel import and delimiter choices
The tool expects a JSON array of objects — a list starting with [ where each item is a { } object. For example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. A single object {…} is not supported because CSV needs rows, and a single object is just one row with no consistent structure to iterate.
You have two choices. "Flatten nested objects" expands each nested object into separate columns using dot notation — {"address":{"city":"Berlin"}} becomes an address.city column. "Stringify nested" keeps the nested object as a JSON string in a single cell, which is safer when nesting is deep and you don't want dozens of new columns.
This depends on your regional settings. In most English-speaking countries Excel expects comma (,) as the delimiter. In Germany, France and other countries that use comma as the decimal separator, Excel expects semicolon (;) instead. If your CSV opens with all data in one column, try switching the delimiter. Tab-delimited files (TSV) are universally supported and avoid delimiter conflicts altogether.
By default, fields are only quoted when necessary — when they contain the delimiter character, a double quote, or a line break. Enabling "Quote all fields" wraps every value in double quotes, even simple numbers and short strings. This produces larger files but maximises compatibility with older or stricter CSV parsers that expect quoted fields.