Convert CSV to JSON
Convert a CSV table to an array of JSON objects, automatically detecting data types.
Processed on your device. Nothing is sent to any server.
Convert a CSV table to an array of JSON objects, automatically detecting numbers and booleans.
Uses the first row as the object's keys and generates one array item per following row, automatically detecting whether a value is a number, boolean or text.
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.
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.