Home / Developer tools / CSV to JSON Converter
CSV to JSON Converter
Spreadsheet exports arrive as CSV; APIs and code want JSON. Paste the rows, pick the separator, and get a proper array of objects — with quoted fields containing commas parsed correctly, which naive converters get wrong.
How to use it
- Paste the CSV, straight from a spreadsheet if you like.
- Pick the separator and say whether the first row holds column names.
- Convert and copy the JSON.
Examples
- Three columns and two data rows become an array of two objects.
- A field written as "Lisboa, Portugal" stays a single value instead of splitting.
- Numbers become real JSON numbers, and true and false become booleans.
Questions people ask
Why does my European CSV break?
Because Excel in many locales writes semicolons rather than commas, since the comma is the decimal mark. Switch the separator to a semicolon and the columns line up again.
What happens to empty cells?
They become empty strings, which keeps every object the same shape. If your consumer needs null instead, a quick find-and-replace on the output handles it.
Related tools
Updated: 2026-08-07