Home › Toolkit › Developer › CSV to JSON

📥 CSV to JSON

You have the spreadsheet; the code wants JSON. Paste CSV here and get a proper array of objects back, parsed by a real CSV reader that understands quotes, commas inside fields and multi-line cells.

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

  1. Paste your CSV.
  2. Tick the no-header box if your file starts directly with data.
  3. 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

Making videos too? Try our YouTube SEO Checker, or browse the full Toolkit and the free YouTube tools.