What this tool does
Converts one JSON object or a nonempty array of objects to CSV. For arrays, all record keys are included as columns.
Data and text tool
Convert JSON arrays to CSV format for use in Excel, Google Sheets, or data analysis tools. Handles nested objects and arrays.
Complete guide
Developer tools guide for json to csv converter users.
JSON is the output format of most APIs. CSV is what spreadsheets and data tools expect. Converting between them is a daily task for data analysts, backend developers, and anyone exporting API data to a spreadsheet.
This tool converts one JSON object or an array of objects into CSV rows. For arrays, the header uses the union of keys across all records, so fields first appearing in later records are retained. Nested objects and arrays are serialized as JSON text in their cell rather than flattened into extra columns.
Converts one JSON object or a nonempty array of objects to CSV. For arrays, all record keys are included as columns.
Paste valid JSON or choose a JSON file, then convert and download the CSV. The first row contains column headers.
Nested values are serialized as JSON text in a cell. Missing keys and null values become empty cells. Values that could be interpreted as spreadsheet formulas are prefixed for safety.
Answers
Enter one JSON object or a nonempty array of objects. For arrays, each object becomes a row and the CSV columns are the union of keys found across all records.
Nested objects are serialized as compact JSON text in one CSV cell; their fields are not flattened into separate columns.
Array values are serialized as JSON text in their CSV cell.
A record missing a column found in another record gets an empty cell. Null values are also exported as empty cells.