How to convert CSV to JSON

What the conversion produces

When the first row is a header, each following row becomes one JSON object. The header names become the object keys, so a row with columns name and role becomes an object with those two properties.

Quoting rules

A field that contains a comma, a double quote or a line break must be wrapped in double quotes. A double quote inside a quoted field is written as two double quotes.

If a field has a stray quote, the converter reports the row where the problem starts, so you can fix that line in the source file.

Delimiters

Most CSV files use commas, but many European spreadsheet exports use semicolons, and tab-separated files are common too. Auto-detect picks the delimiter that gives the most columns in the first row. Choose it yourself if the result looks wrong.

Why values stay as text

The converter keeps every value exactly as written. A code such as 007 stays 007, and a date stays text. Convert the types in your own code after parsing, where you know what each column means.