CSV to JSON
Convert a spreadsheet export into JSON.
Drop in a CSV and get JSON. The separator and the character set are both worked out for you, which is what usually goes wrong with files exported from Excel in a Russian locale.
How to use it
- Add the CSV file.
- Check the preview and whether the first row is a header.
- Copy the JSON or save it as a file.
Why use this tool
Completely private
Everything runs inside your browser. Your files and text are never sent to a server.
Free, with no limits
No sign-up, no watermarks and no cap on how many times you can use it.
Instant results
There is no upload or queue to wait for, so results appear as fast as your device can work.
Works on any device
Runs in any modern browser on phone, tablet or desktop. Nothing to install.
Frequently asked questions
- My file uses semicolons. Will that work?
- Yes. Excel in a Russian or Uzbek locale writes semicolons, because the comma is the decimal separator. The separator is detected from the file rather than assumed, and tabs and pipes work too.
- What about Cyrillic that comes out as gibberish?
- That means the file is windows-1251, not UTF-8. The character set is detected the same way the separator is, so those files are read correctly rather than turning into question marks.
- Why is my phone number now a number?
- It should not be. Values with leading zeros are deliberately kept as text, since dropping the zero from a postcode or an account number corrupts it. Turn off the typed values option to keep everything as strings.
- What happens to duplicate column names?
- The second one gets a suffix. Without that, one column would silently overwrite the other.