What this tool does
This converter mainly accepts Array of Objects. It will scan all objects to collect headers; when a row is missing fields, empty cells will be retained, and nested objects or arrays will be JSON.stringified first to avoid [object Object].
- CSV is generated by the mature Papa Parse parser.
- 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
- Paste the JSON with the top level array of objects.
- 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. It is suitable for daily development, debugging, data sorting and code optimization scenarios. The processing results can be directly viewed, copied or downloaded.
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.