📊

JSON to CSV Converter

Convert JSON arrays to CSV format instantly. Free, private, runs in your browser.

💻 Developer Tools Free Browser-based

Tool

Delimiter

Include headers

JSON Input (array of objects)

JSON to CSV and CSV to JSON — What This Tool Does

This dual converter handles both directions of data conversion between JSON and CSV. The JSON → CSV tab takes a JSON array of objects and produces a spreadsheet-ready CSV file. The CSV → JSON tab takes any delimiter-separated data and produces a JSON array you can use in APIs, databases or JavaScript applications. Both conversions run entirely in your browser — no data is uploaded.

How to Convert JSON to CSV

Paste your JSON array into the JSON Input box. Each object in the array becomes one CSV row. The keys of the first object are used as column headers. Choose a delimiter, then click Convert to CSV. The result is ready to copy or download as a .csv file you can open directly in Excel, Google Sheets or LibreOffice Calc.

CSV Delimiters

Delimiter	Symbol	Best Used When
Comma	,	Default for most spreadsheet software worldwide
Semicolon	;	European locales where commas serve as decimal separators
Tab (TSV)	\t	Values contain commas (addresses, notes, sentences)

Common Use Cases

API data to spreadsheet — convert a REST API JSON response to CSV for analysis in Excel or Google Sheets.
Database export — transform a JSON database dump into a CSV importable by most SQL clients and BI tools.
Spreadsheet to API — convert CSV data exported from a spreadsheet into JSON to send as an API request body.
Data migration — move data between systems that accept different formats without writing any code.
Reporting — produce CSV files from structured JSON logs for sharing with non-technical stakeholders.

Handling Nested JSON in CSV Exports

CSV is a flat, two-dimensional format — it cannot represent nested objects or arrays directly. When your JSON contains nested objects (e.g. {"user": {"name": "Alice", "age": 30}}), the converter flattens one level using dot notation so the CSV header becomes user.name and user.age. Arrays inside objects are serialised as a JSON string in the CSV cell. If your data is deeply nested, consider restructuring the JSON to a flat array of objects before converting, or use the JSON Formatter to inspect and reshape the structure first.

'Can it handle nested JSON objects?', 'a' => 'Yes. Nested objects and arrays are serialised as JSON strings inside the CSV cell and wrapped in quotes. For deeply nested data, flatten the JSON first using a tool like jq before converting.'], ['q' => 'How do I download the CSV file?', 'a' => 'After clicking Convert to CSV, click the Download CSV button. The file saves as data.csv and can be opened directly in Excel, Google Sheets or LibreOffice Calc.'], ['q' => 'What is the difference between CSV and TSV?', 'a' => 'CSV uses a comma as the column separator; TSV uses a tab character. Choose TSV when your data values contain commas — such as addresses, notes or sentences — to avoid parsing errors.'], ['q' => 'How does the CSV to JSON conversion handle data types?', 'a' => 'CSV has no type information, so all values start as strings. The converter automatically casts "true" and "false" to booleans and numeric strings to numbers. Everything else remains a string.'], ['q' => 'Is my data uploaded to a server?', 'a' => 'No. Both JSON to CSV and CSV to JSON conversions run entirely in your browser using JavaScript. Your data never leaves your device — safe for customer records, API keys or any confidential data.'], ]" />