Knowledge Mark G
Hire Me

Free developer tool

CSV to JSON Converter

Convert CSV to JSON, or JSON back to CSV - quoted fields, any delimiter and number detection handled properly.

  • No sign-up
  • Instant results
  • Runs in your browser

CSV input

Delimiter (found: Comma)

4 rows × 9 columns - detected types

idintegernametextemailtextcitytextziptextplantextmonthly_spenddecimalactivebooleansigned_update
1Smith, Jane[email protected]Boston02134Pro49.00true2026-01-05
2Oliver O'Neil[email protected]London-Starter9.99true2026-02-11
3Lukas Becker[email protected]Berlin10115Team199.00false2026-03-02
4Emma "Em" Ross[email protected]Austin78701Pro49.00true2026-04-19

Output

1 KB
data.json
[
  {
    "id": 1,
    "name": "Smith, Jane",
    "email": "[email protected]",
    "city": "Boston",
    "zip": "02134",
    "plan": "Pro",
    "monthly_spend": 49,
    "active": true,
    "signed_up": "2026-01-05"
  },
  {
    "id": 2,
    "name": "Oliver O'Neil",
    "email": "[email protected]",
    "city": "London",
    "zip": "",
    "plan": "Starter",
    "monthly_spend": 9.99,
    "active": true,
    "signed_up": "2026-02-11"
  },
  {
    "id": 3,
    "name": "Lukas Becker",
    "email": "[email protected]",
    "city": "Berlin",
    "zip": "10115",
    "plan": "Team",
    "monthly_spend": 199,
    "active": false,
    "signed_up": "2026-03-02"
  },
  {
    "id": 4,
    "name": "Emma \"Em\" Ross",
    "email": "[email protected]",
    "city": "Austin",
    "zip": "78701",
    "plan": "Pro",
    "monthly_spend": 49,
    "active": true,
    "signed_up": "2026-04-19"
  }
]

CSV parsed properly

Splitting a line on commas breaks the moment a field contains one - an address, a company name, a sentence. This converter follows the CSV standard (RFC 4180): fields in double quotes can hold commas, line breaks and escaped quotes (""), and Windows and Unix line endings both work. Semicolon, tab and pipe delimiters are detected automatically, which matters for CSV exported by European versions of Excel.

Numbers, booleans - and leading zeros

With type detection on, columns that contain only numbers become JSON numbers and true/false columns become booleans. Values with a leading zero - ZIP codes like 02134, phone numbers, product codes - stay as text, because turning them into numbers silently drops the zero. The preview shows the type detected for every column before you convert.

Which JSON shape?

Array of objects uses the header row as keys and is what most APIs and JavaScript code expect. Array of arrays keeps it compact, header first. NDJSON puts one object per line, for streaming tools, BigQuery and log pipelines. There is also a Markdown table option for documentation.

JSON back to CSV

Switch the direction to turn a JSON array into CSV for Excel or Google Sheets. Every key found in any object becomes a column. Need SQL instead? The CSV to SQL converter writes CREATE TABLE and INSERT statements, and the JSON formatter validates the output.

Questions people ask

How do I convert CSV to JSON?+

Paste the CSV or open the file, keep 'First row is the header' on, and choose 'Array of objects'. Each row becomes an object keyed by the column names.

Why are my ZIP codes still strings?+

Deliberately. A value like 02134 would lose its leading zero as a number. Columns where every value is a plain number without a leading zero are converted.

My CSV uses semicolons - will it work?+

Yes. The delimiter is detected from the first line, and you can force comma, semicolon, tab or pipe.

Is there a file size limit?+

Files up to 25 MB convert comfortably in a browser tab. The conversion happens on your device, so very large files depend on your computer's memory.

Can it convert JSON to CSV?+

Yes - switch the direction at the top. Nested objects and arrays are written into their cell as JSON text.

Is my data uploaded?+

No. Parsing and conversion run in your browser; nothing is sent to us.