SQL Server itself does not provide any facitlities to create files in a specific format but you do have some options. DTS can create Excel file, Excel can pull the data using VBA, or you could create a program to pull the data from SQL Server and create an Excel file.
You could also get the data from SQL Server as text and let Excel import it. DTS, BCP, and even OSQL could be used to create the text file.
I'd recommend checking out DTS first, followed by Excel and a macro.
-Mike