JSON ↔ CSV Converter
Convert JSON arrays to CSV — or CSV back to JSON. Choose delimiter, view row count, and download the result.
JSON Input
CSV Output · 3 rows
id,name,email,age 1,Alice,[email protected],30 2,Bob,[email protected],25 3,Charlie,[email protected],35
About this tool
A bidirectional JSON and CSV converter. Paste a JSON array of objects to get a properly formatted CSV with quoted fields, or paste CSV data to get a JSON array. Choose between comma, semicolon, tab, and pipe delimiters. Download the output as a file or copy it to clipboard.
How to use it
Quick steps to get the most out of this utility.
- 1
Choose a direction
JSON → CSV or CSV → JSON.
- 2
Pick a delimiter
Comma for standard CSV, semicolon for European locales, tab for TSV.
- 3
Paste your data
The conversion happens instantly as you type.
- 4
Download or copy
Use the Download button for a file, or Copy to paste into another app.
When to convert between JSON and CSV
- API to spreadsheet: convert a REST API JSON response to CSV for Excel or Google Sheets analysis
- Data import: convert a CSV export from a database or BI tool into JSON for use in a web app
- Report generation: flatten a JSON array into rows for a business report
- Seed data: prepare fixture data as CSV and convert to JSON for a test database
Frequently asked questions
What kind of JSON can be converted to CSV?+
The converter expects a JSON array of objects where each object has the same keys (columns). Nested objects are serialized as JSON strings in the CSV cell. A plain JSON object (not an array) is also supported and will produce a single-row CSV.
Can I change the delimiter?+
Yes. Choose from comma (,), semicolon (;), tab (\t), or pipe (|). Semicolons are common in European locales where commas are used as decimal separators. Tabs produce TSV (tab-separated values) files.
What happens if CSV values contain commas?+
The converter wraps fields in double quotes automatically when they contain the delimiter, double quotes, or newlines. Double quotes within a value are escaped as two double quotes — following the CSV RFC 4180 standard.
Can I open the CSV in Excel?+
Yes. Download the CSV file and open it in Excel, Google Sheets, or any spreadsheet app. For European locales, use the semicolon delimiter to avoid comma/decimal conflicts.
What does the CSV → JSON conversion produce?+
CSV to JSON produces an array of objects where each header column becomes a key and each row becomes one object. All values are strings — type casting (numbers, booleans) is not applied since CSV has no type information.
Keep exploring
More utilities and reading from Toolisk.