JSON to CSV Converter
Turn structured JSON rows into copyable and downloadable CSV while keeping column order, quoting rules, and risky spreadsheet text visible and predictable.
A QUICK WALKTHROUGH
How to use this tool
- Paste one JSON object or an array containing up to 10,000 objects.
- Choose whether to protect text that spreadsheet apps could interpret as formulas.
- Convert, review the CSV, then copy it or download a UTF-8 CSV file.
Defined row and column rules
The top level must be one object or a non-empty array of objects. Columns are the union of own keys in first-seen JavaScript enumeration order. Nested arrays and objects become compact JSON; missing values and null become empty CSV fields.
CSV and spreadsheet boundaries
Rows use CRLF and fields containing commas, quotes, or line breaks use doubled-quote CSV escaping. Formula protection is enabled by default and prefixes an apostrophe to risky string cells and headers. Copied CSV has no byte-order mark; the download adds a UTF-8 BOM for spreadsheet compatibility. Large JSON integers may lose precision in the browser, so keep exact identifiers as strings.
GOOD TO KNOW
Common questions
Can I convert a single object?
Yes. It becomes one data row. An array converts each object to a row.
How are nested values handled?
Arrays and objects are stored as compact JSON inside one escaped CSV field; they are not flattened into extra columns.
Why is formula protection enabled?
Spreadsheet applications can execute text beginning with characters such as =, +, -, or @ as a formula. The option prefixes risky text with an apostrophe; turn it off only when exact string preservation matters more.