>>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)

This doesn't work for me for some reason...