INPUT - JSON
OUTPUT - CSV
Output will appear here
100% client-side
Output will appear here
Convert JSON arrays to CSV format online with our free JSON to CSV converter. The tool auto-generates column headers from object keys, flattens nested structures with dot notation, and produces RFC 4180 compliant output ready for Excel, Google Sheets, or database import.
Try Convert All - paste JSON once, see TypeScript, Go, YAML, and 15 more formats instantly.
Enter a JSON array of objects in the editor. Each object in the array becomes a row in the CSV output, and object keys become column headers.
The output shows comma-separated values with headers derived from your JSON keys. Nested objects are flattened using dot notation (e.g., address.city).
Copy the CSV to your clipboard or download it as a .csv file ready to open in Excel, Google Sheets, or import into a database.
Nested objects are flattened using dot notation. For example, an object {"address": {"city": "NYC"}} produces a column named "address.city" with the value "NYC". This keeps all data accessible in a flat table format.
Yes. The generated CSV follows RFC 4180 standards and opens correctly in Microsoft Excel, Google Sheets, LibreOffice Calc, and most spreadsheet applications. Special characters are properly escaped.
The converter collects all unique keys from every object in the array to build the header row. Objects missing a particular key will have an empty cell in that column, ensuring no data is lost.
Yes. When a field value is an array of primitives, the elements are joined with semicolons into a single CSV cell. Arrays of objects are flattened recursively using indexed dot notation.