JSON to CSV
Flatten an array of objects into spreadsheet rows, using the keys as headers. Nested objects become dotted columns.
Rows appear here
Copies a link that reopens this tool with your input.
Common questions
What happens to nested objects?+
They flatten into dotted column names, so a role object with a title becomes a role.title column. Arrays of simple values join into one cell, since a spreadsheet row cannot hold a list.
Why are some values wrapped in quotes?+
RFC 4180 requires quoting any field containing a delimiter, a quote, or a newline. Without it a value with a comma would split into two columns when opened in a spreadsheet.