CSV to JSON Converter
Convert CSV to JSON and back, with custom delimiter.
[
{
"name": "Alice",
"age": "30",
"city": "Paris"
},
{
"name": "Bob",
"age": "28",
"city": "Madrid"
},
{
"name": "Charlie",
"age": "35",
"city": "Berlin"
}
]Drop CSV in the input and we'll emit JSON; flip the tab to go from JSON back to CSV. Pick the delimiter, toggle the header row.
How to use it
Pick a direction
CSV to JSON or JSON to CSV.
Adjust delimiter and header
Default is comma + header. Use ';' for European locales or '\t' for TSV.
Paste your data
Output updates as you type. Errors appear below if parsing fails.
What is it?
A CSV-to-JSON converter parses comma-separated values - the spreadsheet export format - into a JSON array of objects keyed by the header row. The reverse takes an array of objects and emits CSV with a header. Both are essential glue when shuffling data between Excel, a database export and an API.
When to use it
Importing a spreadsheet into a no-code form that expects JSON. Producing a CSV for someone who only knows Excel. Massaging an analytics export. Doing a quick data shape check before writing a real ETL job.
Common mistakes
Hand-rolling a CSV parser with String.split(',') - it breaks on quoted commas. Forgetting that CSV doesn't have types: every value is a string when round-tripping through CSV. And exporting CSV with a comma decimal separator in a locale that uses semicolons - switch the delimiter.
FAQ
- How are quoted fields handled?
- Standard RFC 4180. A field can be wrapped in double quotes; an embedded double quote is escaped by doubling it. The parser handles newlines inside quoted fields correctly.
Rate this tool
Share your experience to help others.
Related tools
More in this category
- JSON Formatter & Validator
- Base64 Encoder / Decoder
- URL Encoder / Decoder
- Hash Generator (SHA-1, SHA-256, SHA-384, SHA-512)
- JWT Decoder
- Regex Tester
- Markdown to HTML Converter
- YAML to JSON Converter
- SQL Formatter
- HTML Entity Encoder / Decoder
- Cron Expression Reader
- XML Formatter
- HTML Minifier
- Mock Data Generator
- Markdown Table Generator