JSON to CSV Converter
Paste a JSON array of objects and get a spreadsheet-ready CSV — nested fields flattened, every column included.
Input
CSV
Text Tools
Paste a JSON array of objects and get a spreadsheet-ready CSV — nested fields flattened, every column included.
APIs, databases and no-code tools export data as JSON, but most people analyse data in Excel or Google Sheets. This converter turns a JSON array of objects into CSV, where every object becomes a row and every key becomes a column. Paste the JSON, then copy the CSV or click Download .csv and open the file directly in Excel, Numbers or Google Sheets.
Given this input:
[
{"id": 1, "name": "Ana", "address": {"city": "Lisbon"}},
{"id": 2, "name": "Ben, Jr.", "tags": ["admin", "beta"]}
]you get:
id,name,address.city,tags
1,Ana,Lisbon,
2,"Ben, Jr.","[""admin"",""beta""]"tags above) silently disappear. This tool scans every row and leaves cells empty where a field is missing.address.city. Untick Flatten to keep each nested object as JSON text in a single cell.0, false and empty strings are preserved, while null becomes an empty cell.Need to tidy the JSON first? Validate and pretty-print it with the JSON Formatter. Conversion happens in your browser; your data is not uploaded.
JSON Formatter, YAML to JSON Converter, String Splitter, Remove Duplicate Lines.