---
title: Excel Add-in Guide for PlanGuru App
description: Getting your Add-in set up to pull custom reports from your Scenarios
---

[Skip to content](https://help.planguru.com/knowledge/planguru-app-online/excel-add-in-guide-for-planguru-app#main-content)

[![PlanGuru Help Center](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_helpcenter.png?width=360&height=50&name=logo_PlanGuru_helpcenter.png)](https://help.planguru.com/knowledge?hsLang=en)

- [Your Tickets](https://help.planguru.com/tickets-view)
- [Sign out](https://help.planguru.com/_hcms/mem/logout)

Open main navigation

Close main navigation

- [Your Tickets](https://help.planguru.com/tickets-view)
- [Sign out](https://help.planguru.com/_hcms/mem/logout)
- [Submit a Ticket](https://help.planguru.com/tickets-view/new)

[Submit a Ticket](https://help.planguru.com/tickets-view/new?hsLang=en)

 Hello. What do you need help with?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.planguru.com/knowledge?hsLang=en)
2. [PlanGuru App (Online)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en)
3. [Standard Reports](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#standard-reports)

# Excel Add-in Guide for PlanGuru App

## Getting your Add-in set up to pull custom reports from your Scenarios

1. First, if you have not yet installed the Excel Add-in you can [download and install it from here (.xlam file for Windows)](https://www.planguru.com/support/downloads/).
2. Before connecting to a Scenario or doing anything else, the Excel workbook must be saved. This is so the Add-in knows which file path to follow. Where this file is saved should not matter, so long as it is saved somewhere.
3. If you need to switch to a different login the next step should be to right click anywhere and clicking "Logout"  
   ![](https://help.planguru.com/hs-fs/hubfs/image-png-3.png?width=213&name=image-png-3.png)
4. Once that is done you can log in to the account you wish to use by clicking "Setup".   
   ![](https://help.planguru.com/hs-fs/hubfs/image-png-4.png?width=222&name=image-png-4.png)
5. This will bring up the login screen, where you will login to your PlanGuru App account.   
   ![](https://help.planguru.com/hs-fs/hubfs/image-png-Dec-31-2021-08-01-32-06-PM.png?width=315&name=image-png-Dec-31-2021-08-01-32-06-PM.png)
6. Once logged in successfully, you can start building out the elements needed to pull your report(s). The first step should be inserting the Workbook Level Settings Tab. This is done by right clicking and selecting “Generate Setting”.  
   ![](https://help.planguru.com/hs-fs/hubfs/image-png-Dec-31-2021-08-02-10-11-PM.png?width=258&name=image-png-Dec-31-2021-08-02-10-11-PM.png)
   
   This will bring you to the newly created “Workbook Level Settings” tab in Excel.
   
   ![](https://help.planguru.com/hs-fs/hubfs/image-png-Dec-31-2021-08-02-49-18-PM.png?width=541&name=image-png-Dec-31-2021-08-02-49-18-PM.png)
   
   Each of these variables must be filled out. **Note:** For Company Name, Project Name, and Scenario Name in “Scenario in Report” must match EXACTLY to what it is in App.
   
   For the Additional Variables Section Year of Historical and Year of Forecasted/Budgeted refers to the number of years. So, the answer for these would be 2 or 3 or however many are in the scenario. The By Month section is asking how many of those years are by month. So if a user has 5 historical years and all are by month, that number would be 5.
7. Once the Workbook Level Settings Tab is filled out one more step remains before you can start pulling data and this is to generate the “behind the scenes” workbook that stores the scenarios info in its raw form. To do this right click anywhere and click “Setup” again. This will generate that workbook.
8. Of note is the Layout Grid that is in rows 14 and 15 in the screenshot above. You don’t have to do anything here unless you want to change the layout of a report but this is where the add-in tells you what it will be looking for and where. In this case it will be looking for Account Names (or account numbers if you want to use them) in Column A, the name of the scenario to find those accounts in in Row 1, the type of data you want to pull (Historical, Budget, Actual, Forecast) in Row 2, and the time period you want to pull in Row 3 (the month or FY or YTD number you want to pull).
9. At this point you can use the “Member Insert” menu to start inserting these variables. This can be done by manually typing in as well but usually it is far faster to use Member Insert.![](https://help.planguru.com/hs-fs/hubfs/image-png-Dec-31-2021-08-04-24-05-PM.png?width=322&name=image-png-Dec-31-2021-08-04-24-05-PM.png)
10. Once the variables are set you can start to pull the data. There are two pull options. Pull and Pull All. Pull only refreshes the data on the tab you’re currently on, while Pull All refreshes the data throughout all tabs in the workbook.  
    ![](https://help.planguru.com/hs-fs/hubfs/image-png-Dec-31-2021-08-04-57-95-PM.png?width=267&name=image-png-Dec-31-2021-08-04-57-95-PM.png)
11. Once the Pull or Pull All completes you should have the finished report!  
    ![](https://help.planguru.com/hubfs/image-png-Dec-31-2021-08-05-19-31-PM.png)

 

 

- [PlanGuru App (Online)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#main-content)

    - [Getting Started](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#getting-started)
    - [Setup & Import](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#setup-import)
    - [Company Management](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#company-management)
    - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#forecasting-modeling)
    - [PlanGuru Analytics (powered by Reach Reporting)](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#planguru-analytics-powered-by-reach-reporting)
    - [Standard Reports](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#standard-reports)
    - [Updates](https://help.planguru.com/knowledge/planguru-app-online?hsLang=en#updates)
- [PlanGuru Desktop (Windows)](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#main-content)

    - [Updates](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#updates)
    - [Getting Started](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#getting-started)
    - [Navigating PlanGuru Desktop](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#navigating-planguru-desktop)
    - [Setup & Maintenance](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#setup-maintenance)
    - [QuickBooks Online Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-online-import)
    - [QuickBooks Desktop Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#quickbooks-desktop-import)
    - [Excel Import](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#excel-import)
    - [Analysis Setup](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#analysis-setup)
    - [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#forecasting-modeling)
    - [Installation](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#installation)
    - [Licensing](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#licensing)
    - [Managing your PlanGuru Files](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#managing-your-planguru-files)
    - [Reporting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#reporting)
    - [PlanGuru Analytics](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-analytics)
    - [Technical Inquiries](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#technical-inquiries)
    - [PlanGuru Desktop in Cloud Hosting](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#planguru-desktop-in-cloud-hosting)
    - [Advanced Reporting Excel Add-in](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#advanced-reporting-excel-add-in)
- [PlanGuru University](https://help.planguru.com/knowledge/planguru-university?hsLang=en)

- [PRODUCTS & PRICING](https://www.planguru.com/products/)
- CUSTOMERS 
    - [Small Businesses](https://www.planguru.com/users/small-business/)
    - [Nonprofits](https://www.planguru.com/users/nonprofit/)
    - [Accountants / Advisors](https://www.planguru.com/users/accountants-business-advisors/)
- LEARNING 
    - [Attend a Live Demo](https://www.planguru.com/products/planguru-webinar-signup/)
    - [PlanGuru University](https://www.planguru.com/planguru-university/) 
          - [Sign Up for PGU](https://www.planguru.com/planguru-university/)
          - [PGU Class Materials & Recordings](https://www.planguru.com/planguru-university/class-materials/)
    - [Video Tutorials](https://www.planguru.com/learning-resources/learning-center/)
    - [Help Center](https://help.planguru.com/knowledge)
- SUPPORT 
    - [Help Center/ Submit a Ticket](https://help.planguru.com/knowledge)
    - [Downloads / Updates](https://www.planguru.com/support/downloads/)
- [Try it FREE](https://www.planguru.com/products/trial/)

[![logo\_PlanGuru\_190-1](https://help.planguru.com/hs-fs/hubfs/logo_PlanGuru_190-1.png?width=190&height=55&name=logo_PlanGuru_190-1.png "logo_PlanGuru_190-1")](https://www.planguru.com/)

Copyright © 2025, PlanGuru