JSON to CSV
Developer tools
Paste a JSON array of objects. Nested values become dotted columns.
Runs in your browser
Nothing is uploaded. The work happens on your own device, so your file or text never reaches us.
About this tool
How nesting is flattened
CSV is flat and JSON is not, so something has to give.
Nested objects become dotted columns: {"user": {"name": "A"}} becomes a column user.name. Arrays of simple values are joined with semicolons into one cell. Arrays of objects become indexed columns, items[0].price.
Keys missing from some objects still get a column, left empty where absent, so the output is rectangular — which is the only thing a spreadsheet can open.
Questions
What happens to nested arrays?
Arrays of simple values are joined with semicolons in one cell. Arrays of objects are expanded into indexed columns like items[0].name.
Will Excel open the result?
Yes. Fields containing commas, quotes or newlines are quoted correctly, and line endings are CRLF, which is what Excel expects.
Related tools
CSV to JSONConvert CSV to JSON with proper handling of quoted fields, escaped quotes, embedded newlines and semicolon or tab delimiters. The delimiter is detected.JSON formatterFormat, minify and validate JSON. Errors point at the line and column and name the likely cause — a trailing comma, single quotes, a Python literal.Base64Encode and decode Base64, including non-ASCII text and emoji, with URL-safe output. Explains exactly why a given string is not valid Base64.Colour converterConvert between HEX, RGB and HSL with a live preview. Accepts every common notation, including 3, 4, 6 and 8-digit hex with alpha.