These are all great recommendations.  Excel is tough, users can type whatever they want and this can be difficult to process.

If this is a one-time process, and if the spreadsheet is small, consider creating the table in your database, then pasting values into the table.  Sometimes for smaller one-time jobs, I'll even generate INSERT statements on the spreadsheet, then paste to SSMS to analyze and execute.  This gives you code that is easy to debug if needed, such as when fields have bad characters, or when specific rows should not be inserted.