Knowledge Mark G
Hire Me

100% 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 required
  • Instant results
  • Nothing is uploaded
  • Works on any device

CSV input

Delimiter (found: Comma)

4 rows × 9 columns - detected types

idintegernametextemailtextcitytextziptextplantextmonthly_spenddecimalactivebooleansigned_update
1Smith, Janejane@example.comBoston02134Pro49.00true2026-01-05
2Oliver O'Neiloliver@example.co.ukLondon-Starter9.99true2026-02-11
3Lukas Beckerlukas@example.deBerlin10115Team199.00false2026-03-02
4Emma "Em" Rossemma@example.comAustin78701Pro49.00true2026-04-19

Output

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

Private by design. Everything happens in your browser. Your files never leave your device.

  • 100% freeNo hidden charges, no watermark
  • Instant resultsDone in seconds, no queue
  • Secure & privateNothing is uploaded
  • Works on all devicesDesktop, tablet and mobile

How to use the CSV to JSON Converter

  1. 1Paste CSV or open a .csv file.
  2. 2Choose the JSON shape and type options.
  3. 3Copy or download the result.

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.

Frequently asked questions

How do I convert CSV to a JSON array?+

Paste the CSV or open the file. The first row becomes the keys and every other row becomes an object in the array, with quoted fields, commas inside quotes and numbers handled. Switch direction to turn JSON back into CSV.

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.

Worth reading

All articles →
View all →