Microsoft Excel

Microsoft Excel is a popular spreadsheet application.

<YouTubeVideo url="https://www.youtube.com/embed/vG7iEdYTvIQ" aspectRatio={5/4} />

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	Custom pivot table UI

Navigate to the Integrations page, click <Btn>Connect to Cube</Btn>, and choose <Btn>Microsoft Excel</Btn> 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 <Btn>Data</Btn> tab of the ribbon, click <Btn>Get Data</Btn> and select <Btn>From Database → From Analysis Services</Btn>. Then, enter the credentials.

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

Cube Cloud for Excel

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