Turn a spreadsheet export into an array of JSON objects, using the first row as the keys. The parser handles the parts of CSV that trip up naive splitting: quoted fields containing commas, escaped quotes, and both Windows and Unix line endings.
Yes. Fields wrapped in double quotes may contain commas, line breaks and escaped quotes written as two double quotes in a row. This is where splitting on commas naively falls apart.
Values that look like numbers, true, false or null are converted to those JSON types. Everything else stays a string. Note that values with leading zeros, such as postcodes and identifiers, are deliberately kept as strings so the zeros survive.
The first row is always treated as headers. Add a header row before converting, or accept that your first data row will be consumed as key names.
Very long numbers exceed the precision JavaScript can represent exactly. If you are working with large identifiers, wrap them in quotes in the CSV so they are preserved as strings.