CSV to JSON Converter
Convert CSV data to a JSON array — handles headers, quoted fields, and custom delimiters.
When would you need CSV to JSON?
CSV is the universal export format for spreadsheets (Excel, Google Sheets, Numbers) and database tools. JSON is the standard data format for web APIs and JavaScript applications. Converting between them is a frequent task when importing spreadsheet data into a web app, migrating database exports, or feeding data into an API that expects JSON.
Frequently asked questions
How does it handle fields with commas inside them?
The converter follows RFC 4180 — any field that contains the delimiter, a double quote, or a newline must be enclosed in double quotes. To include a literal double quote inside a quoted field, it must be escaped as two consecutive double quotes ("").
What if my CSV uses semicolons (European format)?
European locales (e.g., French, German, Spanish) often export CSV with semicolons because the comma is used as the decimal separator. Switch the Delimiter option to “Semicolon” and the parser will split on ; instead.
What happens when I disable “First row is headers”?
Without headers, the output is a JSON array of arrays — each row becomes an inner array of its cell values. With headers enabled, each row becomes a JSON object keyed by the header names from the first row.
