Microsoft Excel

Supported Versions

Warning: Excel 16.95(Mac) Compatibility Issue

Microsoft Excel version 16.95 (25030928) for Mac introduces a change that causes Excel to crash when using the Arrow Flight SQL ODBC driver. The crash occurs immediately after authentication, before the query/source selection dialog appears. This issue only affects Excel 16.95 on macOS. Excel on Windows is not impacted. We recommend delaying the Excel update on Mac until a fix is available.

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.