Split Nested JSON into Multiple CSV Files
Use this when repeated arrays need their own CSV tables instead of being flattened into a single cell.
A specific workflow: Split Nested JSON into Multiple CSV Files
A customer export has orders and order items. Keep each list as its own CSV table while retaining the parent relationship.
Example input
{
"id": "order_42",
"customer": "Ari",
"items": [{ "sku": "SKU-1", "qty": 2 }]
}Expected output
data.csv: id,customer order_42,Ari data_items.csv: _parent_id,sku,qty order_42,SKU-1,2
How to use JSON to CSV
Paste or upload your JSON
Drop one or more .json files into the editor, or paste an array of objects straight from an API response. Nothing is transmitted anywhere.
Parsefy flattens the structure
Nested objects become dot-notation columns such as user.address.city. Choose Multiple output and repeated arrays are split into their own related tables instead.
Copy or download the CSV
Take the result as a single CSV file, or as a ZIP of related tables when you split arrays — ready for Excel, Google Sheets or a database import.
Other Parsefy tools
JSON to CSVTurn JSON arrays and API responses into spreadsheet-ready CSV, with nested data flattened automatically.CSV to JSONTurn CSV and spreadsheet exports into structured JSON, with headers mapped to keys and types detected automatically.JSON FormatterBeautify and validate minified JSON with readable indentation and clear syntax error messages.CSV ViewerOpen CSV files as a readable table in your browser, without Excel and without uploading the file.JSON to ExcelExport JSON as a real .xlsx workbook with formatted headers, ready to open in Excel or Google Sheets.CSV to ExcelConvert CSV into a real .xlsx workbook with correct UTF-8 encoding and a formatted header row.Flatten Nested JSONCollapse deeply nested JSON into flat keys with dot or bracket notation, then export the result as CSV.JSON ValidatorCheck whether JSON is valid and pinpoint the exact line, column and snippet where parsing fails.JSON MinifierStrip whitespace from JSON to shrink payloads, with a before-and-after byte count.