How to Use the JSON to CSV Converter
- Paste a JSON array of objects into the input box, e.g. [{"name":"Ada","age":30}].
- Click "Convert" to generate the CSV output.
- Copy the CSV or download it as a .csv file.
How the conversion works
The converter reads the keys from the first object in the array to build the CSV header row, then writes one row per object, matching values to their corresponding columns. Fields containing commas, quotes, or line breaks are automatically wrapped in quotes to keep the CSV valid.
Limitations to be aware of
CSV is a flat, tabular format, so deeply nested objects or arrays within a field are converted to their JSON string representation rather than expanded into further columns. If your JSON has inconsistent keys across objects, missing fields are left blank in that row.
Example
JSON input
[{"name":"Ada","age":30},{"name":"Grace","age":41}]
name,age Ada,30 Grace,41
Tips
- Make sure your JSON is an array of flat (non-nested) objects for the cleanest CSV output.
- Open the resulting CSV in a spreadsheet app to verify columns line up as expected.
Frequently Asked Questions
What happens with nested objects or arrays?
Nested values are converted to their JSON string form and placed in a single cell, since CSV cannot represent nested structure natively.
Does column order matter?
Columns follow the key order of the first object in the array.