CSV to JSON converter
Turn spreadsheet CSV exports into JSON — quoted fields and all.
How to use
- Export or copy your data as CSV and paste it into the input box.
- Choose Objects if the first row contains column names, or Arrays for the raw grid.
- Copy the JSON into your code, API test or import script.
Frequently asked questions
My Excel uses semicolons instead of commas — will it work?
Yes. The delimiter (comma, semicolon or tab) is detected automatically from the first row, so Indonesian/European Excel exports work as-is.
Are commas and line breaks inside quoted cells handled?
Yes — the parser follows the CSV standard (RFC 4180): quoted fields may contain commas, line breaks and doubled quotes as escapes.
Why are all values strings in the output?
CSV has no types — "30" could be a number or a postcode with meaning in its leading zero. The converter keeps strings so no data is corrupted; convert types in your code where you know the intent.
About this tool
CSV is how data leaves spreadsheets; JSON is how APIs and code want it. The gap between them is full of traps this converter handles for you: fields wrapped in quotes, commas and even line breaks inside quoted fields, doubled quotes as escapes, and the semicolon-separated variant that Excel produces on Indonesian and European locales (detected automatically). Object mode reads the first row as column names and emits an array of objects, ready for a fetch mock or database seed. Array mode skips header interpretation and gives you the raw grid. Unterminated quotes are reported as errors rather than silently mangling your data.