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 API | Cube Cloud for Excel | |
|---|---|---|
| Operating systems | Microsoft Windows | All, including macOS |
| Platforms | Desktop | All, including web and mobile |
| Pivot table support | Native 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.