JSON to CSV

A JSON to CSV converter flattens a JSON array of objects into comma-separated rows that open directly in Excel, Google Sheets, or any spreadsheet. This free tool reads your array, scans every object to gather the complete set of keys, and uses that union as the CSV header so records with slightly different fields still line up under the correct columns. Each object then becomes one row. The most useful behavior is how it handles structure that does not naturally fit a flat table. Nested objects are flattened into dotted column names, so {"address": {"city": "Berlin"}} produces a column called address.city. Arrays inside a record are generally kept as a JSON string inside a single cell, because a spreadsheet column has no clean way to store a list. Equally important is correct escaping. CSV uses commas to separate columns, so any value that itself contains a comma, a double quote, or a line break is wrapped in double quotes, and embedded quotes are doubled. Without that escaping, a value like "Acme, Inc." would split into two columns and shift every later field, which is the classic reason a CSV looks corrupted in Excel. Missing fields are written as empty cells rather than skipped, keeping every row the same width. This conversion is everyday work whenever JSON needs to reach a human or a spreadsheet-only tool: exporting an API response for analysis, handing a colleague a filterable sheet, or building an import file for a CRM or accounting system. Everything is processed locally in your browser, so the JSON you paste, including private API data, is never uploaded or stored.