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.




    • Related Articles

    • 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. The Excel Data Connector requires your PMA plan to have the spreadsheets addon. This is included in the Pro and Enterprise plans and is available for ...

    • How to Use the Exports Add-On

      Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, and FTP. With our easy-to-use Exports Add-On, you can set up a report in PMA's Data Explorer and schedule ...

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with your Enterprise plan. This article will help you learn about its uses and how to get started. With our hosted MySQL sovereign warehouse solution, you can achieve GDPR compliance by ...

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