CSV to JSON Converter

How to use the csv to json converter

Paste CSV on the left. The first row is treated as column headers, and each subsequent row becomes a JSON object. JSON appears live on the right.

Formula & explanation

Each row → object. Keys come from the header row; values are strings (CSV has no native types). Delimiter is auto-detected: comma, semicolon, or tab.

Examples

name,age\nAlice,30\nBob,25 becomes [{"name":"Alice","age":"30"}, {"name":"Bob","age":"25"}]

Frequently asked questions

Why are numeric values strings in the output?

CSV has no type information — "30" could be an int, a fixed-width code, or a phone-number prefix. We keep everything as a string so you decide. Parse them with parseInt / parseFloat in your code after.

How do you detect the delimiter?

We sample the first few lines and pick whichever of comma, semicolon, or tab appears most frequently. European spreadsheets often default to semicolon — that works too.

What about quoted strings with commas inside?

Standard RFC 4180 quoting is honored: double-quoted fields can contain the delimiter and newlines; doubled-quotes inside a quoted field render as a single quote.