JSON to CSV Converter
Convert JSON data to CSV format and vice versa.
About this tool
Transform JSON arrays into CSV spreadsheet format or convert CSV files back to JSON. Handle nested objects, customize delimiters, and download results. Perfect for data migration and analysis.
Variants
Features
- Convert JSON arrays to CSV spreadsheet format
- Convert CSV data back to JSON format
- Handle nested objects and complex data structures
- Download converted data as a file
How to Use
- Paste your JSON or CSV data into the input field
- Select the conversion direction (JSON to CSV or CSV to JSON)
- View the converted output instantly
- Copy or download the result
Frequently Asked Questions
How does the converter handle nested JSON?
Flattened by default using dot notation: {"user": {"name": "Ada"}} becomes a column "user.name". Arrays of scalars are joined by semicolons ("a;b;c"), arrays of objects become repeated rows. If your data is deeply nested, preprocess it before converting — CSV is fundamentally flat.
Why does Excel mangle my CSV?
Usually because Excel interprets comma-separated cells per your locale — in European locales, Excel expects semicolons as the delimiter. Either export with semicolons, prepend the file with sep=,\n (Excel respects this hint), or use Excel's "Data > From Text" workflow rather than double-clicking.
How do I handle commas inside values?
They get wrapped in double quotes: "Paris, France". The tool does this automatically per RFC 4180. If you're hand-writing a CSV, remember that embedded quotes get doubled ("She said ""hi"""), not escaped with a backslash.
Is my data sent anywhere during conversion?
No — everything runs in your browser. That matters for customer exports, financial data, and anything with PII where sending the file to a random online converter would be a compliance issue. Paste, convert, download, move on.
Should I use JSON or CSV for bulk data exchange?
JSON for structured data, nested objects, or anything that'll be read by code. CSV for flat, column-oriented data that'll be opened in a spreadsheet or loaded into a relational database. CSV is smaller on the wire; JSON is more self-describing. Pick based on the consumer.