JSON to CSV Converter

Turn an API response into a spreadsheet. Nested fields become columns like address.city; missing fields become empty cells.

Input · drop a file

[{"id":1,"customer":{"name":"Ada","city":"Leeds"},"items":["shirt","tie"],"total":18.5},{"id":2,"customer":{"name":"Lin","city":"Porto"},"items":["suit"],"total":32,"express":true}]

Output

How the flattening works

Each object in the array becomes one row.
Nested objects become dotted columns: {"customer":{"city":"Leeds"}} → customer.city.
Arrays of plain values are joined with ; in one cell; arrays of objects get indexed columns such as lines[0].sku.
The columns are the union of all keys, in first-seen order.

If you paste a single object that contains an array (for example {"data":[…]}), the first array found is used.

Opening the CSV in Excel

Excel in many European locales expects semicolons. Pick Semicolon if all your data lands in column A. Values containing the delimiter, quotes or line breaks are quoted per RFC 4180.

Questions

Can I convert CSV back to JSON?

Not on this page — it focuses on the JSON → CSV direction that most people need for reporting.

Are numbers kept as numbers?

CSV has no types; the text is written exactly, and your spreadsheet decides how to interpret it.