--- title: Link to Excel worksheet description: PlanGuru's "Excel Link" method allows customers to link to an external worksheet for the purposes of forecasting a revenue, expense or nonfinancial line. Typically, our customers use this in one of tw --- [Skip to content](https://help.planguru.com/knowledge/link-to-excel-worksheet#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 Desktop (Windows)](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en) 3. [Forecasting & Modeling](https://help.planguru.com/knowledge/planguru-desktop-windows?hsLang=en#forecasting-modeling) # Link to Excel worksheet PlanGuru's "Excel Link" method allows customers to link to an external worksheet for the purposes of forecasting a revenue, expense or nonfinancial line. Typically, our customers use this in one of two ways, First to forecast an important revenue (or cost) account based on an external Excel file.  There are several reasons why a customer chooses to do this in Excel, and not PlanGuru, however once linked the two files are connected. The second use is to store "Global variables".  PlanGuru v8 allows users to link Non-Financial categories to Excel.  When using multiple analysis files, customers can maintain one set of global variables (which drive forecast allocations) and link all of their PlanGuru analysis files to them. Whatever your reason for using this functionality, it is powerful and provides additional flexibility. To use the Link to Excel worksheet method.  1. Add or change an existing category and select the "Excel Link" method  ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005163311image.png) 1. Click Browse and navigate to the Excel file you'd like to link to.  ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005163331image.png)   1. Highlight the cells you would like to link and click the "Add" button, next click the corresponding PlanGuru time periods.![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005149992image.png) 2. You'll know your links have been accepted when they are formatted in red.  Next click the "OK" button. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005163371image.png) 5\. In the last step you will click OK and you're done. ![](https://help.planguru.com/hubfs/Knowledge%20Base%20Import/planguru.zendesk.comhcarticle_attachments360005150012image.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