Turn a spreadsheet export into JSON. Quoted commas and line breaks inside cells are kept.
A naive split on commas breaks as soon as a name contains a comma or a note contains a line break. This converter follows the usual spreadsheet rules: a field wrapped in double quotes may contain the delimiter and newlines, and a quote inside that field is written as two quotes.
Excel in many European locales saves CSV with semicolons, because the comma is the decimal mark. Tabs are what you get when you copy a sheet. Pick the delimiter that matches the file, not the one you wish it used.
\uFEFF.column_1, column_2, and so on, so keys stay valid.Every value stays a string. The converter does not guess that 0012 is a number, because that would drop the zeros a product code needs. Parse numbers in your own code after you have seen the column.
A row shorter than the header gets empty strings for the missing cells. A quoted field that is never closed is an error, not a silent trim. That usually means a quote was typed inside a cell without doubling it.
The file was saved as UTF-8 with a BOM, or the delimiter is wrong so the whole line became one field. This page strips a leading BOM. If the columns still look wrong, switch between comma, semicolon and tab.
The work happens in your browser. Tens of thousands of rows are fine. A huge export will make the tab slow; split the file first.