Databricks Tables in Excel

[haydenLiQ]

I attended the Databricks World Tour in 2023 (not the most recent one) where I remember there was mention of a feature in development that was an add-in (or similar) for Excel that would allow for native connection and importation of a Databricks table into an Excel workbook.

I can't remember what this was called and from what I can see, it has not been implemented yet. Does anyone know if Im just missing it somewhere, or when it may be available?

I understand that you can connect to Databricks from Excel using the ODBC driver. But I am hoping for a solution that is more streamlined and easier to implement for non-technical users.

[szymon_dybczak]

Hi @haydenLiQ ,

Maybe it was something similar to below? 

https://marketplace.databricks.com/details/a3633e2c-883c-4487-92f5-67ab50195259/ExponamConnect_Acces...

[Panda]

@haydenLiQ  -
Power BI has native support for Databricks connections via the Azure Databricks connector. You can pull data from Databricks into Power BI, create datasets, and then use Power BI’s Excel integration to export these datasets into Excel. 
Connect Power BI to Azure Databricks

May be one of the non Technical User Solution 🤔