CSV to JSON Converter

A CSV file is a table in plain text: one row per line, with the fields separated by commas, semicolons, tabs or vertical bars. With “First row is column names” ticked, the converter makes every following row a JSON object with those names as keys, so a table of people becomes a list of objects with a name, a city and an age each. Untick it to get an array of arrays instead. “Separator” is set to “Auto”, which finds the separator from the first lines, or you can choose it yourself. Fields in double quotes may contain the separator, line breaks and doubled quotes, as Excel and the CSV standard write them, and empty lines are skipped.

With “Numbers and true/false as values, not text” ticked, 92.5 and true become JSON numbers and booleans, while values such as 007 or +49 stay text, so nothing is changed, and long numbers keep every digit. Empty column names become column3 and the like, and repeated ones get a number, so no value is lost. If a quoted field is not closed, you see the line and the column. Choose 2 or 4 spaces, a tab or “Minify” for the JSON, open a .csv file, and copy the result or download it as a .json file. With “From” and “To” you can also convert CSV to XML, or JSON back to CSV.