CSV to JSON Converter - Convert CSV Files Online, Free

2on /
/ Converters / CSV to JSON

CSV to JSON converter

or

How the CSV to JSON conversion works

CSV is a table; JSON is a structure. This tool reads the table properly - including quoted fields and the awkward cases inside them - and writes it out as JSON you can drop straight into code.

Three steps

  1. 1 Drop a CSV file onto the box, or paste the text straight from a spreadsheet.
  2. 2 Leave the delimiter on automatic, or pick one yourself. Choose whether the first row is a header and whether numbers should become real numbers.
  3. 3 Press Convert, then copy the JSON or download it as a .json file.

Quoted fields are where most converters break

Splitting a line on every comma looks right until a value contains one. "New York, NY" is a single field, not two; a doubled quote ("") means one literal quote character; and a quoted field may even contain a line break. This converter follows the CSV rules for all three, so columns stay where they belong instead of quietly shifting.

An example, side by side

Notice what happens to the tricky parts: the doubled quotes become one quote inside the string, the comma inside "New York, NY" stays part of the value, and the empty trailing cell becomes null rather than an empty string.

CSV
name,city,note
Ada,London,"Loves ""tea"""
Grace,"New York, NY",
JSON
[
  {
    "name": "Ada",
    "city": "London",
    "note": "Loves \"tea\""
  },
  {
    "name": "Grace",
    "city": "New York, NY",
    "note": null
  }
]

Commas, semicolons and tabs

A file called CSV is not always comma separated. Spreadsheets in many locales save with semicolons, and exports from databases often use tabs. Automatic detection tries each candidate and keeps the one that gives a consistent column count across rows - a better test than simply counting characters, because a text column full of commas can easily outnumber the real delimiter.

Your file stays on your computer

Reading and parsing both happen in the browser, so nothing is uploaded and nothing is stored. That matters here more than in most tools: a CSV is usually a customer list, an order export or a payroll sheet. You can disconnect from the network and the converter keeps working.

CSV to JSON: common questions

Drop the file onto the box above or paste the text, then press Convert. The result appears below, ready to copy or download as a .json file. No sign-up and no upload.
New
Currency Converter Convert 165 currencies with official central bank rates. Both amount fields are editable, and each pair shows the publication date of its rate.
Popular Today
HEIC to JPG Convert iPhone HEIC photos to JPG for free: the format Windows, Android and most upload forms accept - no app, no account, no watermark.

Related Converters

Word to PDF Convert Word to PDF for free: upload a DOC, DOCX, ODT or RTF file and download a properly formatted PDF in seconds - no registration or watermark.
PDF to Word Convert PDF to Word for free: upload a PDF and download an editable DOCX in seconds - no registration, no watermark and nothing to install.
Image Converter Free image converter: pick PNG, JPG, WebP, GIF or BMP and convert any picture in your browser - your photos are never uploaded to a server.
WebP to PNG Convert WebP to PNG for free: transparency is preserved and the image never leaves your device - the whole conversion runs in your browser.
PNG to JPG Convert PNG to JPG for free: pick the quality and a background colour for transparent areas, all in your browser with no upload.

Other Tools You May Like

MD5 Hash Generator Free MD5 hash generator: turn any text or file into an MD5 checksum in your browser - useful for integrity checks and quick fingerprinting.
Base64 Encoder & Decoder Free Base64 encoder and decoder: convert text or files to Base64 and back, entirely in your browser - nothing is uploaded to a server.
Word Counter Free word counter: paste any text to count words, characters, sentences and paragraphs, and see the estimated reading time - nothing leaves your browser.
Character Counter Free character counter: count characters with and without spaces, plus words and lines, and check SEO limits for titles and meta descriptions.
Keyword Density Checker Free keyword density checker: paste text or a URL to see how often each word and phrase appears, with percentages for one, two and three-word terms.