1
Choose a direction
Pick CSV to JSON or JSON to CSV, then paste your data or load a file.
Developer Tools
JSON ↔ CSV Converter
Convert JSON to CSV and CSV to JSON with proper quoting, delimiters, and clear errors.
Convert between JSON and CSV with proper handling of quotes, commas and line breaks, entirely in your browser. Need to tidy or validate the JSON first? Use the JSON Formatter.
Your data never leaves your device. Conversion happens entirely in your browser.
0 characters
How it works
Private JSON and CSV conversion in your browser
2
Set options
Choose the delimiter, whether the first row is a header, and how nested values are handled.
3
Copy or download
Review any warnings, then copy the result or download it with the filename you choose.
Use cases
When this comes in handy
Open API data in a spreadsheet
Turn a JSON array of records into a CSV you can open in Excel or Google Sheets.
Import a spreadsheet into code
Convert an exported CSV into JSON for a script, a test fixture or an API request.
Switch delimiters
Read a semicolon or tab-separated file and produce a standard comma-separated one.
FAQ
Common questions
Is my data uploaded anywhere?
No. Conversion runs entirely in your browser.
Does it handle commas, quotes and line breaks inside values?
Yes. Values containing the delimiter, double quotes or line breaks are quoted correctly when writing CSV, and quoted fields (including doubled quotes and embedded line breaks) are read correctly when parsing it.
What happens to nested JSON objects and arrays?
A flat CSV cannot hold them, so by default the converter stops and tells you where the nested value is. You can instead choose to write nested values as JSON text inside the cell, which keeps the data intact.
Are CSV values converted to numbers?
Only if you turn on type detection, and then only for values that print back exactly as written. Leading zeros, trailing decimals and very large numbers stay as text so nothing changes silently.
What can be lost in conversion?
JSON null becomes an empty CSV cell, since CSV has no null. JSON integers beyond 9,007,199,254,740,991 cannot be represented exactly by browsers, and the tool warns you. CSV rows longer than the header are rejected rather than truncated. Spreadsheet programs may treat cells beginning with = + - or @ as formulas, so review untrusted data before opening it.
Related Tools