When would you convert JSON to CSV?
APIs return data as JSON, but spreadsheet tools like Excel, Google Sheets, and Numbers work best with CSV. If you've pulled data from a REST API or exported records from a database and need to open them in a spreadsheet, converting JSON to CSV is the bridge. It's also useful for sharing data with colleagues who aren't developers — CSV is universally understood and can be opened without any special tools.
How the conversion works
The converter reads the first object in your JSON array and uses its keys as column headers. Each subsequent object becomes a row. If a value contains a comma, double quotes, or a newline, it is automatically wrapped in double quotes and internal quotes are escaped. Nested objects and arrays that can't be flattened into a single cell are serialized as JSON strings.
Input requirements
The input must be a valid JSON array of objects — e.g. [{"id":1,"name":"Alice"},{"id":2,"name":"Bob"}]. A JSON object (not an array) or a JSON array of primitives (strings, numbers) will produce an error. All objects should ideally share the same keys; if later objects are missing keys that appear in the first object, those cells will be empty.
Downloading the result
Click "Download CSV" to save the output as export.csv directly from your browser — no server involved. The file is generated in memory from your converted data. You can then open it in Excel or Google Sheets, or import it into any database that accepts CSV input.