Convert JSON arrays of objects to CSV format. Automatically extracts all keys as headers. Supports comma, semicolon, and tab delimiters. Values containing the delimiter or quotes are properly escaped. Download the result as a .csv file.
Converting JSON to CSV bridges the gap between modern APIs and traditional spreadsheet tools. While JSON excels at representing complex, nested data, CSV's flat structure is what Excel, Google Sheets, and most data analysis tools expect. This converter flattens JSON arrays into CSV rows: each object becomes a row, each property becomes a column. It handles nested objects by creating dot-notation columns (address.city), arrays by joining values, and mixed types gracefully. Common use cases: exporting API data for business analysis, creating spreadsheet reports from database queries, and preparing data for import into legacy systems that only accept CSV.
Nested properties are flattened with dot notation: {address: {city: 'NYC'}} becomes a column 'address.city'. Deep nesting creates longer column names but preserves all data.
Array values are joined with a separator (default: semicolon). {tags: ['a','b','c']} becomes 'a;b;c' in the CSV cell. This is the standard approach for maintaining array data in flat CSV format.
Yes — use our CSV to JSON tool. Round-tripping works well for flat data. Nested objects flattened with dot notation may need manual restructuring to restore the original hierarchy.
Comma is standard (.csv). Tab for TSV compatibility. Semicolon is common in Europe where commas are decimal separators. Pipe (|) when data contains commas and semicolons.
Objects missing a property get an empty cell for that column. The converter builds columns from all properties across all objects, filling blanks where data is absent.