Skip to main content
Version: 24.3.x

Microsoft Excel

Supported Versions​

Microsoft Excel in Microsoft 365

Prerequisites​

  • Ensure that you are using Dremio v22.0 or later.
  • Ensure that your operating system is 64-bit Windows 10 or later.
  • Download, install, and configure the ODBC driver for Arrow Flight SQL.
  • If you want to authenticate to Dremio by using a personal access token (PAT), rather than by using a password, generate a PAT. See Personal Access Tokens for the steps.

Connecting to Dremio​

  1. In Excel, select Data from the menu bar.
  2. Click Get Data.
  3. Select From Other Sources > From ODBC.
  4. In the From ODBC dialog, select the data source name that you specified when you configured the ODBC driver for Arrow Flight SQL.
  5. Specify the username to use for the connection to Dremio.
  6. Specify either a password or a personal access token to use with the username
  7. In the Navigator dialog, select a dataset.
  8. Click Load.