Yes — the parser correctly handles quoted fields containing the delimiter, embedded newlines, and escaped double-quotes, following standard CSV conventions.
Uncheck "First row is header" and columns will be automatically named column1, column2, etc.
Yes — empty values become null, true/false become booleans, and numeric-looking values become numbers. Values like leading-zero codes may be affected by this, so double-check the output for that kind of data.