Select the appropriate delimiter (I chose Comma) and deselect any others that don't apply, then click Next:.
The only way I could fix was to first format all of the cells in the empty sheet to Text, by using the following steps:Īfter formatting all of the sheet cells to be Text, then I could import the CSV using the following steps: To add to answer from this question, I had a CSV file that had several columns that had leading zeros and longer numbers that would either lose the leading zero or convert the long number to scientific notation, or both, when imported.
