CSV to JSON converter
About CSV to JSON
The CSV to JSON converter parses CSV into a JSON array of objects. It reads field names from the header row and can infer types, so numbers and booleans come out as real JSON values instead of strings.
Use it to turn a spreadsheet export or a database dump into JSON for an API, your code or test fixtures. Runs in your browser. Nothing is uploaded.
How it works
Header detection
With First row is header on, row one supplies the keys and every other row becomes an object. Turn it off and each row becomes an array of values, which suits headerless data.
Type inference
With Infer types on, numeric text becomes a JSON number, true and false become booleans, and empty cells become null. So 42 is a number, not "42". Turn it off to keep every value as a string, which protects leading zeros and ID codes.
Delimiters and quoted values
The parser detects the delimiter, so commas, semicolons, tabs and pipes all work. Fields wrapped in double quotes may contain the delimiter, newlines and escaped quotes. A value like "Smith, Jane" stays one field.
Blank lines and errors
Empty lines are skipped, so a trailing newline does not create an empty object. If a row cannot be parsed, the error names the row.
Frequently asked questions
Does the first CSV row have to be a header?
Only if you want named fields. With header detection on, row one supplies the keys. With it off, each row becomes an array of values.
Why did my ZIP code lose its leading zero?
Type inference turned it into a number. Turn inference off to keep every value as a string, so codes and IDs with leading zeros stay as written.
Can it handle commas inside a field?
Yes, if the field is wrapped in double quotes as the CSV standard requires. The commas and newlines inside it are kept.
Is my CSV uploaded anywhere?
No. Parsing runs in your browser.
What delimiter does it expect?
Any common one. The parser detects commas, semicolons, tabs and pipes from the data, so you do not need to convert the file first.
Sources & last verified
We checked this tool's behavior and the claims on this page against the specifications below on . The tool runs in your browser, so the output you see is exactly what the engine produced.
Found a wrong result or an outdated claim? Report an error and we will check it again.
JSON ⇄ YAML
YAML to JSON
JSON ⇄ XML
XML to JSON
JSON to TypeScript
Base64 Encode / Decode