JSON→CSV converter
Convert an object array into a CSV table with column names.
Input
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Result
Check or change the value using the example value result.
Nested objects are placed as JSON strings. Spreadsheet formula characters are enclosed in single quotes.
Share result
Share the tool link and result text together. No URL is included in the result. Check the below content and then share it.
Calculation·conversion criteria
Convert an object array into a CSV for spreadsheet use.
Input example
[{"name":"A","score":1}] → name,score row
[{"name":"A"},{"name":"B","score":10}] creates two columns: name and score. The missing score in the first row is left blank. Values containing commas or quotes are formatted according to CSV rules.
How to use
- Use the provided example value or replace the JSON object array field.
- Click Verify result and check the following result.
- Result can be copied if needed.
Frequently Asked Questions
If you convert then convert back to JSON, will the original type be restored?
No. CSV does not have type information for numbers, booleans, or nested structures. Nested values become JSON strings, and values interpretable as formulas may have protective double quotes added.
Calculation criteria and reference materials
- RFC 8259 — JSON
JSON syntax and interoperability considerations for number precision
- RFC 4180 — CSV
Comma separation, field quote and newline rules. Spreadsheet formula protection is additional processing by this tool.
Verification of calculation criteria: · Calculation·verification principles · Report errors