CSV to JSON converts comma-separated values into a JSON array of objects. The first row is used as headers (keys), and each subsequent row becomes an object in the array.
This tool handles RFC 4180 compliant CSV, including quoted fields with embedded commas, newlines, and escaped double-quotes. It also auto-detects numbers, booleans, and null values so your JSON output has proper types instead of all strings.
Everything runs in your browser — your CSV data is never uploaded to any server. Ideal for converting spreadsheet exports, database dumps, or log files into JSON for use in APIs, config files, or data pipelines.
name,age,city
Alice,30,New York
Bob,25,London
// Converts to:
[
{ "name": "Alice", "age": 30, "city": "New York" },
{ "name": "Bob", "age": 25, "city": "London" }
]Numbers are auto-detected when the "Auto-detect types" option is enabled.
name,description,price
"Widget, Large","A big widget",19.99
"Gadget ""Pro""","The best gadget",29.99
// Quoted fields can contain commas and escaped quotesDouble-quotes inside quoted fields are escaped as "" per RFC 4180.
| Gotcha | Why it happens | What to do |
|---|---|---|
| Rows with the wrong number of fields | The header defines the field count. Short rows have no value to map, and fields past the header have no key to map to. | Missing values become empty strings and extra fields are dropped. Normalise column counts first if that matters. |
| Non-UTF-8 exports | Excel's plain "CSV" export uses a locale-specific encoding, so accented and non-Latin characters arrive as mojibake. | Re-export as "CSV UTF-8" rather than "CSV". |
| Whitespace is preserved in values | Header names are trimmed automatically, but cell values are kept exactly as written, since leading spaces are sometimes meaningful. | Trim the source CSV or post-process the JSON if you need clean values. |
The Data Conversion Tools covers the whole topic. CSV to JSON Converter goes one level deeper for users whose query already names this exact workflow.
Pick this page when the input shape, language, or step you are debugging is the question. Pick the hub when you want to compare adjacent tools side by side.
Paste your CSV data into the input panel and click "Convert to JSON". The first row becomes the object keys, and each row after that becomes a JSON object in the output array.
Yes. The parser follows RFC 4180: fields in double quotes can contain commas, newlines, and escaped quotes (""). This means complex spreadsheet data converts correctly.
Yes. Use the delimiter dropdown to select comma, semicolon, or tab. European CSV files often use semicolons — just switch the delimiter and convert.
Yes. All processing happens in your browser. No data is sent to any server. You can verify this by disconnecting from the internet and using the tool offline.
When enabled, the tool converts values that look like numbers (e.g., 42, 3.14), booleans (true/false), and null to their JSON equivalents instead of leaving them as strings.
Move between CSV, JSON, XML, YAML, SQL, tables, and developer-friendly formats with converter pages grouped by workflow.
Need more context before using the tool? Start with one of these workflow guides.