If anyone is interested, I've created an SSMS 2005/2008 Addin that allows saving SQL query results as an XLS file, with header and value formats intact. You don't have to mess around with copying and pasting to import CSV.
Cheers,
David
SsmsXlsExport.com