, ,

Project Pipeline Tracker 2023 – Free Excel Template

Download this free Excel template to track projects and calculate the effectiveness in completing them. Obtain information about all the projects that are on various stages of progress.

Project Pipeline Tracker Excel Template

This Excel template allows tracking projects and calculating effectiveness in completing them. This is applicable for scenarios where all the projects go through the same set of pre-defined stages in sequence.

In a simple example, each building project may have three stages: Plan – Design – Build. Once planning is completed, designing begins and after designing is completed, build begins. We will be tracking the completion of each stage of each project.

It is very simple to use. It can provide visibility to how long it takes for our projects to complete. It can also help identify where the bottlenecks are in our project cycle. We can also view the trends in terms of time each stages takes.

Project Pipeline - Active Pipeline Summary View
Project Pipeline – Active Pipeline Summary View

Free Download

REQUIREMENTS: Microsoft Excel for Windows (2010 or above); Microsoft Excel for Mac (2011 or above);

Video Demo

How to track project pipeline in Excel?

The template has only 3 visible sheets. In the Data sheet, we enter our input data and the Active Pipeline sheet and Report sheet have output that is automatically calculated. The Data sheet also has a summary of metrics.

Enter stages

By default the template has 6 stages (including the final closing stage).

Project Pipeline Tracker Excel Template - Enter list of stages
Project Pipeline Tracker Excel Template – Enter list of stages

We can rename those stages to meet our business needs. Also, we can remove stages if we don’t need 6. To remove 6th stage, just click on the 6th stage name and press Delete key.

Enter Projects

Enter each project in a separate row in the Projects table.

List of Projects and their information
List of Projects and their information

Enter Project ID and Name. Then, enter Start Date of project. The next 6 columns are dates of completing each stage of project.

These Stage DT fields should not be renamed.

Additional fields to track for projects
Additional fields to track for projects

The two columns (Type, Owner) are optional and can be used to store other information as you need. These can be renamed.

The last four columns in the table are calculated and should not be edited.

Project Pipeline Tracker - Calculated Fields
Project Pipeline Tracker – Calculated Fields
  • CURRENT STAGE Based on the dates entered for each project, the current stage will be displayed. If the project has completed the final stage, then it will display COMPLETED.
  • COMPLETION DATE If the project has completed the final stage, then that date will be displayed.
  • DURATION (DAYS) If the project is completed, the duration from Start Date to Completion Date. If the project is not completed, this is the duration from Start Date to Today.
  • VALIDATION The template checks for a couple of errors. If the dates entered for each stage are not sequential or if there is a date missing in between stages, ERROR will be displayed. Error projects are not included in metric calculations.

Output

Completed Projects – Summary

We can see an instant summary of the completed projects as we enter data.  Number of completed projects and how long on average a project takes.

Completed Projects - Summary View
Completed Projects – Summary View

We also see how long each stage takes to complete.

Active Pipeline – Summary

The number of projects that are currently being worked on and how many projects are currently in each stage are shown.

Project Pipeline - Active Pipeline
Project Pipeline – Active Pipeline

Active Pipeline – Details

We can also see the detailed Active pipeline in the Active Pipeline sheet.

Here we can see the (up to 5) projects in each stage as well.

Active Pipeline Report
Active Pipeline Report

The ID, Type and Owner fields are displayed. Even if you rename the fields and use them to store other type of information, they will be displayed in this Active Pipeline sheet.  Thus, it can be modified to your business needs easily.

Report

The Report sheet presents the metrics (Projects Completed, Average Project Duration and Average Duration for each stage) for the past 12 months.

Pipeline Tracker - Monthly Report - Table
Pipeline Tracker – Monthly Report – Table

The information is also presented visually so that we can see how the duration vary over month for each stage.

Pipeline Tracker - Monthly Report - Chart
Pipeline Tracker – Monthly Report – Chart

Editing the template

  • The Active Pipeline and Report sheets are locked with password (indzara) to prevent accidental editing of formulas. You can unprotect them and make edits if needed. Unprotecting sheets
  • Data sheet is not locked. You can edit the shapes and charts as needed as well.

This is the first version of this template. There are many different directions that we can take this template further. As always, I look forward to feedback and suggestions to make this more useful to a lot of people. I will do my best to implement additional features and enhance the template.

