You may create a plain table in SQL Server and import Excel data into it.
Then you may execute SQL code to create normalized data in your tables.
Try the
SaveToDB add-in for Excel[
^].
It allows saving data into database tables from Excel. It is free.
If you need to repeat this task periodically, you may customize saving data in add-in using stored procedures. It is the same task you need. But this is an Enterprise edition feature.