Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
This feature is in Public Preview.
The Azure Databricks Excel Add-in connects your Azure Databricks workspace to Microsoft Excel, bringing governed Lakehouse data directly into your spreadsheets to help you move from data to decisions faster.
You can browse and import Azure Databricks tables through an intuitive interface where no SQL knowledge is required. While the add-in offers the flexibility to execute custom SQL queries, it is optional. The add-in is fully supported across Excel for the web and desktop versions for both Windows and macOS.
Get started with the Excel Add-in
To use the Excel Add-in, you must first install and connect to your Azure Databricks workspace, and then import and query data in Excel.
| Task | Description |
|---|---|
| Set up the Excel Add-in | Set up the Excel Add-in and connect to your Azure Databricks workspace. You must complete this setup before you can query Azure Databricks data in Excel. |
| Import and query data in Excel | Import data from Azure Databricks tables, write SQL queries, create pivot tables, and use custom functions to analyze your data in Excel. |