CSV to JSON
Turn a spreadsheet export into JSON.
Options
Private by design. This tool runs entirely in your browser. Your input is processed on your own device and is not uploaded by DO101.
About the CSV to JSON
Converts CSV into JSON, detecting the delimiter automatically, honouring quoted fields with embedded commas and newlines, and optionally converting numbers and booleans to real types.
How to use it
- 1Paste your CSV, or export one from your spreadsheet.
- 2Confirm the header row and delimiter.
- 3Copy or download the JSON.
What you get
- Detects comma, semicolon, tab and pipe delimiters
- Handles quoted fields containing commas and newlines
- Optional number and boolean conversion
- Header row produces objects; no header produces arrays
- Runs in your browser
Frequently asked questions
How are quoted fields handled?
Properly. A field wrapped in quotes may contain commas, newlines and escaped quotes, and all of it is preserved — which is where naive split-on-comma converters go wrong.
Why is my ID column turning into a number?
Type conversion turns numeric-looking values into numbers, which can drop leading zeros. Switch off "convert numbers and booleans" to keep everything as strings.
Is my spreadsheet uploaded?
No. Conversion happens on your device, which matters when the file contains customer data.
Keep going
People who use this tool usually reach for these next.
Flatten a JSON array into a spreadsheet-ready CSV.
Beautify, minify and validate JSON with error positions.
Convert XML documents into JSON.
Convert YAML configuration into JSON.