How to Fix Snowflake ODBC External Browser SSO in Excel for Mac
Question details
Users need to resolve an external browser authentication failure when using Snowflake ODBC connections via Single Sign-On (SSO) in Excel for macOS.

- Product
- Excel for Mac
- Device & OS
- macOS
- Scenario
- Attempting to import or refresh data in Excel for Mac using a Snowflake database connection that requires external browser SSO authentication.
- Observed behavior
- The Snowflake ODBC connection successfully authenticates in the iODBC administrator tool but returns an external browser authentication error when executed inside Excel for Mac.
Ensure you have administrator privileges on your Mac to modify ODBC Data Source Name (DSN) configurations, and verify that your default web browser is updated to the latest version.
Verify Snowflake and ODBC Browser Authentication Settings
Check your browser permissions, iODBC configuration parameters, and Snowflake SSO settings to ensure Excel is allowed to trigger the external authentication workflow.
Because Excel for Mac operates in a strict sandboxed environment, it can sometimes be blocked from securely passing authentication tokens to external web browsers. Adjusting your system permissions and verifying the exact connection string parameters is usually required to fix the SSO bridge.
Open your web browser and review Snowflake's official documentation for macOS ODBC. Ensure your connection string includes the necessary parameter 'authenticator=externalbrowser'.
Navigate to System Settings > Privacy & Security > Automation on your Mac. Verify that Microsoft Excel is checked and permitted to control or communicate with your default web browser (such as Safari or Chrome).
Open the iODBC Administrator app from your Mac's Utilities folder. Select your Snowflake System DSN or User DSN, click 'Configure', and double-check that the authentication keys match Snowflake's exact requirements.
If the error persists after configuring the DSN, copy your connection logs and post your specific configuration details to the Snowflake community forums or Stack Overflow for advanced support.

Experience a Seamless Spreadsheet Workflow with WPS Office
If complex Excel for Mac sandbox restrictions and ODBC bugs are slowing down your productivity, consider trying WPS Office. It provides a lightweight, highly compatible, and powerful spreadsheet application that simplifies everyday data analysis without the steep costs.

Frequently Asked Questions
Why does my Snowflake connection work in iODBC but fail in Excel for Mac?
Excel for Mac runs inside an Apple-mandated sandbox environment that tightly restricts how applications can interact with external software. This sandbox can intercept and block Excel from launching your web browser or receiving the SSO token back from it, a problem the standalone iODBC tester does not face.
How do I specify external browser authentication in my DSN?
In your iODBC Administrator settings, you must edit your Snowflake connection string or DSN configuration to include the key-value pair 'authenticator=externalbrowser'. This tells the driver to utilize your default web browser to handle the SSO login.
Where is the iODBC Administrator located on a Mac?
The iODBC Administrator tool is typically installed in your Mac's Applications > Utilities folder. You can also easily locate it by pressing Command + Space to open Spotlight Search and typing 'iODBC'.




