How can I export data from Azure SQL database to excel?

1
votes

How to export the azure database data to excel from azure portal, Azure query editor does not have export option like to excel. If that is not possible what are the ways I can export the data using azure connect?

1
azureazure-sql-databaseazure-active-directory

1 Answers

3
votes

You can do this directly in Excel using the "Data Connection Wizard".

  1. Go to "Data" tab in your excel workbook enter image description here
  1. In the data connection wizard enter connection details for your database server

Notice that server name has .database.windows.net in the end to provide full name.

enter image description here

  1. Select one or more tables to get data from

enter image description here

It's pretty intuitive from here on..

On a sidenote, for your client (machine where you're running Excel) to be able to connect to SQL Server, you may need to add the client's IP address following below steps -

  1. Navigate to your Azure SQL Server in Azure Portal

  2. Under Security, select "Firewalls and virtual networks"

enter image description here

  1. Add your client IP to the list of allowed IP Addresses here -

enter image description here

You can find your public facing client IP address by simply typing "my ip address" in google.