CSV to JSON Converter
Convert CSV to JSON in your browser. Quoted fields, commas inside quotes and Turkish Excel semicolons are handled.
What it is for?What it is for?
CSV is what you get when you export a sheet from Excel, Google Sheets or a database client. JSON is what an API, a test fixture or a JavaScript file expects. Paste the CSV, pick the separator and copy the JSON. The result updates as you type.
Quotes and separators
A field wrapped in double quotes may contain the separator or a line break. A quote inside that field is written twice. Semicolon is the separator Excel uses in many Turkish locales. With the header row on, each following row becomes an object. Without it, the result is an array of arrays.
Example
With the header row on, the two lines name,city and "Gcode, Emre",Istanbul become one object with the keys name and city. The comma inside the quotes stays part of the name.
Things to check
- Every value comes out as a string: 42 becomes "42" and true becomes "true". Convert types in your own code if you need numbers or booleans.
- If a row has fewer cells than the header, the missing ones become empty strings. Cells beyond the last header column are dropped.
- Empty rows are skipped when the header row is on. A byte order mark at the start of the file is removed.
- If every row ends up as one long value, the separator is wrong. Try semicolon or tab.
It stays in the browser
Parsing happens in this tab. The CSV is not uploaded.