docs-mintlify/admin/connect-to-data/visualization-tools/excel.mdx
Microsoft Excel is a popular spreadsheet application.
<iframe width="100%" height="400" src="https://www.youtube.com/embed/vG7iEdYTvIQ" title="YouTube video" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />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 Connect to Cube, and choose Microsoft Excel to get detailed instructions.
There's no way to connect a Cube Core deployment to Excel.
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. Use the full MDX API URL, including
the /cubejs-api/v2/mdx path, as the server name.
The MDX API supports the same Kerberos and NTLM authentication methods as the DAX API, configured on the Settings → Power BI page of your deployment.
Follow the instructions to install the add-in and authenticate to Cube Cloud.