Convert CSV to JSON
Convert CSV or spreadsheet data into clean JSON.
CSV to JSON Converter
Developer tool running locally in browser
What does CSV to JSON Converter do?
Turn CSV into a JSON array of objects, with a parser that correctly handles quoted fields, commas and line breaks inside cells, and mixed line endings. Types can be inferred so numbers and booleans do not arrive as strings.
How to Use CSV to JSON Converter
- 1Paste your CSVOr upload a .csv file.
- 2Confirm the delimiterIt is detected automatically but can be overridden.
- 3Choose type inferenceOn for real types, off to keep everything as strings.
- 4Copy the JSONOr download it as a file.
Key Features
- RFC 4180 compliant parsing of quotes, escaped quotes and embedded newlines
- Auto-detects comma, semicolon, tab and pipe delimiters
- Type inference for numbers, booleans and null
- Dotted headers expanded into nested objects
- Header row optional — falls back to numbered keys
- Reports the row and column of any malformed line
Frequently Asked Questions
How are commas inside fields handled?
Correctly, as long as the field is quoted. "Smith, Ada",42 parses as two fields, not three. Doubled quotes inside a quoted field are treated as an escaped quote character.
Should I turn on type inference?
Turn it on when the data is genuinely numeric or boolean. Turn it off for identifiers — a postcode, phone number or ID with leading zeros loses those zeros if converted to a number.
Can I create nested JSON?
Yes. Headers such as user.name and user.email are expanded into a nested user object, which is the inverse of what the JSON to CSV tool produces.
What about semicolon-delimited files from Excel?
Detected automatically. European locales use the semicolon because the comma is the decimal separator, and this parser handles both.
Input is processed in your browser and never transmitted. That said, treat any web page as untrusted for live production secrets — rotate anything you paste anywhere.
Related Tools
JSON to CSV Converter
Turn a JSON array into a spreadsheet-ready CSV.
JSON Formatter
Format, validate and explore JSON with precise error reporting.
YAML to JSON Converter
Convert YAML configuration into JSON.
JSON Validator
Check whether JSON is valid and get the exact error position.