How to Export query result to .csv or Tab Delimited File in SQL Server Management Studio(SSMS) - SQL Server / TSQL Tutorial Part 23

Scenario:

I can view query results in SQL Server Management Studio(SSMS), Is there a way to save the query results to csv file or tab delimited file from SSMS?

Solution:

We often need to save the query results to csv or tab delimited format. SQL Server Management does let us save the results to csv and tab delimited format.

Step 1:

Run your query and go to Grid and right click any where in the grid and then choose Save Results As..

How to save query results to csv file or tab delimited format from SSMS - SQL Server Tutorial

Step 2:
Provide the file name as you like and type csv or tab as shown below.

Export query result to .csv file in SQL Server Management Studio - SQL Server / TSQL Tutorial

The results will be exports to file. You can open the file with excel or you can open with notepad. Here I opened with notepad.

How to export query results to csv or tab delimited file from SSMS - SQL Server Tutorial