CSV to JSON Converter
Move data between spreadsheets and code. Convert CSV rows into JSON objects, or flatten a JSON array back into CSV that opens in Excel or Google Sheets.
More settings
Runs in your browser. What you enter here is not sent to our server.
- Converts in both directions
- Detects commas, semicolons and tabs
- Open files up to 5 MB
How to use the CSV to JSON Converter
- Choose the direction.
- Paste your data or open a file of up to 5 MB.
- Copy the result or download it as a file.
Things that commonly go wrong
- Semicolons instead of commas. Spreadsheets in many European locales export with semicolons. The separator is detected automatically, or set it under More settings.
- Commas inside values. A value such as
"York, UK"must be wrapped in double quotes, which this converter reads and writes correctly. - Leading zeros. Codes such as 00123 are kept as text so the zeros are not lost.
Questions about the CSV to JSON Converter
What JSON shape does JSON to CSV need?
An array of objects, such as [{"name":"Ana","age":31}]. Each object becomes a row and each key becomes a column.
Is my data uploaded?
No. Conversion happens in your browser.