CSV to JSON Converter – Convert CSV Online with Types
Turn CSV exports from Excel, Google Sheets or databases into clean JSON. The converter detects the delimiter, handles quoted fields and converts numbers and booleans automatically.
Paste your CSV or open a file. The first row becomes the keys, and every other row becomes a JSON object. Numbers, true/false and empty values are converted to proper JSON types (you can switch this off). Choose “array of arrays” for raw rows. Copy the JSON or download it as data.json.
How to use CSV to JSON Converter
- Paste the CSV or click “Open CSV file”.
- Keep “Detect automatically” or choose the delimiter.
- Decide whether the first row is a header.
- Choose objects or arrays and the indentation.
- Copy the JSON or download data.json.
How the conversion works
The parser follows RFC 4180, the CSV standard: fields can be wrapped in double quotes, quotes inside a field are written as two quotes (""), and quoted fields may contain the delimiter or even line breaks. A byte-order mark from Excel exports is removed automatically.
| CSV | JSON |
|---|---|
| name,age | keys “name” and “age” |
| "Smith, John",41 | {"name": "Smith, John", "age": 41} |
| true / false | true / false |
| (empty) | null |
With type conversion switched off, every value stays a string — useful for postal codes or IDs with leading zeros such as 00123.
Delimiters
Commas are standard, but Excel in many European countries saves CSV with semicolons because the comma is used as a decimal separator. Tab-separated files (TSV) come from many databases and copy-paste from spreadsheets. Automatic detection looks at the first lines and picks the character that splits them most consistently; choose manually if the result looks wrong.
Objects or arrays?
An array of objects is easiest to use in JavaScript, APIs and NoSQL databases: each row becomes {"column": value}. An array of arrays keeps the exact row structure, including the header row, and is smaller. Duplicate column names get a suffix (_2, _3) so no data is lost. Rows with a different number of columns are flagged so you can fix them.
Privacy
Your data is converted in your browser and never uploaded, so customer lists and internal exports stay private. To go the other way, use JSON to CSV Converter; to check and pretty-print the result, use the JSON Formatter.
Typical uses
Developers convert spreadsheet exports into JSON to seed databases, build test fixtures or feed charts and front-end prototypes. Marketers turn product lists into JSON for website widgets, and analysts reshape survey exports before loading them into scripts. The converter handles files with thousands of rows directly in the browser, so you can check the result before importing it anywhere.
You may also find these free tools useful: JSON Formatter, Password Generator and Regex Tester.
Frequently asked questions
How do I convert CSV to JSON?
Paste the CSV or open the file; the JSON appears instantly. Copy it or download data.json.
Does it handle commas inside quotes?
Yes. Quoted fields can contain commas, semicolons, quotes ("") and line breaks.
Why are my numbers strings?
Type conversion is switched off. Turn on “Convert numbers, true/false and empty values”.
Can I convert semicolon-separated files?
Yes. Automatic detection finds semicolons and tabs, or choose the delimiter yourself.
Is my data uploaded?
No. The conversion runs entirely in your browser.
Last updated: