Query Snowflake with Excel


Query Snowflake with Excel

by Holt Calder

Kicking off a new year of Snowflake blogs seemed like a great opportunity to give you the tips and tricks of connecting to Snowflake from Excel. Businesses have been using databases to get data for Excel workbooks forever, but looking through the depths of Google, there wasn’t a comprehensive step-by-step guide on how you could do the same with Snowflake.

Follow these steps to pull data from Snowflake into Excel.


Prior to downloading any driver from the Snowflake UI, I’m going to check the version of Office 365 installed on my machine so that I know which version of the ODBC Driver to install. You can go into the settings of Excel and get this information by following these steps:

  1. Open the workbook.
  2. File > Account > About Excel:

getting Excel info for Snowflake query

Download the Driver

Now that I know I have the 32-bit version of Office 365 installed, I’m going to go and download the 32-bit ODBC Driver from the Snowflake UI.

  1. Navigate to the Snowflake UI, select the Help drop-down menu and go to Downloads.

Excel to Snowflake

2. Download and install the ODBC Driver:

installing ODBC Driver from Snowflake

Configure the ODBC Driver

Now that I have the correct version of the ODBC Driver for Snowflake installed, I am one step closer to connecting to Snowflake with Excel. The final steps are configuring my ODBC Driver into a Data Source Name (DSN).

  1. Navigate to the ODBC Data Source Administrator and add a User DSN. From the list of Drivers, select SnowflakeDSIIDriver:

ODBC data sources in Snowflake

  1. Fill out the relevant fields:
    • Data Source name
    • User
    • Server
    • Warehouse
    • Role

relevant fields to add a user DSN

Connecting with Excel

After configuring my ODBC Driver, I can start connecting to Snowflake with Excel. I am going to start by opening an Excel workbook. To set up the connection in the workbook, follow the instructions below:

  1. Select the Data tab.
  2. Select the drop-down for Get Data.
  3. Select the option for From Other Sources.
  4. Select the option From ODBC.

set up connection between Snowflake and Excel      5. Select the DSN we configured. Mine is called Snowflake.
      6. Select the database and table you want to query and enjoy!

Final Product

queries and connections between Snowflake and Excel

Above: Excel querying public FAA Flight data from Snowflake with the ODBC Driver

data layout in Excel

Above: Data layout in Excel

More About the Author

Holt Calder

Data Architect
Analytics in Digital Transformation with AWS The year 2020 produced a mass migration of business processes, enterprise software and internal workloads to AWS in a way that was ...
Introducing InterWorks Translate, Our DataDev Hackathon Project At InterWorks, we have always been a group of tinkerers. Near the end of last year, we had the opportunity to launch the Amazon ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!