>I selected the entire spreadsheet in Excel and made all columns unhidden

While the sheet is selected, be sure to use Format/Columns/AutoFit before you import too, or you'll truncate the table field widths to whatever the column widths were in Excel. (some not-so-power users wonder why the string that displayed properly across three columns in excel suddenly gets chopped in the table)