Free Project Status Report Template (Excel)
What's in the status report template
The Status Report sheet has one row per workstream: Workstream, Owner, Status, Progress, Next milestone, Due date, and Notes/risks — everything a steering committee needs to see at a glance, with room for up to 25 workstreams.
The Status column is where you flag Red, Amber, or Green, and the summary section reads those flags to give you a portfolio-level view without any manual counting.
The Notes/risks column is deliberately separate from the status flag itself, so a workstream can be flagged Green on progress while a specific risk is still logged and visible for the next review, instead of the status color hiding a concern that needs attention.
What calculates automatically
The summary counts how many workstreams are Red, Amber, and Green as you set each row's status, and it averages progress across every workstream — so before a steering meeting you already know your overall health at a glance.
There's nothing to sum by hand: change a status or update a progress percentage, and the red/amber/green counts and average progress update immediately.
That average progress figure also gives you a single trackable number over time — copy it into a separate log each week or month and you have a lightweight history of how the overall project is trending, without exporting anything from a project management tool.
Why this beats a blank spreadsheet
A blank status report usually means re-tallying reds and ambers manually before every meeting, which is easy to get wrong or skip under time pressure — and a stale count undermines the whole report.
A consistent format from week to week also makes it easier for a sponsor or steering committee to spot trends — a workstream that's been Amber for three straight updates tells a different story than one that just turned Amber this week, and that only shows up when the format doesn't change.
With the counts and average built in, your status report is always accurate the moment you update a row, so you can walk into a steering meeting confident the numbers are right.
Who this status report template is for
Project managers reporting to a steering committee or sponsor are the core use case — anyone who needs a repeatable, at-a-glance format for communicating project health across multiple workstreams without writing a narrative report from scratch every week.
It's also useful for PMOs standardizing how different project leads report status, since every workstream follows the same columns and the same RAG convention, making it easy to compare progress across projects rather than reading through inconsistent free-text updates.
Consultants and agencies managing several client projects at once can adapt the same sheet per client or per engagement, giving them a consistent internal view of where every project stands without maintaining separate reporting formats for each one.
How to use it
- List each workstream with its owner in the Status Report sheet.
- Set the RAG status (Red, Amber, Green) and enter the progress percentage for each.
- Add the next milestone, due date, and any notes or risks.
- Check the summary for red/amber/green counts and average progress before your steering meeting.
Download the free Free Project Status Report Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
CRM & Sales Pipeline Tracker
If you're tracking sales opportunities rather than project workstreams, the paid CRM Sales Pipeline template ($14) adds a funnel conversion view by stage, a 3-scenario forecast, and stale-deal alerts.
See the full versionFrequently asked questions
Can I use this template in Google Sheets?
Yes. Upload it to Google Drive, then File > Save as Google Sheets, and the summary counts keep working.
Is it really free?
Yes, in exchange for an email address to download it. No further cost after that.
Can I add more than 25 workstreams?
Yes, insert additional rows below the last one — extend the summary formulas to cover the new range if you add many.
Can I customize the RAG status options?
Yes, the Status column is plain text/dropdown you can edit — just keep the values consistent with what the summary formulas expect (Red, Amber, Green).
What's the usage license?
Personal use or use within one business. Not for resale or redistribution as a template product.