JSON to CSV converter
Convert a JSON object array to CSV with combined columns and spreadsheet formula escaping.
Processed in this browser · nothing is uploaded
Result
Ready when you areEnter your input and run the tool to see your result here.
Good to know
Enter an array of objects. Columns are combined in encounter order; nested values become JSON strings. Safe mode prefixes formula-like strings with an apostrophe.
Input: [{"name":"가","price":1000},{"name":"나","price":2000}]
Spreadsheet-safe text: trueUnderstand and use your results
Turn a JSON array of objects into a spreadsheet-friendly table. Keys from all objects become columns, but nested structures are not flattened into separate columns.
How to use it
- Enter JSON whose top-level value is an array of objects.
- Keep spreadsheet-safe mode enabled if opening the result in a spreadsheet, then download the CSV.
Worked example
[{"name":"A","price":1000}]name,price A,1000
The first row contains keys and subsequent rows contain values. CSV does not retain JSON number or boolean types, so converting it back will not automatically restore those types.
Why is an apostrophe added before some cells?
Safe mode prefixes formula-like strings beginning with characters such as =, + or - to reduce spreadsheet formula execution. Intentional formulas may become text too. Spreadsheet products differ, so inspect the result before using it.