cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Connect to EXCEL

NWIEFInance
New Contributor

โ€Ž07-24-2023 11:24 AM

I have hardtime connecting my existing EXCEL file to source data from DataBricks and need help

0 Kudos
1 REPLY 1

User16539034020
Contributor II
Contributor II

โ€Ž07-26-2023 02:48 PM

Hi, 

Thanks for contacting Databricks Support. 

We doesn't support direct Excel-Databricks connectivity. However, Databricks can be accessed through ODBC and JDBC interfaces, and we can leverage these with Excel's Power Query functionality for indirect connectivity.

This following article describes how to use the Databricks ODBC driver to connect Databricks to Microsoft Excel. After you establish the connection, you can access the data in Databricks from Excel. You can also use Excel to further analyze the data.
reference: https://docs.databricks.com/integrations/excel.html

Monica

0 Kudos
Announcements