Simple way: In SQL Server Management Studio, go to the “Query” menu & select “Query Options…” > Results > Text > Change “Output Format” to “Comma Delimited”. Now, run your query to export to a file, and once done rename the file from .rpt to .csv and it will open in Excel :).