JSON to CSV
Flatten JSON arrays to CSV
(root) · 3 rows · 5 columnsid,name,skills[0],skills[1],active 1,Ada,math,engineering,true 2,Ben,design,,false 3,Cara,math,pm,true
What is JSON to CSV?
Flatten any JSON array into a CSV spreadsheet. Nested objects become dot-notated columns ("user.name", "user.email"), nested arrays become bracket-indexed ("tags[0]", "tags[1]"), so no data is lost in the conversion. Auto-detects record arrays even when nested a level or two deep inside a wrapper object.
How do I use JSON to CSV?
- Paste JSON (array of objects, or object with an array field) into the input.
- Choose a delimiter: comma, semicolon, or tab.
- Toggle flatten for nested-object expansion.
- Copy or download the CSV.
When should I use JSON to CSV?
JSON to CSV builds a spreadsheet. For the inverse direction, use CSV ↔ JSON. To produce an .xlsx file directly (with cell types preserved better), use JSON to Excel.
My JSON is nested — how is that flattened?
Nested objects are flattened with dot-paths (user.name, user.age). Arrays become semicolon-separated values in a single cell, or exploded into multiple rows if you pick "Explode arrays".
Which delimiter should I choose?
Comma for US/UK spreadsheets, semicolon for EU spreadsheets where commas are decimal separators. Tab is safest for pasting into Excel or Google Sheets.
Does the CSV include a header row?
Yes, keys from the first object become the header. Uncheck "Include header" if you are appending to an existing file.
Is my file uploaded anywhere?
No. Everything runs in your browser. Your files never leave your device, and there is no server component for this tool.