Connect to Databricks from Microsoft Excel

This 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.

Before you begin

• Workspace creation options.

• Create a Databricks cluster and associate data with your cluster. See Run your first ETL workload on Databricks.

• Download the 64-bit version of the ODBC driver for your OS.

• Install and configure the ODBC driver (Windows | MacOS | Linux). This sets up a Data Source Name (DSN) configuration that you can use to connect Databricks to Microsoft Excel.

• Token management API.

• Install Microsoft Excel. You can use a trial version.

Steps to connect from Microsoft Excel

This section describes how to pull data from Databricks into Microsoft Excel using the DSN you created in the prerequisites.

Note

The steps in this section were tested using Excel for Microsoft 365 for Mac version 16.70.

1. Open a blank workbook in Microsoft Excel.

2. In the Data ribbon, click the down caret next to Get Data (Power Query), then click From database (Microsoft Query).

3. In the iODBC Data Source Chooser, select the DSN that you created in the prerequisites, and then click OK.

4. For Username, enter token.

5. For Password, enter your personal access token from the prerequisites.

6. In the Microsoft Query dialog, select the Databricks table that you want to load into Excel, and then click Return Data.

7. In the Import Data dialog, select Table and Existing sheet, and then click Import.

   After you load your data into your Excel workbook, you can perform analytical operations on it.