Office for Mac Issues

How to Fix Snowflake ODBC External Browser SSO in Excel for Mac

Natalie TaylorNatalie Taylor Nov 3, 2026 869 views

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.

How to Fix Snowflake ODBC External Browser SSO in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Review Official Snowflake Guidance

Open your web browser and review Snowflake's official documentation for macOS ODBC. Ensure your connection string includes the necessary parameter 'authenticator=externalbrowser'.

2
Check macOS System Permissions

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).

3
Reconfigure iODBC Connection

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.

4
Consult the Community

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.

Verify Snowflake and ODBC Browser Authentication Settings
Workaround Alert: If external browser SSO remains completely blocked by Excel's sandbox, consider temporarily authenticating using standard username and password credentials within the ODBC prompt if your organization's security policies allow it.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvFree and lightweight alternative specifically optimized for macOSFamiliar user interface that requires zero learning curve to masterBuilt-in robust data processing and visualization tools
QA img-9

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'.