CSV to JSON Converter

Paste your CSV or upload a file to convert it to a JSON array instantly. Auto-detects comma, semicolon, and tab delimiters. All processing in your browser.

Options

CSV Input

JSON Output

What is a CSV to JSON Converter?

A CSV to JSON converter transforms tabular data from comma-separated values format into JSON (JavaScript Object Notation). JSON is the standard data format used by REST APIs, web applications, databases like MongoDB, and data pipelines. Converting CSV exports from Excel, Google Sheets, or database tools to JSON makes the data directly usable in code.

Calcon's CSV to JSON Converter automatically detects your delimiter, converts data types (numbers stay as numbers), and handles quoted fields with embedded commas or newlines — all in your browser without any server upload.

How to Convert CSV to JSON

  1. Paste your CSV into the left panel or click Upload to upload a .csv or .tsv file.
  2. The JSON output appears instantly. The delimiter is auto-detected from your data.
  3. Adjust options: toggle First row is headers, Detect types, and Pretty print.
  4. Choose output format: Array of objects (default) or Object with key for lookup tables.
  5. Click Download to save the .json file or Copy to copy to clipboard.

Example Conversion

Input CSV:

name,age,city,active
Alice,30,Mumbai,true
Bob,25,Delhi,false
Carol,35,Bangalore,true

Output JSON (with type detection):

[
  { "name": "Alice", "age": 30, "city": "Mumbai", "active": true },
  { "name": "Bob",   "age": 25, "city": "Delhi",  "active": false },
  { "name": "Carol", "age": 35, "city": "Bangalore", "active": true }
]

Frequently Asked Questions

How do I convert CSV to JSON?

Paste your CSV data into the left panel or upload a .csv file. The JSON output appears instantly in the right panel. The tool automatically detects the delimiter (comma, semicolon, or tab). Click Download to save as .json or Copy to copy to clipboard.

What CSV formats are supported?

The converter supports CSV (comma-separated), TSV (tab-separated), semicolon-separated, and pipe-separated files. The delimiter is auto-detected from the first row. Quoted fields with embedded commas or newlines are handled correctly.

How does type detection work?

When type detection is enabled, the converter automatically converts numeric strings to numbers (e.g., "30" becomes 30) and boolean strings to booleans ("true" becomes true, "false" becomes false). Everything else remains a string. You can disable this to keep all values as strings.

What is the "Object with key" output format?

Instead of an array like [{"id":1,"name":"Alice"}], this format creates an object keyed by a column you specify: {"1":{"id":1,"name":"Alice"}}. This is useful for lookup tables where you need to find a record by its ID or unique key.

Can I convert an Excel file to JSON?

First export your Excel file as CSV from Excel (File → Save As → CSV). Then paste the CSV content here or upload the .csv file to convert it to JSON. The result will be a JSON array with one object per row.

Is my data safe?

Yes. All conversion happens entirely in your browser using JavaScript. Your CSV data is never uploaded to any server. Once you close the browser tab, no trace of your data remains.

Related Text Tools

Subscribe to the Calcon newsletter

Get new calculators, tools, and practical guides delivered to your inbox. No spam — unsubscribe anytime.