OptiDrop

JSON to CSV Converter — Convert JSON to CSV Online Free

Paste a JSON array of objects and instantly get CSV output. Handles nested objects with dot notation. Copy or download the CSV. 100% free, no sign-up.

What do you want to do next?

JSON Formatter Base64 Encoder

Free JSON to CSV Converter Online

OptiDrop's JSON to CSV Converter transforms JSON arrays of objects into CSV format instantly. This is invaluable for developers and data analysts who need to convert API responses, database exports, or structured JSON data into spreadsheet-friendly CSV format. The tool handles nested objects by flattening them with dot notation.

How to Convert JSON to CSV

Paste your JSON array of objects into the input field and click "Convert to CSV." The tool automatically extracts all unique keys as column headers and creates a row for each object. You can then copy the CSV to your clipboard or download it as a .csv file. The tool validates your JSON and shows helpful error messages if the format is incorrect.

Handling Nested Objects

When your JSON contains nested objects, the tool flattens them using dot notation. For example, {"address": {"city": "NYC", "zip": "10001"}} becomes two columns: "address.city" and "address.zip". Array values within objects are converted to JSON string representation. This approach ensures all data is preserved in the CSV output.

Frequently Asked Questions

Paste a JSON array of objects into the input field and click "Convert." The tool extracts all keys as column headers and flattens each object into a CSV row. Nested objects are flattened using dot notation (e.g., address.city becomes a column). You can then copy or download the resulting CSV.
Yes, nested objects are flattened using dot notation. For example, an object like {name: 'John', address: {city: 'NYC'}} becomes columns 'name' and 'address.city' in the CSV. Arrays within objects are converted to JSON strings. This makes complex JSON structures easy to export to spreadsheet applications.
The tool accepts a JSON array of objects, like [{key1: value1}, {key1: value2}]. Each object becomes a row in the CSV. The tool automatically collects all unique keys across all objects to create the header row. If a key is missing in some objects, the cell is left empty in the CSV.
Yes, after converting JSON to CSV, you can click the "Download CSV" button to save the CSV file to your device. The file is named "data.csv" by default. You can also copy the CSV text to your clipboard using the "Copy CSV" button.

Last updated: June 2026