Databricks is streamlining data access for business users with its new Databricks Excel Add-in, now in public preview. This tool aims to bridge the gap between the company's lakehouse architecture and the ubiquitous spreadsheet software that remains central to many daily business analyses.
Traditionally, connecting Excel to the lakehouse has involved complex configurations and manual steps, often requiring IT intervention. This friction point has led to outdated data extracts and duplicated datasets, hindering efficient decision-making. The new add-in promises a simpler, governed approach.
No SQL, Just Spreadsheets
The core value proposition is enabling business users to import and analyze Databricks data directly within Excel without needing to write SQL queries or manage ODBC drivers. Built on Databricks SQL and Unity Catalog, the add-in brings live, governed lakehouse data and curated business semantics into a familiar interface.
Setup is reduced to a few clicks, drastically lowering the barrier to entry for finance, operations, and other business teams. Users can select and filter Databricks tables and Unity Catalog metric views using a point-and-click UI. This allows for the creation of native Excel pivot tables directly from governed lakehouse data.
Data teams can define business metrics once using Unity Catalog metric views, ensuring consistency across Excel and other analytics workflows. This approach replaces fragmented semantic layers and reduces the risk of data duplication and metric drift.