CSV to JSON converter
Spreadsheet exports and legacy data feeds arrive as CSV. Convert to JSON arrays for REST APIs, MongoDB imports, or JavaScript apps — first row becomes property names, subsequent rows become objects. Parsed entirely in your browser.
Input
Output
[
{
"name": "Ada",
"age": "36"
},
{
"name": "Alan",
"age": "41"
}
]
How to convert CSV to JSON
1. Paste CSV or upload .csv file.
2. Confirm delimiter (comma, semicolon, tab).
3. Preview JSON output array.
4. Copy or download .json.
CSV to JSON examples
Product catalog import
sku,name,price header with 500 rows becomes JSON for storefront seed script.
Survey results
Google Forms CSV export converted to JSON for D3 visualization.
Semicolon EU CSV
European Excel uses ; delimiter — set option before parse.
When CSV to JSON
• When bootstrapping API mocks from spreadsheet data.
• When converting exports for NoSQL insertMany.
• When developers need JSON from business-user CSV edits.
When parser struggles
• When fields contain unescaped commas and broken quoting — fix CSV first.
• When file has multiple sheets — export one sheet at a time.
• When types must be numbers not strings — cast after conversion in code.
Type coercion
CSV is untyped — "0123" and "true" stay strings in JSON unless you post-process. APIs expecting numbers need explicit parsing.
Delimiter detection
Semicolon CSV from German Excel pasted into comma parser merges columns — confirm separator.
UTF-8 characters
Names with accents must stay UTF-8 end-to-end — avoid saving through Latin-1 intermediaries.
Frequently asked questions
Header row required?
Yes for object keys — otherwise columns become col1, col2.
Quoted fields with commas?
RFC 4180 quotes handled — malformed rows may error.
Empty cells?
Usually empty string or null depending on tool — verify for your API.
Large CSV?
Browser memory limits apply — split huge files.
Local?
Yes.
JSON back to CSV?
Use jsonToCsv.