CSV to JSON Converter
Paste CSV data or choose a file, and get clean JSON back. Quoted fields, commas inside quotes, and line breaks inside cells are all handled properly.
About this CSV to JSON Converter
CSV is the format spreadsheets export; JSON is the format applications and APIs expect. This converter turns one into the other. Paste your data or load a .csv file, choose whether the first row holds column names, and press Convert to JSON. By default you get an array of objects with the header row supplying the keys, which is the shape most code expects. Choosing Array of arrays instead keeps the raw rows, which is useful when there is no header or you want the positions preserved.
The parser follows the real CSV conventions rather than simply splitting on commas. A field wrapped in double quotes may contain commas, line breaks, and doubled quotes to represent a literal quote character, and all of these are read correctly — a common reason naive converters mangle exported address or comment columns. Windows and Unix line endings are both accepted, and the delimiter can be detected for you or set explicitly to a comma, semicolon, tab, or pipe. Semicolons matter in particular because spreadsheets in many European locales use them by default.
Three options control the values. Trim spaces removes padding left by hand-edited files. Convert numbers and true/false writes 42 and true as real JSON types rather than strings, while deliberately leaving anything ambiguous alone — a value such as 007 or a long account number keeps its leading zeros and stays a string, since converting it would lose information. Treat empty values as null distinguishes a genuinely missing value from an empty string. Duplicate or blank column names are made unique so no data is silently overwritten, and if some rows have more fields than the header the tool tells you instead of dropping them.
Typical uses include preparing a spreadsheet export for an API request, seeding test data, converting a contact or product list for an import script, and inspecting a data file in a readable structure. The result can be copied or downloaded as a .json file, and pairs well with our JSON Reader for validating and reformatting the output. Everything runs in your browser, so customer lists and other private data are never uploaded.