VanillaPM
Sign in Get started free Dashboard
Free template

RACI matrix template

A free RACI matrix template in Excel and CSV — activities against roles, with R / A / C / I drop-downs and a check that every row has exactly one Accountable and at least one Responsible.

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
Activity or deliverable
Role 1Rename to a person or role · drop-down R, A, C, I, A/R
Role 2drop-down R, A, C, I, A/R
Role 3drop-down R, A, C, I, A/R
Role 4drop-down R, A, C, I, A/R
Role 5drop-down R, A, C, I, A/R
Role 6drop-down R, A, C, I, A/R
CheckExactly one A, at least one R · calculated

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 RACI matrix is

A RACI matrix (a kind of responsibility assignment matrix) shows, for each activity or deliverable, who does what:

  • R — Responsible: does the work. There can be several.
  • A — Accountable: owns the result and signs it off. Exactly one per row.
  • C — Consulted: gives input before the work is done (two-way).
  • I — Informed: is told about it afterwards (one-way).

When to use it

When more than a few people share the work, and especially where groups meet: the design team and the contractor, the project and the operations team that will run the result.

How to fill it in

  1. List activities or deliverables down the left (the work packages from your WBS work well).
  2. Rename the role columns to your people or roles.
  3. Pick R, A, C or I from the drop-down in each cell (or A/R when the same person does and owns it).
  4. Read the Check column: it says Needs exactly one A or Needs at least one R until the row is right.

The Example sheet shows three Coral Ridge rows. Note the last one: a change to the opening date is accountable to the owner board, not the project manager. RACI is also a quick way to write down decision rights.

Common mistakes

  • Two A's on a row. Shared accountability means nobody's accountable.
  • Everyone consulted on everything. Too many C's slow every decision down.
  • No R. If nobody's responsible, the work doesn't happen.
  • Drawn once and forgotten. Update it when people join or leave.

See it used on a real project: Pr4 · Plan and manage resources