For more project management templates, please visit Project Management Excel Templates

58 responses

  1. I have up to 10 stages on my project it it possible to include all the stages ?

    1. INDZARA.COM Customer Support INDZARA team

      Thanks for using our template.

      The maximum number of stages that this template can handle is six.

      Best wishes

  2. Love the template! Are there any thoughts to enhance the Active Pipeline page to allow more than 5 projects / stage? Would be great to have a report by stage, but need it to include all the projects and not just the first 5. Thanks!!!

    1. INDZARA.COM Customer Support INDZARA team

      Thanks for your positive feedback.

      We will try to incorporate your suggestions in future releases.

      Best wishes

    2. Bhawna Mahajan

      Hi, this template is really good. I would also like to have more than 5 projects in active pipeline tab?

      Thanks!!

      1. INDZARA.COM Customer Support INDZARA team

        Thanks for using our template.

        The number of projects in the active pipeline is 5 for this template. We will try to increase the capacity in future releases.

        Best wishes

      2. Heather

        I concur with the past posts that request more than just 5 projects shown in the active pipeline. Can you provide guidance to extend this capability?

        1. Indzara INDZARA team

          Thank you for showing interest in our template.

          We take customization project for additional fee, requesting to share your requirement on number of stages required to provide an estimation for the same.

          Best wishes.

    3. Heather

      I figured out how to report out on all the projects, not just 5. You need to access the hidden sheet and add more rows to the chart sharting at E5. Despite the warning at the top, it appears to work.

  3. Mohammed Aquib

    Why in monthly report sheet in research column formula with +1 while other column without it.

    1. indzara INDZARA team

      Thanks.
      Since Excel when calculating the difference of dates (Jan 10, 2019 – Jan 1, 2019) will give 9 days instead of 10 days, we add +1 to the first stage. By this way all the days are included in the time taken.
      Please let us know if any questions.
      Thanks & Best wishes.

  4. Hello this spreadsheet is great and is exactly what I am looking for… however I cant seem to update the active pipeline and the 6 stags properly? I have 15 projects added and its only showing 8 active even though I have already entered dates for all of them

    I cant seem to locate the hidden H sheet?

    Thanks in advance fo your help

    JJ

    1. INDZARA.COM Customer Support INDZARA team

      Hello

      Please ensure you refresh the pivot tables. If that does not work, please email your file with the list of issues to contact@indzara.com

      Best wishes

  5. Hello this spreadsheet is great… is there any way of saving it so it can be shared to allow multiple users to access/edit at the same time?

    Thanks Justin

    1. INDZARA.COM Customer Support INDZARA team

      Thanks for your feedback.

      You can download the template from the download section at https://indzara.com/2016/06/project-pipeline-tracker-free-excel-template/.
      You may share the file among your team members, but only one member can update it at a time.

      Best wishes

  6. madluigie18

    Hello, would you assist me on adding a new stage or phase we have 7 phases now under Ideation and Initiation Phase? Thanks a lot.

    1. INDZARA.COM Customer Support INDZARA team

      Hello

      You can unhide the H sheet and add stages. However, please ensure that the added stage reflects on all the sheets.

      Best wishes

  7. Tried to edit the Internal / External Type column with my own list, but it does not work..

    1. indzara INDZARA team

      Thanks for emailing us. We have responded to your email addressing your questions.
      Best wishes.

  8. MICHAEL MARK

    Dear Mr. Indzara ,

    I’m a small start up developer and you’ve helped me a lot with this template. I very much appreciate and thank you for the work you’ve done. I just need help with adding more boxes on the ACTIVE PIPELINE Sheet so that I can better track the projects. Please do advice.

    Thank you once again!

    Best Regards,
    Michael

    1. INDZARA.COM Customer Support INDZARA team

      Hello

      Please note that there is a hidden sheet H where calculations are done which drive the Active Pipeline sheet. We have to first add more rows in the hidden sheet with calculations and then extend the formulas in the Active Pipeline sheet.

      Best wishes

  9. Mollie Holden

    Hello,
    I would like to reset the data for reach month rather than it accumulate over the year. For example: I don’t want the number of completed projects in April to be present when looking at the May project pipeline. However, I do want to keep all the monthly data in the reports. Is there a way to do this?

    Thank you.

    1. indzara INDZARA team

      We would have to adjust the formulas. Please feel free to edit the formulas to calculate only for the current month.
      Best wishes.

  10. Hi there,

    Do you happen to have a veriosn of this to use in Google Sheets? Thanks!

    1. INDZARA.COM Customer Support INDZARA team

      Hello,

      Our templates are designed to perform best under single user environment. Many features will not work in Google Sheets.

      Best wishes.

  11. Hi I really like this tracker. Can I add columns?

    Thanks

    1. INDZARA.COM Customer Support INDZARA team

      Hello
      Thank you for using the template.
      Please advise if you wish to add a stage or a column for calculation.
      Best wishes

      1. Thank you for sharing this template, would like to add stages. Kindly advice.

        1. INDZARA.COM Customer Support INDZARA team

          Hello
          To add a stage, the hidden sheet needs to be edited and stages added. The formula should be edited as well.
          Best wishes

  12. I’m a civil engineer, and it was very very useful for me. thanks you for the support and for this great work.

    1. indzara INDZARA team

      Glad to hear that it is useful. Thanks for feedback.
      Best wishes.

  13. I’m trying to download the project pipeline tracker via my iPad but doesn’t seem to be working.

    1. indzara INDZARA team

      Thanks for interest. I am sorry that I have not tested with iPad.
      Best wishes.

  14. I am unable to understand how you get a 6th or more project to show up in each stage, specifically the Initial Stage or my Stage 1. Also, having some issues with it calculating past the Stage 1. It will calculate if you go to Stage 6 but if you stop before it does not calculate.
    Thank you,

    1. indzara INDZARA team

      If you are referring to the Active Pipeline sheet, please note that there is a hidden sheet H where calculations are done which drive the Active Pipeline sheet. We have to first add more rows in the hidden sheet with calculations and then extend the formulas in the Active Pipeline sheet.
      If there are further questions, please email file to support@indzara.com
      Thanks & Best wishes.

  15. Great template, would like to discuss hiring you to make changes to fit our specific needs. Is this something you are interested in?

    1. indzara INDZARA team

      Thank you. I have replied to your email.
      Best wishes.

  16. Irfan Yaqoob

    Hi,
    Its a good template ,now the thing is if I have 10 stages for my project , how can I add more stages and you should have some budget calculation in your template.

    1. indzara INDZARA team

      Thanks. It would require modifying formulas in hidden sheets and the visible sheet. For budget calculations, please see Project planner https://indzara.com/product/project-planner-advanced-excel-template/
      Best wishes.

  17. bno0ota

    Dear Mr. Indzara 

    I hope my email find you well. 

    I would like to thank you for your great page and excellent Excel sheet that you always do. 

    I would like you to assist me with your project pipline tracker template. I know that DT should not rename as you mentatin in your page as will as word completed in the current stage and error and no error in the validation stage, but acullty I need to rename the whole template to Arabic could you please advise me on how I can change those things to Arabic. 

    Thanks in advance 

    Best Regards

    1. indzara INDZARA team

      You are welcome.
      I have not had a chance to translate the entire template to another language. If you try, please share your experience here. If there are specific questions, I will be glad to help.
      Best wishes.

  18. Michael

    First of all, thanks for your tremendous effort. These templates are terrific.

    On the project pipeline tracker template, is there a way to hide (or preferably delete) columns that I’m not interested in (e.g. Validation, Type, Owner, Project ID).

    Actually, it would be nice to even hide the Stage DT columns to reduce clutter.

    Thanks.

    1. indzara INDZARA team

      You are welcome. Thanks for feedback.
      Please do not delete any columns. You can hide them as needed. Just right click on the column header (at top) and choose Hide.
      Best wishes.

  19. Excel 2013

    1. indzara INDZARA team

      Thanks for your email confirming that everything is working as expected, after you restarted your PC. Thanks.

  20. Hello, when I open the file I get a message stating “there are problems with some contents. Do you want to recover as much as we can?” When I say yes, all of the images disappear and the file becomes a ‘repaired’ file. When I open the file in protected view, the images are visible. Please advise.

    1. indzara INDZARA team

      Please let me know the version of Excel you are using and if it is Mac or PC. If you could send me screenshots of the error and the file after saving, that would help as well. Thank you.

  21. Hi There — Is there a way to change the metric for the project from days to weeks?

    1. indzara INDZARA team

      Yes, it is possible. It would require some changes to the formulas. Please feel free to edit. If you would like help, please email at indzara@gmail.com and I take projects for a fee. Thanks. Best wishes.

  22. Hi – this looks to have some potential for us. We outsource all of our metal fabrication to mostly one vendor. I am trying to track the following. Po issued, fab drawings rec’d, fab dwgs to customer, fab dwgs approved, requested ship date, and ship date. My problem comes with requested ship date. I want to dictate the ship date when I issue my PO, using standard lead times we have established. Is there a way to do this using the pipeline? I also looked at the project management template for this – perhaps that is the better option. The pipeline just looked simpler and right to the facts!

    1. indzara INDZARA team

      Thank you. You are correct. This pipeline tracker is designed to track actual dates, and not expected dates based on standard lead times. We can build expected lead time concept into this if needed. We would need to know more details such as 1) whether there are standard lead times for all stages or just one (ship date), 2) Is it possible to miss the standard lead times? 3) is the goal to track actual dates and then compare with expected/standard dates to assess compliance? I take on customization projects for a fee. if you are interested in a customized solution, please email indzara@gmail.com with specific requirements on input and output. I will be glad to review and provide feedback. Thanks. Best wishes.

  23. Minor really, but template seems to require Agency FB font – this might be an issue for business users who cannot install non-default fonts. The template as downloaded, without Agency FB, looks somewhat untidy (off centre headings, obscured heading etc).

    Good functionality once you watch the video, and understand why the chart disappears if you delete the sample data… 🙂

    1. indzara INDZARA team

      Thanks for the feedback. I realized this just a few days ago and had made one with default font. I have replaced the file in this post above with the new file. Please try and let me know if there are any issues. Thanks & Best wishes.

  24. Hi there, Very nice template and excellent view. Quick Questions though:

    Q1) In the “data” tab I am adding in additional projects name after Project 15 but the moment I do that, the “Active Pipeline” count is reduced to 1 from 9. Not sure why is that happening? Please advise.

    Q2) On Project Five, I still get “Error” even when I input date in Stage 1 DT? Would you know how can I correct it?

    Q3) In the “Active Pipeline” tab, I can only see upto 5 project count, how should I increase to view all based on the data entered. I want to make this as per projects entered?

    Your support is much appreciated.

    Regards,
    Anupam

    1. indzara INDZARA team

      Thank you.

      Q1: Have you edited the stages or any of the formulas? Please let me know, as when I add projects it works fine. Even in the video demo above, I do that.
      Q2: If the date entered in Stage 1 is greater than stage 2 or less than start date, it will still be an error. Please check.
      Q3: To show more than 5 projects per stage in active pipeline report, please edit formulas in hidden H sheet (columns E to P) and then add rows with formulas in Active Pipeline sheet.

      If there are further questions please email the file and highlight questions.

      Best wishes.

      1. Bernard Luchendo

        Hi,

        How do I edit formulas to view more than 5 projects? Am unable to edit formulas in hidden H sheet (columns E to P) and then add rows with formulas in Active Pipeline sheet.

        1. indzara INDZARA team

          The Active Pipeline sheet is protected. You can unprotect with indzara as password.
          Please let us know if there are any questions.
          Thanks & Best wishes.

    2. Answer to your Q1, Anupam
      the “Active Pipeline” count is reduced to 1 from 9 because the tab just needs to be stretched in the width, it’s a number 10 but you just can’t see the zero.
      Hope this helps.

      Great
      Excel Template by the way working great.
      Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *

Indzara PROJECTS: team capacity, utilization, a workload alert and capacity against demand

Indzara PROJECTS Free

Know who is available. Plan who does what.

Capacity planning and scheduling for teams.

Try Indzara PROJECTS free

Built by INDZARA

Project Pipeline Tracker Excel Template

Project Pipeline Tracker 2023 – Free Excel Template

Free

Terms and conditions

Indzara PROJECTS · From the makers of your template

Capacity planning, out of the spreadsheet.

Indzara PROJECTS Explore Indzara PROJECTS

Built by INDZARA

Terms and conditions