JSON to CSV Converter
Paste an array of JSON objects and get a spreadsheet-ready CSV. Nested objects are flattened into their own columns.
id,name,role,address.city 1,Ada Lovelace,analyst,London 2,Alan Turing,cryptanalyst,Bletchley 3,Grace Hopper,"programmer, admiral",Arlington
| id | name | role | address.city |
|---|---|---|---|
| 1 | Ada Lovelace | analyst | London |
| 2 | Alan Turing | cryptanalyst | Bletchley |
| 3 | Grace Hopper | programmer, admiral | Arlington |
Questions people ask
What JSON shape converts best to CSV?
An array of objects, where each object is one row and each key a column: [{"name":"Ada","age":36},{"name":"Alan","age":41}]. Objects with different keys still work: every key found becomes a column and missing values are left blank.
What happens to nested objects?
With “Flatten nested objects” on, nested keys become dotted column names such as address.city. Arrays inside a row are kept as JSON text in a single cell so no data is lost.
Will Excel open the file correctly?
Yes. Values containing commas, quotes or line breaks are wrapped in double quotes as RFC 4180 requires, and the download is UTF-8 with a byte-order mark so Excel shows accented characters correctly. In regions that use a comma as the decimal separator, pick the semicolon delimiter.