VanillaPM
Sign in Get started free Dashboard
Free template

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.

Download Excel (.xlsx) Download CSV Free · no sign-up · opens in Word, Excel, Google Docs/Sheets and LibreOffice

What's inside

ColumnWhat goes in it
StakeholderA 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
QuadrantFrom influence and interest · calculated
Engagement nowdrop-down Unaware, Resistant, Neutral, Supportive, Leading
Engagement wanteddrop-down Unaware, Resistant, Neutral, Supportive, Leading
Main concerns
Communication needs
OwnerWho 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

  1. List stakeholders: individuals where it matters who they are (the sponsor), groups where it doesn't (local residents).
  2. 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.
  3. Record engagement now and wanted: unaware, resistant, neutral, supportive or leading. The gap between the two is what your engagement plan has to close.
  4. 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