DATA + AI SUMMIT ![Image 4: Data+ai summit promo JUNE 15–18|SAN FRANCISCO Last chance to save 50% — ends April 30. Register](http://www.databricks.com/dataaisummit?itm_source=www&itm_category=home&itm_page=home&itm_location=navigation&itm_component=navigation&itm_offer=dataaisummit)

Table of contents

ProductApril 21, 2026

Introducing the Databricks Excel Add-in for Business Users

Empower business users with governed access to Databricks data in Excel, no SQL skills required.

by Toussaint Webb and Kaitlin Baumgardner

Summary

Make Excel work with your lakehouse: Use Databricks tables and metric views in a familiar tool with a simple, no-code interface.
Reduce friction for business users: Skip the manual driver setups and complicated configurations with a simple, lightweight add-in that works right out of the box.
Replace legacy semantic layers: Define business metrics once with Unity Catalog metric views instead of maintaining separate tools just to serve Excel.

Spreadsheets remain the backbone of day-to-day business analysis. Finance teams model forecasts in Excel. Operations teams track performance. Leaders rely on spreadsheets to answer questions quickly.

Yet, the most trusted and complete business data increasingly lives in alakehouse. For many organizations, connecting that data to Excel today is complex, fragile, and inaccessible to business users. Manual ODBC configuration, multi-step setup guides, and ongoing IT support create friction that slows performance and adoption. Data duplication and multiple semantics layers introduce risks and limit who can actually use governed data.

The result: outdated extracts, duplicated datasets, and business users working around the data platform instead of with it, often relying on legacy BI tools or downstream systems.

The solution: Simple, governed access to Databricks data in Excel

TheDatabricks Excel Add-in is designed to close this gap. Now in public preview, the add-in lets business users import and analyze Databricks data directly from Excel — without writing SQL or configuring ODBC drivers.

Built onDatabricks SQL andUnity Catalog, the add-in brings live, governed lakehouse data and curated business semantics into the Excel experience users already know. Setup is reduced from dozens of manual steps to just a few clicks, making it dramatically easier for business teams to get started.

Image 5: Short animation showing how to set up the Excel Add-in

Critically, the Excel Add-in supportsUnity Catalog metric views, letting data teams define business semantics once and make them available consistently across Excel and other analytics workflows.

With the Excel Add-in, users can:

Select and filter Databricks tables and metric views using a point-and-click UI — no SQL required
Create native Excel pivot tables backed by governed lakehouse data
Refresh data to keep spreadsheets up to date
Access Databricks Workspace queries across workbooks for consistent definitions
Optionally write and save SQL queries for reuse

This allows data teams to maintain strong governance while enabling business users to work independently in Excel.

The Excel Add-in helps us streamline our workflows without compromising governance. Teams can explore, process, and import Databricks data directly in Excel, while Unity Catalog ensures permissions and definitions stay consistent. It's a big step forward from CSV downloads and manual refreshes. —Spenser Marshall,CIO, M Science

Why this matters: Business semantics + Excel changes the equation

For business users, the value is immediate: faster access to trusted data in the tool they already use every day, without waiting on IT or learning new interfaces.

For data leaders, the Excel Add-in helps:

Democratize data among business stakeholders
Ensure business teams always work from trusted, up-to-date business semantics through Unity Catalog metric views
Enforce Unity Catalog permissions, lineage, and governance
Eliminate metric drift caused by duplicated logic in spreadsheets and dashboards
Reduce strain on data practitioners to perform one-off analyses that take time away from their focus

Together, this makes Databricks a more natural part of everyday business workflows.

“The Databricks Excel Add-in turned our gold tables into a business ready product. It is fast, it keeps Excel workflows intact, and it lets one governed asset serve everyone from advanced analytics to business users.” —Paritosh Mehta,Solution Architect, Baytex Energy Corp.

How this looks in practice

1. **Data teams define data assets, like****Unity Catalog metric views**

Data teams create governed metric views in Unity Catalog to standardize KPIs and business definitions — once — directly on Databricks data. 2. **Governance and access are managed centrally**

Permissions and controls are managed and provisioned through Unity Catalog, ensuring the right users see the right metrics with full compliance. 3. **Business users analyze data directly in Excel**

Business users access these metrics in Excel via the Databricks Add-in, build pivot tables, and explore data without rewriting logic or exporting extracts.

**Outcome:** Faster, more reliable decision-making powered by a single source of truth for business semantics and seamless access in Excel. This is a key step toward democratizing the lakehouse, bringing governed analytics to the tools business teams already rely on.

What’s available today and what’s coming next

The public preview already supports core workflows business users rely on:

Selecting Unity Catalog tables and metric views
Executing custom functions with parameters
Manually refreshing query results
Creating Excel pivot tables and filtering data
Selecting and reusing existing Databricks Workspace queries
Changing workspaces

Upcoming enhancements include scheduled refresh, AI integrations, and additional usability improvements to further streamline the experience.

How to get started

TheDatabricks Excel Add-in is available in public preview and can be installed via theMicrosoft Office Marketplace or manually downloaded fromDatabricks documentation. Administrators can deploy it centrally through the Microsoft 365 admin center, while individual users can install it directly in Excel for the web, Windows, or macOS (with the appropriate permissions). After a quick setup, business users can connect to their Databricks workspace and start working with governed lakehouse data right away.

Get the latest posts in your inbox

Subscribe to our blog and get the latest posts delivered to your inbox.

Sign up

Work Email

Country Country*

By clicking “Subscribe” I understand that I will receive Databricks communications, and I agree to Databricks processing my personal data in accordance with its Privacy Policy.

What's next?

→

November 21, 2024/3 min read

#### How to present and share your Notebook insights in AI/BI Dashboards

→

December 10, 2024/7 min read

#### Batch Inference on Fine Tuned Llama Models with Databricks Model Serving

![Image 6: databricks logo](https://www.databricks.com/)

Why Databricks

Discover

Customers

Customer Stories

Partners

Why Databricks

Discover

Customers

Customer Stories

Partners

Product

Databricks Platform

Pricing

Open Source

Integrations and Data

Product

Databricks Platform

Pricing

Open Source

Integrations and Data

Solutions

Databricks For Industries

Cross Industry Solutions

Data Migration

Professional Services

Solution Accelerators

Solutions

Databricks For Industries

Cross Industry Solutions

Data Migration

Professional Services

Solution Accelerators

Resources

Documentation

Customer Support

Community

Learning

Events

Blog and Podcasts

Resources

Documentation

Customer Support

Community

Learning

Events

Blog and Podcasts

About

Company

Careers

Press

Security and Trust

About

Company

Careers

Press

Security and Trust

![Image 8: databricks logo](https://www.databricks.com/)

Databricks Inc.

160 Spear Street, 15th Floor

San Francisco, CA 94105

1-866-330-0121

[](https://www.linkedin.com/company/databricks)
[](https://www.facebook.com/pages/Databricks/560203607379694)
[](https://twitter.com/databricks)
[](https://www.databricks.com/feed)
[](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm)
[](https://www.youtube.com/@Databricks)

See Careers

at Databricks

[](https://www.linkedin.com/company/databricks)
[](https://www.facebook.com/pages/Databricks/560203607379694)
[](https://twitter.com/databricks)
[](https://www.databricks.com/feed)
[](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm)
[](https://www.youtube.com/@Databricks)

We Care About Your Privacy

Databricks uses cookies and similar technologies to enhance site navigation, analyze site usage, personalize content and ads, and as further described in our Cookie Notice. To disable non-essential cookies, click “Reject All”. You can also manage your cookie settings by clicking “Manage Preferences.”

Manage Preferences

Reject All Accept All

Privacy Preference Center

Opt-Out Preference Signal Honored

Privacy Preference Center

### Your Privacy
### Strictly Necessary Cookies
### Performance Cookies
### Functional Cookies
### Targeting Cookies
### TOTHR

#### Your Privacy

When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

#### Opting out of sales, sharing, and targeted advertising

Depending on your location, you may have the right to opt out of the “sale” or “sharing” of your personal information or the processing of your personal information for purposes of online “targeted advertising.” You can opt out based on cookies and similar identifiers by disabling optional cookies here. To opt out based on other identifiers (such as your email address), submit a request in our Privacy Request Center.

More information

#### Strictly Necessary Cookies

Always Active

These cookies are necessary for the website to function and cannot be switched off in our systems. They assist with essential site functionality such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will no longer work.

#### Performance Cookies

[x] Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

#### Functional Cookies

[x] Functional Cookies

These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

#### Targeting Cookies

[x] Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant advertisements on other sites. If you do not allow these cookies, you will experience less targeted advertising.

#### TOTHR

[x] TOTHR

Cookie List

Consent Leg.Interest

[x] checkbox label label

[x] checkbox label label

[x] checkbox label label

Clear

- [x] checkbox label label

Apply Cancel

Confirm My Choices

Allow All

![Image 15: Powered by Onetrust](https://www.onetrust.com/products/cookie-consent/)

!Image 17!Image 18

Introducing the Databricks Excel Add-in for Business Users

Databricks Excel Add-in | Databricks Blog