JSON to CSV Converter
Convert JSON arrays and objects to CSV format instantly.
JSON input
Examples
Input
[{"name":"Alice","age":30},{"name":"Bob","age":25}]Output
name,age Alice,30 Bob,25
Input
{"product":"Widget","price":9.99,"stock":100}Output
product,price,stock Widget,9.99,100
About this tool
Use this JSON to CSV converter to turn JSON arrays and objects into clean CSV files directly in your browser. It handles arrays of objects, single objects, missing keys, nested values, and special characters. You can choose your delimiter and download the result as a .csv file.
How to use
- Paste your JSON array or object into the input area.
- Choose a delimiter — comma, semicolon, or tab.
- Toggle headers on or off depending on your needs.
- Copy the CSV output or download it as a .csv file.
When to convert JSON to CSV
JSON is the standard format for APIs and web services, but spreadsheet tools like Excel and Google Sheets work better with CSV. Converting JSON to CSV lets you open API data directly in a spreadsheet without writing code.
This tool is useful when you receive JSON from an API response, a database export, or a configuration file and need to import it into a spreadsheet, BI tool, or data pipeline that expects CSV.
Handling arrays, objects, and nested data
This converter handles both arrays of objects (the most common case) and single objects. If some rows are missing keys that others have, the missing cells are left empty rather than shifting columns.
Nested objects and arrays within your JSON are serialised as JSON strings inside the CSV cell rather than being silently dropped. This keeps your data intact and makes it easy to identify fields that may need further processing.
FAQ
Can I convert a JSON array to CSV?
Yes. Paste a JSON array of objects and the converter extracts the keys as column headers and maps each object to a row.
What if my JSON objects have different keys?
The converter collects all unique keys across every object and uses them as columns. Missing values are left as empty cells.
Can I download the result as a .csv file?
Yes. Click the Download button to save the output as a .csv file you can open in Excel, Google Sheets, or any CSV-compatible tool.
Which delimiters are supported?
Comma, semicolon, and tab. Semicolon is common in European locales and tab is useful when values contain commas.
How are nested objects handled?
Nested objects and arrays are serialised as JSON strings inside the cell. This preserves the data without silently dropping fields.
Is this tool free?
Yes. The JSON to CSV converter is completely free, runs in your browser, and does not send your data anywhere.
Related Tools
CSV to JSON
Convert CSV data to JSON instantly with support for headers, custom delimiters, and pretty print.
Open tool
JSON Formatter
Format and validate JSON instantly.
Open tool
Diff Checker
Compare two texts and highlight the differences line by line.
Open tool
URL Encoder & Decoder
Encode or decode URLs instantly.
Open tool
Remove Extra Spaces
Remove extra spaces from text instantly.
Open tool
Markdown Previewer
Preview markdown and render it instantly.
Open tool