Skip to main content
FileForge

CSV to JSON Converter

Turn CSV data — pasted or from a file — into a JSON array of objects, using the header row as keys. Quoted fields and embedded commas are handled correctly.

Runs in your browser — files never leave your device

Free · No sign-upOutputs JSON
Loading tool…

How to use CSV to JSON

  1. Paste CSV or choose a .csv file.

  2. Set the delimiter if it isn't a comma (semicolon and tab are common in exports).

  3. Click Convert to JSON.

  4. Copy the result or download it as a file.

About this tool

Naive CSV converters break on the first quoted field containing a comma. This one uses a proper CSV parser: quoted fields, escaped quotes (""), embedded commas and line breaks inside values all parse per the CSV standard. The first row becomes the object keys; you can choose comma, semicolon or tab as the delimiter, and optionally convert numeric-looking values to real JSON numbers. Output can be copied or downloaded as a .json file.

This bridges the common gap between spreadsheet-based data — exported from Excel, Google Sheets, or a database tool — and the JSON format that APIs, scripts and web applications actually expect to consume.

Common ways people use this

  • Converting a spreadsheet export into JSON to feed into a script or API
  • Turning a CSV data dump into a JSON array for use in a web application prototype
  • Preparing test or seed data for a database from a spreadsheet

Tips for better results

  • Turn on "detect numbers" only if you're sure no column has meaningful leading zeros (like ZIP codes) — otherwise those values will lose their leading digits.
  • If your export was made in a European locale, try the semicolon delimiter — many regional spreadsheet settings export CSV with semicolons instead of commas.

Frequently asked questions

My values contain commas — will they break the conversion?
Not if they're quoted, which is how spreadsheets export them. The parser follows the CSV standard, so "Smith, Jane" stays one value.
Why are my numbers coming out as strings?
CSV has no types — everything is text. Enable "detect numbers" to convert numeric-looking values into JSON numbers; leave it off to preserve things like ZIP codes with leading zeros.
My export uses semicolons, not commas. Will it work?
Yes — select the semicolon delimiter. Spreadsheets in many European locales export semicolon-separated files.
What happens if a row has fewer columns than the header?
Missing cells are filled in as empty strings in the resulting JSON object, so the output stays consistent across all rows.
Can I load the CSV directly from a file instead of pasting it?
Yes, use the "Load from file" option to select a .csv or .tsv file from your computer directly.

Related tools

Other tools people commonly use alongside this one.

JSON to CSV

Convert a JSON array of objects into CSV that opens cleanly in Excel or Google Sheets, with correct quoting and a stable column order.

Developer

JSON Formatter

Paste minified or messy JSON and get a cleanly indented, readable version. Invalid JSON produces an error with the line and position of the problem.

Developer

JSON Validator

Check whether a JSON document is valid. Errors are reported with line and column, plus a plain-English explanation of the likely cause.

Developer