CSV to JSON Converter
CSV to JSON Converter convert spreadsheet CSV to JSON comma separated rows to objects CSV headers JSON arrayTurn tabular records into objects
Paste CSV containing a header row and at least one data row, select comma, semicolon, or tab, then choose Convert to JSON. Each header becomes a property name and every following row becomes one object.
How rows become JSON
The first row defines keys in their original order. Every later field is assigned to the matching header and kept as a string. This predictable approach avoids guessing whether values such as 00123, dates, large identifiers, or the words true and false should change type.
Worked example
Input with headers name,city followed by Rosa,Austin produces an array containing {"name":"Rosa","city":"Austin"}. A field written as "Austin, TX" keeps the comma inside its value. Two consecutive quotes inside a quoted field become one literal quote.
Quoting and line breaks
Quoted fields may contain the selected delimiter and line breaks. Quotes inside them must be doubled according to common CSV conventions. Every data row must ultimately contain the same number of fields as the header. Nonempty unique headers are required so conversion cannot silently overwrite one property with another.
CSV is a family of formats
There is no single convention used by every spreadsheet, regional setting, database export, or legacy system. Some files use semicolons because commas mark decimals; others use tabs. Character encoding, byte-order marks, comments, custom escape rules, and malformed exports can require a dedicated import workflow.
Privacy and limitations
Parsing occurs locally and no data is uploaded. This version accepts pasted text rather than file selection, keeps all values as strings, and does not infer nested JSON, schemas, formulas, dates, or numeric types. Browser memory limits input size. Review sensitive exports and converted records before feeding them into another system.
CSV to JSON FAQ
Are numbers converted to JSON numbers?
No. Values stay as strings so leading zeros and long identifiers survive.
Can a quoted field contain a comma?
Yes. A selected delimiter inside a properly quoted field remains part of that value.
Why are duplicate headers rejected?
JSON objects cannot preserve two properties with the same name predictably.