Convert 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 Converter?
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 Converter?
- 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 Converter?
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.
Frequently asked questions
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.
Tools that pair well with JSON to CSV Converter
- CSV to JSON Converter structured csv → json, free and in your browser.
- JSON to Excel Converter structured json → .xlsx, free and in your browser.
- JSON Formatter format & validate json, free and in your browser.
- TSV to CSV Converter tab-sep → comma-sep, free and in your browser.