CSV to JSON Converter
Paste CSV to get a JSON array of objects, or paste JSON to get a CSV file. Everything is converted on your device, so spreadsheets with personal data never leave your computer.
About this tool
CSV is the lowest common denominator of data exchange: one record per line, fields separated by a comma, semicolon or tab. The parser follows RFC 4180, so fields wrapped in quotes may contain the delimiter, line breaks and doubled quotes. With the header option on, the first line names the keys of each JSON object.
Going the other way, a JSON array of objects becomes a table whose columns are the union of all keys, in order of first appearance. Nested objects and arrays are written as JSON text inside the cell. Choose a semicolon delimiter for spreadsheets set to a European locale, where the comma is the decimal separator.
Frequently asked questions
- Which delimiters are supported?
- Comma, semicolon, tab and pipe. Auto-detect picks the one that appears most often in the first line, or you can set it explicitly.
- Why did a value like 007 stay a string?
- Leading zeros are kept on purpose: a phone number or product code would be destroyed if it turned into the number 7. Untick the typed option to keep every field as text.
- Can I convert a spreadsheet?
- Save the sheet as CSV from Excel, Google Sheets or Numbers, then paste it here. To go back, download the CSV and open it in the spreadsheet.
- Is there a size limit?
- Not a fixed one. Files of a few megabytes convert instantly; very large files depend on your device's memory.