About this tool
Parses CSV (or tab-separated) text properly — including quoted fields that contain the delimiter itself, like "Smith, John" in a comma-separated file — and converts it into a JSON array, either of objects keyed by the header row or of plain arrays.
How to use the CSV to JSON Converter
- Paste your CSV or TSV data.
- Choose the delimiter and whether the first row is a header.
- Click "Convert to JSON", then copy or download the result.
Common use cases
- Turning a spreadsheet export into JSON for a script, API mock, or test fixture
- Converting a CSV report into JSON to load into a JavaScript app or Node script
- Checking what a CSV file actually parses to before writing code against it
Worked example
With "First row is header" enabled, a row like Grace Hopper,"Computer Scientist, Rear Admiral",5 becomes {"name": "Grace Hopper", "role": "Computer Scientist, Rear Admiral", "years": "5"} — note the comma inside the quoted role field is kept as part of that one value rather than splitting it into an extra column, because the parser understands CSV quoting rather than just splitting on every comma.
Things to watch out for
Every value comes out as a string, including numbers like 5 above — CSV has no native type system, so this tool doesn't guess which fields should become numbers or booleans in your JSON. If you need typed values, convert them after import. Blank lines in the input are skipped rather than turned into empty rows.
Frequently asked questions
No — every field becomes a JSON string, exactly as it appeared in the CSV. CSV has no type information, so guessing which fields are numeric would risk getting it wrong; convert specific fields afterward if you need numbers or booleans.
Missing fields are filled in as empty strings, so every object in the result has the same set of keys as the header row.
Yes, as long as that value is wrapped in double quotes in the source CSV (the standard way), such as "123 Main St, Suite 4" — the parser treats the quoted comma as part of the value, not a new column.