CSV ↔ JSON Converter

Convert CSV to JSON and back. Auto-detects delimiters, handles quoted fields and multi-line cells. Numbers and booleans are auto-typed (toggleable).

Convert CSV to JSON or JSON to CSV in either direction, with automatic delimiter detection. Perfect for moving data between spreadsheets, APIs and code — all converted locally, nothing uploaded.

How to convert CSV to JSON

Paste CSV data with a header row, then choose CSV → JSON. The converter detects comma, semicolon, and tab delimiters and handles quoted fields, commas inside values, and multiline cells.

To convert in the other direction, paste a JSON array of objects or arrays and choose JSON → CSV. Conversion happens in your browser, so the data is not sent to a server.

Full guide: How to convert CSV to JSON without corrupting your data

Delimiters (, ; tab) auto-detected; conversion runs entirely in your browser.

Input

Output

Example

Input (note the quoted comma and the leading-zero code):

id,name,pin
1,"Sharma, Priya",007423

Output with First row = headers and Auto-type on:

[
  {
    "id": 1,
    "name": "Sharma, Priya",
    "pin": "007423"
  }
]

1 becomes a number, the quoted comma stays inside the name, and 007423 stays text so its leading zeros survive. See the CSV guide for the edge cases.

How to use the CSV to JSON Converter

Paste your CSV or JSON data.
Pick the conversion direction.
Copy the result, ready for your spreadsheet, API or codebase.

Frequently asked questions

How do I convert CSV to JSON?

Paste CSV text and click Convert to JSON. The tool auto-detects commas, semicolons and tabs.

How do I convert JSON to CSV?

Paste a JSON array of objects and click Convert to CSV to get a header row plus data rows.

What if my CSV uses semicolons?

Delimiters are detected automatically, so semicolon-separated and tab-separated files convert cleanly.

Can it handle nested JSON?

Flat arrays of objects convert perfectly. Deeply nested structures are flattened to dot notation where possible.

Fun facts about CSV to JSON Converter

CSV (Comma-Separated Values) has no formal specification — RFC 4180 is the closest thing, but many implementations don't follow it exactly.
RFC 4180, the closest thing CSV has to a standard, was only published in 2005, long after the format was in everyday use.
JSON was originally designed as a lightweight alternative to XML for transmitting data between a server and a web application.
The biggest challenge in CSV parsing is handling quoted fields that contain the delimiter character — which is why a simple split-on-comma approach often fails.
Excel's CSV export has a well-known quirk: it uses the system's locale to choose the delimiter, which can cause files to break when opened on a computer with different regional settings.

📊 CSV ↔ JSON Converter