Open Excel – > Under Data tab – > From Other Sources – > click the drop-down – > click on From SQL Server .
Give the Server name and login credentials :
Select the Database and Table/View from which you want to pull data .
Give the file name and click on Finish .
Again you will be prompted for Table / View from which you want to pull data .
Select the type in which you want to view the retrieved data and then click on Properties …
Under Usage pane – > select the refresh options to update the data in the excel sheet whenever data gets updated in the database .
Under Definition pane – > If you want to pull data from T-SQL query or by executing
Stored procedure – > select the Command type as SQL and place the query in the Command text .
If you click OK , you can notice data getting populated as shown below :