How it works
The JSON to CSV Converter transforms a JSON array of objects into a comma-separated values string, with column headers derived from the object keys. It handles nested objects, array values, and optional flattening of deep structures.
JSON to CSV conversion is a frequent task when you need to open API response data in a spreadsheet, export data from a JavaScript application to Excel, or prepare structured data for a database bulk import that expects CSV format.
How to use it: paste your JSON array. The tool extracts all unique keys across all objects (handling sparse data where some objects have keys others don't), generates a header row, and maps each object to a CSV row. Cells containing commas or newlines are automatically quoted.
Options: choose delimiter (comma, tab for TSV, semicolon, pipe), select columns to include or exclude, flatten nested objects using dot notation (so {"user": {"name": "Alice"}} becomes a "user.name" column), and convert arrays to semicolon-joined strings in a single cell.
Download as .csv: the output can be downloaded as a properly encoded CSV file, ready to open in Excel, Google Sheets, or import into a database.
Frequently Asked Questions
- The tool collects all unique keys across all objects in the array and uses them as the header row. Objects missing a key have an empty cell for that column.
- By default, nested objects are JSON-stringified into a single cell. Enable 'Flatten nested objects' to expand them using dot notation — {user: {name: 'Alice'}} becomes a 'user.name' column.
- Yes. After parsing, a column selector is shown where you can check/uncheck individual keys before generating the CSV output.
- Yes. Click 'Download CSV' to save the output as a properly encoded CSV file. The file uses UTF-8 BOM encoding by default, which ensures correct opening in Excel.