Construction Project List Template

What is a Construction Project List Template?

A construction project list template is a spreadsheet that holds every project in a portfolio on one register, with a single row per project covering who owns it, what stage it has reached, what it costs and when it finishes. Some organizations call it a project directory, a portfolio register or a project reference list.

It is a portfolio-level document rather than a delivery tool. Project owners, portfolio managers, PMO leads and owner's representatives use it to answer the questions a board asks: how many construction projects are running, which ones have moved, and who is accountable for each. Delivery detail stays in each project's own schedule and cost report.

What to Include in a Construction Project List Template

A construction project list needs six things per project: a unique reference, an accountable owner, the current gate, a baseline finish date, the approved budget, and the contractor delivering it. Everything else builds on those.

The register runs across four linked sheets: the project list itself, cost and benefits, assurance, and the contractor list. Each reads from the same reference, so a project entered once appears everywhere.

Two fields do more work than the rest. The accountable owner is deliberately not the project manager, because a register naming only delivery staff cannot tell a board who is answerable for the investment decision. And the baseline finish is the only date that must never move, since slip is meaningless once the promise gets rewritten.

Construction Project List Example in Excel

Here is the template completed for a council capital program of sixteen projects, from a library replacement to a wastewater upgrade.

How to Create a Construction Project List in Excel

Give each project one row, set two thresholds that decide when a movement has to be explained, then let the sheet flag the exceptions. The template below already has the structure and the formulas built.

1. Set the organization, portfolio and reporting period, then fix your variance threshold and slip tolerance, since those two numbers do most of the work
2. Enter one row per project with its name, portfolio, asset class and the gate it last passed
3. Name an accountable owner for every project, not just the project manager
4. Record the baseline finish date and then leave it alone, re-baselining only at a gate and saying so
5. Enter the approved budget and the current forecast, and let the sheet calculate variance and flag anything over your threshold
6. Write the explanation where a variance is flagged, because a flagged row with an empty narrative turns red
7. Record two delivery confidence ratings, one independent and one the owner's own, and note which way any gap runs
8. Keep the contractor list current, since the register reads contract values and capacity from it
9. Rename the gates on the Reference sheet to match the framework your organization actually uses

A list is only as good as its last update, and the columns a board cares about go stale first. Teams past twenty or thirty projects stop maintaining the roll-up by hand and let capital program management software pull each project's status, budget and dates into one view.

Project List vs Tracker vs Portfolio Template: What's the Difference?

A project list is a register of what exists, a tracker follows how work is progressing, and a portfolio template supports investment decisions about which projects to fund.

If you need progress and status rather than a register of projects, use a construction project tracking template. For dates and phases across many projects, a multiple project tracking template does that job. For investment-level reporting, use a project portfolio template.

All three are snapshots taken by hand. A construction reporting software does the same job from live project data, which is why teams reporting monthly to a board tend to move off spreadsheets first.

Contractor List Template: Tracking Contractors Across Projects

A contractor list records who is building what across a portfolio, with each contractor's prequalification category, financial level, expiry dates and the total contract value they are carrying. This template includes one as a dedicated sheet, so the contractor list and the project list stay joined rather than living in separate files.

What the contractor sheet holds:

How to use it:

1. Add one row per contractor, with the scheme, category and financial level from their prequalification certificate
2. Enter the annual capacity that level allows, taken from the scheme rather than assumed
3. Enter the three expiry dates for license, insurance and prequalification
4. Set the average contract length on the Setup sheet, since committed value is spread across it to work out headroom
5. Leave the calculated columns alone, as committed value, headroom and project count all read from the project and cost sheets

Headroom is the column worth watching. Contract values are summed by contractor across every project, spread over your average contract length, and compared against the capacity their prequalification allows.

A contractor sitting on three of your projects can look fine on each one and be over their assessed capacity across the portfolio, which only shows in a combined view.

The same sheet works as a subcontractor list where you hold direct packages, and as a project reference list when a contractor needs documented evidence of active work for a capability statement.

If you are tracking contracts rather than the contractors holding them, a contract register is the better document, since it works from the contract as the unit rather than the company.