How to Export SQL Table Data to Excel (XLSX)

Step-I: Open SQL Server Management Studio and connect to SQL Server instance by clicking on the connect button.

Step-II: Right click on database(NORTHWIND for this demo) from where you want to export table, move cursor to Tasks and click on Export Data… from the pop-up menu.

Step-III: SQL Server Import and Export Wizard will open, Click on Next button.

Step-IV:

Choose Data Source as SQL Server Native Client 11.0
Select Server Name.
To select Authentication, Either Select Use Windows Authentication or Use SQL Server Authentication radio button.
Select the Source Database from where you want to export table data.
Click on Next button.

Step-V:

Select Destination as Microsoft Excel to export in Text File.
Browse File name.
Excel version should be Microsoft Excel 2007 selected.
Check the checkbox First row has column names.
Click on Next button.

Step-VI:

Choose Copy data from one or more tables or views or write a query to specify the data to transfer.
Click on Next button.

Step-VII: If you check Write a query to specify the data to transfer radio button, then a new window will open where you write a query and click on Parse button to check the validity of query and click on Next button.