Connecting Excel with Snowflake

Download the ODBC driver here https://www.snowflake.com/en/developers/downloads/odbc/
​

In the Windows search bar on your desktop, search for "ODBC".
​​

Open "ODBC Data Sources".
​

Click "Add".
​​

Choose "SnowflakeDSIIDriver", click "Finish".
​

Choose any alias for "Data Source".
​

Enter info from your Snowflake account as "Server" as follows:
​
“[organization ID]-[account name].snowflakecomputing.com”
​​

You can get your organization ID and account name by hovering over your profile and then the account in Snowflake.
​

Enter database, warehouse, role (e.g., ACCOUNTADMIN), user, and password either in the configuration or when in Excel.
​

Click "OK" to finish.
​

Open Excel, click on the Data tab, click "Get Data", "From Other Sources", "From ODBC".
​

Choose "Snowflake" connection.
​

Enter the remaining details and click "Connect".
​

You can now choose from all the tables being shared in Snowflake to bring in as a table or pivot table.