JSON to CSV Converter

Try a small example

Load the fictional example in a cleared form. Check the options, run the tool if needed, and compare the result below.

Use the first-seen object keys as CSV columns and serialize nested values as JSON text in one cell. Choose whether JSON null becomes a blank cell or the text null. Paste a JSON array of objects; for example, [{"name":"Ada","score":10}]. Keys become columns and each object becomes a row. Choose whether null becomes an empty cell or the text null. Missing properties and empty strings become blank cells. Nested values stay as JSON text in one cell. Numbers that JavaScript cannot preserve exactly are rejected rather than rounded. Before opening output in a spreadsheet, review untrusted cells that begin with =, +, -, @, a tab, or a line break; they may be interpreted as formulas. CSV has no native null type: a blank cell cannot distinguish null, an empty string, and a missing property. The converter stops rather than round numbers that JavaScript cannot preserve exactly. It cannot create useful columns from an empty array or objects with no keys. If you open the output in a spreadsheet, review untrusted cells that may be interpreted as formulas; CSV quoting alone does not make every spreadsheet safe.

[{"id":"001","note":"tea, coffee"},{"id":"002","note":"hello"}]

Expected output

id,note
001,"tea, coffee"
002,hello

The example is unavailable until the tool is ready.

Text is processed in your browser.