(Up|in)sert Excel format with cell starting with " fails to parse data

[gaelguimini]

Hi,

When attempting to upsert (or insert) data from Excel format fails to parse it if some cells start with ".

Steps to reproduce

1. Create an excel workbook and sheet containing

lastname | email
"pseudo" lastname | [email protected]

2. Copy sheet content from excel
3. Paste into salesforce inspector with Excel format checked

Expected

The preview shows headers and the only line well parsed

Actual

The parsing fails with Error: unexpected token ' '

Cause analysis

Excel format seems to rely on csv-parser.js which checks for " at start of cell content as string identificator. In turn, the content until next " is considered for cell value (pseudo in my repro data), then cell separator is expected. It fails du to finding anything but cell separator ( in my repro data).
This is NOT helpfull for Excel content

Possible workarround

• Sanitize cells by adding a space before starting " ( used for now)
• Export sheet to CSV (untested)

`