JSON to CSV

Overview

• Converts JSON in the form of an array of objects into CSV format, which is easy to open in spreadsheet software.
• Each object in the array becomes one row of data, and each object key becomes a CSV column (header).
• It also handles patterns commonly seen in practice, such as elements with differing keys or values containing nested objects.

Usage

1. Enter the JSON (an array of objects) you want to convert into the text area.
2. Click the "Convert" button.
3. The result is displayed as CSV, with the header on the first line and data on the following lines.

Example

[{"name":"Taro","age":20},{"name":"Hanako","age":22}]

name,age
Taro,20
Hanako,22

Use Cases

• Downloading or sharing JSON array data fetched from an API as a CSV that can be opened in Excel
• Creating test or master data in JSON format, then handing it to a system that requires CSV import
• Converting JSON output from logs or reports into CSV format that is easier for non-engineer team members to read

FAQ

Notes

• A key that appears in only some elements of the array is still treated as a column; the corresponding cell is left blank for elements missing it.
• If a value contains a nested object or array, it is not expanded and is output as-is, as a JSON string, inside the cell.
• If a value contains a comma, newline, or double quote, it is automatically wrapped in double quotes per the CSV specification.