Installing the Power My Analytics Add-in for Microsoft Excel

Installing the Power My Analytics Add-in for Microsoft Excel

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.

Step 1 - Install Microsoft Excel Add-in

  1. Open a new Microsoft Excel spreadsheet, then navigate to Insert and click the Add-ins button.



  2. Click Store and search for "Power My Analytics," then click the Add button.



  3. Click Continue to agree and install the add-in.



Step 2 - Log In to Power My Analytics

If you are using the web version of Excel and have more than one Google Account, make sure you are logged into just the email associated with your Power My Analytics hub.
  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.



Step 3 - Show Sidebar

  1. To reopen the add-in once already logged in, navigate to Home > Commands Group and click Data Connector.





    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Microsoft Ads Data Connector User Guide

        The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin ...

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

      • YouTube Analytics Data Connector User Guide

        The following article is a guide to automating reports with your YouTube Analytics connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your YouTube Analytics reports. To ...

      • Power My Analytics' Data Warehouse Solution

        Power My Analytics offers a Hosted MySQL solution with your Enterprise plan. This article will help you learn about its uses and how to get started. With our Hosted MySQL solution, you can achieve GDPR compliance by setting up your data warehouse ...

      • How Can I Get Started with Embedded Analytics?

        Access your Marketing Analytics from the Tools You Use Every Day At Power My Analytics, we integrate directly with the platforms you already use to put insights at your fingertips. Rather than constantly exporting data or toggling between tools, our ...