Installing the Power My Analytics Add-in for Microsoft Excel

Installing the Power My Analytics Add-in for Microsoft Excel

Info
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.
Notes
The Excel Data Connector requires a PMA plan that includes spreadsheets. This is included in the Pro and Custom (formerly Enterprise) 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:


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

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

Alert
The Excel Desktop Access Key is distinct from the Power My Analytics API key found under Tools > 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.

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.

    • Related Articles

    • Power My Analytics Data Connector User Guide

      The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and ...

    • Microsoft Advertising Data Connector User Guide

      Microsoft Advertising (formerly known as Bing Ads) is a powerful platform for search advertising, keyword targeting, and more. This guide will walk you through how to connect Microsoft Advertising to Power My Analytics, create reports, and leverage ...

    • Microsoft Excel Data Integration Guide

      This article will show you how to install and use PMA's spreadsheets connector for Microsoft Excel, including setup for both Excel Online and Excel Desktop. The Excel Data Connector requires a PMA plan that includes spreadsheets. This is included in ...

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...

    • Installing the Power My Analytics Add-on for Google Sheets

      If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...