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.

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:

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.
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.
   
   
   
   
2. Log into your Power My Analytics hub. The PMA window will close and the add-in will appear in the Excel sidebar.
   
   

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.
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.
   
   
   
   
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.

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.
   
   
   
   
4. Once the add-in is installed, click the Data Connector button in the Home tab ribbon (in the Commands Group).
   
   
   
   
5. Paste your Excel Desktop Access Key into the Key field.
   
   
   
   
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.

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.

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.

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.

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.