sqlsql-server-2008excelssmsexport-to-excel

Saving results with headers in SQL Server Management Studio


I am using SQL Server Management Studio.

I wish to save the results of a query to an excel file.

I choose "save as" and then save to CSV file which I can open in excel. All good except I am missing column headers, any ideas how I get them exported?


Solution

  • Tools > Options > Query Results > SQL Server > Results to Text (or Grid if you want) > Include columns headers in the result set

    You will need to close and reopen SSMS after changing this option.

    Note: On the SQL Editor Toolbar, you can click Results to file (Refer screenshot) without having to restart SSMS.

    enter image description here

    Alternatively, you can also press Ctrl + Shift + F if you like keyboard shortcuts during development.