MS Excel has import functionality.
You can also use SQL Server 2008 R2's (even earlier versions can be used) Import and Export Wizard.
A more generic tool and that is especially meant or Import/Export of even more complicated situations is MS SQL Server Integration Services.
The following design diagram shows roughly what you should be considering. If you use left two items you will be exporting from Excel to SQL Server and if you use the right two items you will be importing from SQL Server to Excel.