About this tool
Splitting CSV on commas is the first programming exercise everyone fails in production, because real CSV quotes its troublemakers: "Smith, John" is one field, and a quoted field may contain whole paragraphs. This converter uses a character-by-character parser written for this site that tracks quote state properly, so what your spreadsheet exported is what your JSON gets — commas, quotes and line breaks in their right places.
Values come out as strings, deliberately. CSV carries no type information: the cell 007 might be a code, not the number seven, and 2026-01-01 might be a label, not a date. Converting everything to numbers by default corrupts exactly the data you care about; keeping strings is the honest default, and your code can cast the fields it trusts. The first row becomes the keys unless you say otherwise.
How to use it
- Paste your CSV.
- Tick the no-header box if your file starts directly with data.
- Press Convert to JSON, then copy or download.
Good to know
- If columns look shifted, a field somewhere has an unescaped quote — the parser reports odd shapes rather than hiding them.
- Duplicate header names overwrite each other; rename repeated columns before converting.
- Semicolon-delimited files (common from European Excel) should be re-exported with commas, or the whole line lands in one field.
Frequently asked questions
Why are my numbers strings in the output?
Because CSV has no types. Keeping '007' as text preserves data that auto-numbering would destroy.
Does it handle quotes inside fields?
Yes — doubled quotes inside a quoted field are read as one literal quote, per the CSV standard.
Is my file uploaded?
No. Parsing runs in your browser; nothing is sent anywhere.
More Developer tools
JSON Formatter & Validator
Pretty-print messy JSON, minify it back, and get a precise error location when it will not parse.
JSON to CSV
Turn a JSON array of objects into a clean spreadsheet-ready CSV, columns and escaping handled.
XML Formatter
Indent and validate XML — sitemaps, feeds, config files — with errors pointed at the guilty tag.
JS / CSS / HTML Beautifier
Untangle minified or messy code into readable, consistently indented JavaScript, CSS or HTML.
JS / CSS Minifier
Strip comments and needless whitespace from JavaScript and CSS — smaller files, same behaviour.
Regex Tester
Test a regular expression against your text live — every match highlighted, groups shown.
Making videos too? Try our YouTube SEO Checker, or browse the full Toolkit and the free YouTube tools.