Convert CSV to JSON
Turn CSV files into JSON. An array with one object per row, keyed by the header row.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop CSV files on the dialor turn it to pick what to do
A JSON array built from your CSV rows.Each row becomes one object, named by the header row.
What you get
One JSON file holding an array. Each row of the CSV becomes one object, and the keys come from the header row.
Values are typed. Numbers come out as numbers, true and false come out in lowercase as JSON booleans, and empty cells are typed as empty values. A value with a leading zero stays text, so codes like 00123 are not turned into numbers.
Choosing the delimiter
The delimiter is the character between fields. When you leave Delimiter out, it is guessed from the rows.
Set Delimiter if the guess is not what you want. The choices are comma, semicolon, tab and pipe. Spreadsheets in many European locales use semicolons.
Going the other way
To turn JSON back into a table, use JSON to CSV. For other options, see every CSV conversion.
CSV and JSON.What each format is, and the options this conversion takes.
- 01 · delimiter
Delimiter
The character between fields. It is guessed from the rows when left out. Spreadsheets in many European locales use semicolons.
commaA comma.semicolonA semicolon.tabA tab.pipeA vertical bar.
The formats
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
JSON
JSON, the data format of every API.
- Extensions
- .json
- MIME type
- application
/json - Kind
- Text and data
In your code.The same CSV to JSON conversion through the API, for your app or your agent.
$ cv convert sheet.csv sheet.json$ cv convert sheet.csv sheet.jsonQuestions.What people ask about CSV to JSON.
It supplies the keys. Each row becomes an object, and each value sits under the key of its column.
Yes. Numbers are typed as numbers in the JSON. Values with a leading zero are the exception and stay text.
Set Delimiter to semicolon. If you leave it out, the delimiter is guessed from the rows.
You get one file. It holds a single array with one object per row.