Convert JSON arrays of objects to CSV format instantly. This free online tool extracts column headers from JSON keys, flattens nested objects using dot notation, and generates a downloadable CSV file ready for Excel, Google Sheets, or data analysis. Handles large datasets client-side — your data never leaves your browser. Supports custom delimiters and handles edge cases like commas and quotes in values per RFC 4180.
json-to-csv.tool
0 characters
Paste JSON above to convert...
Frequently Asked Questions
How do I convert a JSON file to CSV?
Paste your JSON array of objects into the input above. The tool automatically extracts column headers from object keys and converts each object into a CSV row. Click "Download CSV" to save the file. The JSON must be an array like [{"name":"Alice"},{"name":"Bob"}]. Single objects are wrapped in an array automatically.
Can I convert nested JSON to a flat CSV?
Yes. When "Flatten nested objects" is checked, nested objects are flattened using dot notation. For example, {"user":{"name":"Alice"}} becomes a column user.name with value "Alice". Nested arrays are serialized as JSON strings in the CSV cell.
What is the difference between JSON and CSV?
JSON is a hierarchical format supporting nested objects, arrays, and typed values (strings, numbers, booleans, null). CSV is a flat tabular format with rows and columns — everything is a string. JSON is ideal for APIs and complex data; CSV is better for spreadsheets, databases, and tabular analysis. Converting between them often requires flattening or restructuring.
How do I open JSON data in Excel?
Convert your JSON to CSV first, then open the CSV in Excel — it auto-maps columns. Alternatively, Excel 2016+ has Power Query (Data → Get Data → From JSON) that imports JSON directly with transformation options. Google Sheets can also import CSV files via File → Import.
Is my data safe during conversion?
Yes. All conversion happens in your browser using JavaScript. No data is uploaded, stored, or logged on any server. You can safely convert sensitive API responses, database exports, or confidential datasets.