JSON to CSV Converter
Converted CSV will appear here…
Exporting nested API payloads and database documents into tabular formats enables analysts to perform spreadsheet auditing and data visualization easily. Using our json to csv converter, developers can flatten complex object arrays into clean, RFC 4180 compliant comma-separated files. The intelligent transformation engine handles nested objects by flattening property keys with dot-notation column headers and escaping embedded quotes. Ideal for business analysts seeking an easy json to csv online free utility or developers generating excel converter datasets, this browser tool executes instantly without uploading sensitive company metrics to remote servers.
Guide
About JSON to CSV Conversion
What JSON structure can be converted?
CSV works best for arrays of flat objects — data that looks like a database table. Each array item becomes a row; each key becomes a column. If your JSON isn't an array at the top level, the tool looks for an array inside the first object automatically.
How does nested object flattening work?
Nested objects are flattened with dot notation. An object like {"address":{"city":"Paris"}} becomes the column address.city. Nested arrays produce indexed columns: tags.0, tags.1. A warning is shown whenever arrays are indexed so you can decide if that's appropriate.
How are missing fields handled?
All unique column names across every row are collected first. If a row doesn't contain a particular key, the cell is left empty. This means uneven or sparse objects produce valid, correctly aligned CSV without data misalignment.
Which delimiter should I choose?
Use comma for most spreadsheet applications (Excel, Google Sheets). Use semicolon if your data contains commas within values and you don't want to deal with quoted fields. Use tab for TSV format, which many data tools prefer. The downloaded file reflects your delimiter choice.
Converting JSON to CSV is one of the most common data-wrangling tasks for developers, analysts, and anyone working with API data. REST APIs return JSON by default, but spreadsheet tools like Google Sheets, Microsoft Excel, and Python's pandas all work most naturally with CSV or tabular formats. This tool bridges that gap without requiring any code.
Paste a JSON array of objects and the converter automatically detects all column names across every row — including rows with different sets of keys. Nested objects like {"user": {"name": "Alice", "role": "admin"}} are flattened to user.name and user.role columns by default. You can toggle this behaviour off if you'd prefer to keep nested objects serialised as JSON strings within cells.
Worked example: Paste [{"id":1,"address":{"city":"Paris"}},{"id":2,"address":{"city":"Tokyo"}}]. With flattening enabled, the output has columns id and address.city. Row 1 is 1,Paris, row 2 is 2,Tokyo. Paste that CSV directly into Google Sheets and you get a clean two-column table. Without flattening, address would appear as {"city":"Paris"} — a JSON string in a single cell.
The Download .csv button exports the result as a properly RFC 4180-compliant file: fields containing the delimiter, double quotes, or newlines are automatically wrapped in double quotes. Once you have a CSV, you can drag it directly into Google Sheets or open it in Excel with the correct column structure.
JSON to CSV vs CSV to JSON — which do you need?
These tools run opposite workflows. This page converts JSON into CSV — use it to export API data for spreadsheet analysis, produce reports for stakeholders, or prepare data for a SQL import wizard. The CSV to JSON Converter runs the reverse — use it to import a spreadsheet into a JavaScript app, a NoSQL database, or a REST API payload. Both tools are stateless and process all data locally, so sensitive data (PII, API responses, credentials in payloads) never leaves your browser.
If you need to validate your JSON before converting, use the JSON Validator to catch any syntax errors first. After converting to CSV and then back to JSON, the JSON Schema Generator can automatically produce a draft-07 schema from the output — useful for documenting the shape of your API data.