What this tool does
Enter a JSON array of objects to create a CSV table. Fields from all objects become column headers, missing fields leave empty cells, and nested objects and arrays are kept as JSON text within cells.
- Convert a JSON array into a CSV table that you can open in a spreadsheet.
- Commas, double quotes, and intra-field newlines are escaped according to CSV rules.
- Values starting with a formula symbol are protected against spreadsheet injection.
How to use it
- Turn a JSON array into a CSV table for use in a spreadsheet.
- Click "Convert to CSV".
- Check headers, empty fields, and nested values.
- Copy the results or download result.csv.
Common uses
- Import interface responses into Excel or spreadsheet software.
- Convert test data into a flat format for data analysis.
- Summarize fields that are not identical in different objects.
JSON → CSV Features
Convert object arrays to standard CSV, correctly handling quotes, commas, newlines, and missing fields. Review the result, then copy it for use.
FAQ
Can the top-level JSON object be converted?
The explicit input model for this tool is an array of objects; put individual objects into the array first, for example [{"name":"Tom"}].
How to output nested objects?
Nested objects and arrays will be serialized into JSON strings and placed in a CSV field, not into [object Object].
What happens if a field is missing?
The header takes the union of all object fields; when an object does not have this field, the corresponding cell is left blank.