Stakeholder register template
A free stakeholder register template in Excel and CSV — interest and influence scores with an automatic power-interest quadrant, current and desired engagement, concerns, communication needs and an owner.
What's inside
| Column | What goes in it |
|---|---|
| Stakeholder | A person or a group |
| Role in the project | |
| Organisation | |
| Interest (1–5) | drop-down 1, 2, 3, 4, 5 |
| Influence (1–5) | drop-down 1, 2, 3, 4, 5 |
| Quadrant | From influence and interest · calculated |
| Engagement now | drop-down Unaware, Resistant, Neutral, Supportive, Leading |
| Engagement wanted | drop-down Unaware, Resistant, Neutral, Supportive, Leading |
| Main concerns | |
| Communication needs | |
| Owner | Who keeps this relationship |
The Excel file has three sheets: the blank register, a filled example from the Coral Ridge Resort sample project, and how to use each column. The CSV is the blank header row only.
What a stakeholder register is
The stakeholder register lists everyone who affects the project or is affected by it, people and groups, with what they care about, how much they can influence it, and how engaged they are now compared with how engaged you need them to be.
When to use it
From the very start (the charter already names the key stakeholders) and throughout. New stakeholders appear as the project moves: a regulator at permitting, an operator at handover.
How to fill it in
- List stakeholders: individuals where it matters who they are (the sponsor), groups where it doesn't (local residents).
- Score interest and influence from 1 to 5. The Quadrant column places each one on the power-interest grid: Manage closely, Keep satisfied, Keep informed or Monitor.
- Record engagement now and wanted: unaware, resistant, neutral, supportive or leading. The gap between the two is what your engagement plan has to close.
- Write their concerns and communication needs in their terms, then give each relationship an owner.
The Example sheet shows the owner (manage closely, already supportive) and the local community (resistant now, needs to become supportive) from the Coral Ridge sample.
Common mistakes
- Leaving out opponents. People who resist the project are stakeholders, often the most important ones.
- Scoring once. Influence and interest change over the life of the project.
- No owner. A relationship nobody keeps goes cold.
- Treating everyone the same. The quadrant tells you where your time goes.
Use the communications plan template next: it turns these communication needs into a plan.
See it used on a real project: P4 · Engage stakeholders