# Installing the Power My Analytics Add-in for Microsoft Excel

> **Note:** If you'd like to merge and manipulate data from popular sales and advertising platforms with Microsoft Excel to create insightful and automated reporting, follow the instructions below to install and launch the [Power My Analytics Excel Data Connector](https://appsource.microsoft.com/en-us/product/office/WA200002101).

> **Note:** The Excel Data Connector requires a PMA plan that includes spreadsheets. This is included by default on the Grow and Pro plans. On the Custom plan (formerly Enterprise), spreadsheets may be optionally available depending on the terms of your specific agreement. Spreadsheets is not available on the Business or Free plans.

The Power My Analytics add-in is available for both **Excel Online** and **Excel Desktop**. You can install it from the Microsoft AppSource listing or directly from within Excel:

[https://appsource.microsoft.com/en-us/product/office/WA200002101](https://appsource.microsoft.com/en-us/product/office/WA200002101)

The installation and authentication steps differ depending on which version you are using. Choose the section below that matches your version of Excel.

## Excel Online: Install and Log In

If you are using **Excel Online**, no access key is required. Install the add-in and log in with your PMA account directly in your browser.

### Step 1: Install the Add-in

1. Open a new spreadsheet in [Excel Online](https://office.live.com/start/excel.aspx).
2. Navigate to **Insert** and click the **Add-ins** button.
3. Search for "**Power My Analytics**," then find Power My Analytics in the results and click **Add**.
4. Click **Continue** to agree and install the add-in.

### Step 2: Log In to Power My Analytics

1. Once the add-in is installed, click the **Allow** button in the sidebar.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-1.png)
2. Log into your Power My Analytics hub. The PMA window will close and the add-in will appear in the Excel sidebar.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-2.png)

> **Note:** If you are using Excel Online and have more than one Google Account, make sure you are logged into just the email associated with your Power My Analytics hub.

## Excel Desktop: Install and Authenticate

If you are using the **desktop version** of Microsoft Excel, you will need to authenticate using an **Excel Desktop Access Key** provided in your PMA hub. This key is specific to the Excel Desktop add-in and is separate from the Power My Analytics API key.

### Step 1: Find Your Excel Desktop Access Key

1. Log in to your [PMA hub](https://hub.powermyanalytics.com/).
2. In the left sidebar, navigate to **Reports > Microsoft Excel**.
3. Click the **Desktop Access Key** button in the upper-right corner of the page.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-3.png)
4. The **Excel Desktop Access Key** slideout will open on the right side of the page, displaying your access key.
5. Click the **Copy** icon next to the key to copy it to your clipboard.

> **Note:** The Excel Desktop Access Key is only required for the desktop version of Excel. No key is needed for Excel Online.

### Step 2: Install the Add-in and Authenticate

1. Open **Excel Desktop**.
2. Go to the **Home** tab and click the **Add-ins** button in the ribbon.
3. Enter "**Power My Analytics**" in the search box, then find Power My Analytics in the results and click **Add**.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-4.png)
4. Once the add-in is installed, click the **Data Connector** button in the **Home** tab ribbon (in the **Commands Group**).

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-5.png)
5. Paste your Excel Desktop Access Key into the **Key** field.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-6.png)
6. Click the **right-arrow button** to authenticate.

You are now connected and can begin creating reports with your Power My Analytics data in Excel Desktop.

> **Important:** The Excel Desktop Access Key is distinct from the Power My Analytics API key found under **MCP & API > REST API**. The API key is used for the Power My Analytics API and is no longer used for authentication with the Excel Desktop add-in. Pasting the API key into the **Key** field here is the most common cause of the hub, account, and every field below it appearing greyed out in the sidebar; if that happens, see [Hub or Account Greyed Out in the Microsoft Excel Add-in](https://knowledge.powermyanalytics.com/application/reports/hub-or-account-greyed-out-in-the-microsoft-excel-add-in/).

## Show Sidebar

To reopen the add-in sidebar after you have already installed and authenticated (in either Excel Online or Excel Desktop), navigate to **Home > Commands Group** and click **Data Connector**.

![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-in-for-microsoft-excel-7.png)

## Next Steps

Once the add-in is installed and you are authenticated, you are ready to start building reports. For a complete walkthrough on creating, editing, and managing your Excel reports, see the [Microsoft Excel Data Integration Guide](https://knowledge.powermyanalytics.com/application/reports/microsoft-excel-data-integration-guide/).

> **Note:** If the hub, account, or any field below it stays greyed out and unselectable after you authenticate, see [Hub or Account Greyed Out in the Microsoft Excel Add-in](https://knowledge.powermyanalytics.com/application/reports/hub-or-account-greyed-out-in-the-microsoft-excel-add-in/).
