Practical example
Convert [{"id":1,"tags":["a","b"]}] and decide explicitly whether tags should become JSON text, multiple columns, or multiple rows.
JSON ↔ CSV Converter
Convert JSON arrays/objects to CSV or CSV back to JSON with delimiter selection and nested object flattening.
Options
Actions
What is a JSON ↔ CSV converter?
A JSON ↔ CSV converter helps you transform structured JSON data into CSV tables and convert CSV files back into JSON.
It is useful for APIs, spreadsheets, imports, exports, analytics, and moving data between code and tabular tools.
How to use the JSON ↔ CSV Converter
- Paste JSON or CSV into the input field.
- Choose the delimiter such as comma, semicolon, or tab.
- Click JSON → CSV or CSV → JSON.
- Use Auto detect if you want the tool to guess the format.
Tips
- Nested JSON objects are flattened using dot notation.
- Arrays are stored as JSON strings inside cells.
- CSV headers can be included or interpreted from the first row.
- Conversion is local — even large exports with sensitive columns never leave your machine.
Related guides
Learn the workflow behind this tool and what to check next.
JSON and CSV conversion checks before moving tabular data
JSON and CSV represent structure differently, so nested objects, arrays, delimiters, headers, and data types need review before import.
Flatten structure deliberately
Decide how nested objects and arrays should become columns before sending CSV to spreadsheets, databases, or reporting tools.
Confirm headers and delimiter
Check column names, delimiter choice, quoting, and empty cells so the exported file opens correctly in the target app.
Protect data types
Review IDs, dates, booleans, decimals, and large numbers before spreadsheet software coerces them.
Validate round trips
Convert representative rows back to JSON and compare field names, missing values, and nested data before migration.
A practical example, an edge case, and a maintainer note
Edge case
CSV cells beginning with =, +, -, or @ can be interpreted as formulas by spreadsheet software and require sanitization before export.
Maintainer note
I define column order, null handling, delimiter, and newline rules before conversion so a later import reproduces the same data.
Related tools
You may also find these tools useful.
JSON Formatter
Format and minify JSON instantly.
Data & Format
›
JSON ↔ YAML Converter
Convert JSON to YAML and YAML to JSON instantly.
Data & Format
›
CSV Viewer / CSV to Table
View CSV as a table and convert it to JSON.
CSV & Data
›
CSV Column Extractor
Extract a single column from CSV by name or index.
CSV & Data
›
JSON ↔ CSV Converter FAQ
Does my JSON or CSV get uploaded anywhere?
No. Conversion in both directions runs in your browser, so exports with real records can be transformed safely.
Can it flatten nested JSON?
Yes. Nested objects are flattened using dot-separated keys.
Can I use semicolon or tab instead of comma?
Yes. You can choose comma, semicolon, or tab as the delimiter.