CSV to JSON Converter

Convert CSV to JSON online. Paste comma-separated data and get clean JSON instantly — handles quoted fields, custom delimiters, and automatic type detection, all in your browser.

Input CSV
Drop CSV file here
JSON Output

Features

📄 Handles Real-World CSV

  • Quoted fields with embedded commas and quotes
  • Multi-line values inside quoted cells
  • Custom delimiters: comma, semicolon, tab, pipe
  • Optional automatic number/boolean detection

⚡ Privacy-First

  • All parsing happens in your browser
  • No data ever sent to a server
  • Works with spreadsheet exports (Excel, Sheets)
  • Download or copy the resulting JSON instantly

🔄 Round-Trip Friendly

  • Pairs with our JSON to CSV converter
  • Header row becomes object keys automatically
  • Toggle header mode off for raw row arrays
  • Great for importing spreadsheet data into APIs

CSV to JSON Guide

CSV (Comma-Separated Values) is the most common export format from spreadsheets, databases, and analytics tools. Converting it to JSON is one of the most frequent tasks developers do when importing spreadsheet data into an API, database, or JavaScript application. This tool reads the first row as field names by default and turns every remaining row into a JSON object, but you can also disable the header option to get a plain array of arrays for irregular data.

Frequently Asked Questions

Does it handle commas inside quoted fields?

Yes. Fields wrapped in double quotes can contain commas, newlines, and escaped quotes (written as "") and are parsed correctly per the common CSV convention (RFC 4180).

What happens to numbers and booleans?

With "Infer types" enabled, values that look like integers, decimals, true/false, or null are converted to their JSON equivalents. Disable it to keep every value as a plain string, useful for IDs like "007" that shouldn't become numbers.

Can I use a delimiter other than a comma?

Yes — choose semicolon, tab, or pipe from the delimiter dropdown for TSV files or European-style CSV exports that use semicolons.

Preparing CSV for a clean JSON conversion

CSV looks simple, but files exported from spreadsheets, databases and CRMs vary a lot. A quick check of the header row, delimiter and encoding before converting avoids most problems with the resulting JSON.

Tips and common pitfalls

  • Make sure the first row holds unique, non-empty column names; they become the JSON keys.
  • European exports often use a semicolon delimiter because the comma is the decimal separator.
  • Save files as UTF-8. A byte order mark at the start of the file can end up glued to the first column name.
  • IDs with leading zeros, such as postal codes, should stay strings. Check that type detection has not turned them into numbers.

More questions

How are empty cells handled?

An empty cell produces an empty value for that key. Decide in your code whether empty means missing, null or an empty string, since CSV cannot tell them apart.

Can I create nested JSON from CSV?

Name columns with dots, such as address.city, then run the result through our JSON Unflatten tool to rebuild nested objects.