Convert CSV to JSON
Convert a CSV table to an array of JSON objects, automatically detecting numbers and booleans.
Processed on your device. Nothing is sent to any server.
Uses the first row as field names and builds one object per following row, turning into numbers or booleans only the values that lose no information.
Use cases
- Converting an Excel or Google Sheets export to JSON for an API.
- Preparing tabular data to consume in an application.
- Turning a CSV into structured test data.
How it works
- 1
Paste your CSV
The first row must contain the column names.
- 2
Convert it
Click Convert and copy or download the resulting JSON.
Technical details
- It auto-detects the separator (comma, semicolon or tab) and respects quoted values.
- "true" and "false" become booleans and plain numbers become numbers. Values with leading zeros (00123, ZIP codes or IDs), huge integers and decimal-comma numbers (1,5) stay as text so no information is lost.
- Empty rows are ignored. If a row is malformed (for example, an unclosed quote), you'll see the error instead of a partial result.
Frequently asked questions
Does the first row need headers?
Yes, the first row is always interpreted as the column names that become each object's keys.