CSV ⇄ JSON converter
Paste CSV or a JSON array of objects and convert it in either direction. The data stays on your device.
CSV ⇄ JSON converter runs entirely in your browser: the text you paste is never sent to a server. It is free and needs no sign-up.
How to use it
- Choose the direction Pick CSV to JSON or JSON to CSV, then paste your data into the box, up to 5 MB. Each conversion runs as you type, and the result appears below.
- Set the delimiter and keys Choose comma, semicolon, tab, or automatic detection. Keep the first row as keys when your file has headers. Number and true or false conversion is off by default, so values such as leading zeros stay text.
- Copy or download Press Copy, or Download .json or Download .csv. The CSV file starts with a byte order mark so Excel opens UTF-8 text correctly. Errors name the line where the problem starts.
Questions
What happens to nested objects when converting to CSV?
Each nested object or array is written as JSON text inside its cell. Values that contain the delimiter, quotes, or line breaks are wrapped in quotes, and the result notes that nested cells were written.
What does the formula protection option do?
When it is on, a text cell that starts with =, +, -, @, a tab, or a carriage return gets an apostrophe in front, so a spreadsheet treats it as text instead of a formula. It is off by default, so turn it on when the file will be opened in a spreadsheet.