Documentation
Microsoft Excel

Microsoft Excel

Microsoft Excel (opens in a new tab) is a popular spreadsheet application.

Connect from Cube Cloud

Cube Cloud provides two options to connect to Excel:

MDX APICube Cloud for Excel
Operating systemsMicrosoft WindowsAll, including macOS
PlatformsDesktopAll, including web and mobile
Pivot table supportNative PivotTable (opens in a new tab)Custom pivot table UI

Navigate to the Integrations page, click Connect to Cube, and choose Microsoft Excel to get detailed instructions.

Connect from Cube Core

There's no way to connect a Cube Core deployment to Excel.

Connect from Microsoft Excel

MDX API

In Excel, go to the Data tab of the ribbon, click Get Data and select From Database → From Analysis Services. Then, enter the credentials.

To find your MDX API credentials, go to the Integrations page, click API credentials, and choose the MDX API tab.

Cube Cloud for Excel

Follow the instructions to install the add-in and authenticate to Cube Cloud.