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.
What's inside
| Column | What goes in it |
|---|---|
| Activity or deliverable | |
| Role 1 | Rename to a person or role · drop-down R, A, C, I, A/R |
| Role 2 | drop-down R, A, C, I, A/R |
| Role 3 | drop-down R, A, C, I, A/R |
| Role 4 | drop-down R, A, C, I, A/R |
| Role 5 | drop-down R, A, C, I, A/R |
| Role 6 | drop-down R, A, C, I, A/R |
| Check | Exactly 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
- List activities or deliverables down the left (the work packages from your WBS work well).
- Rename the role columns to your people or roles.
- Pick R, A, C or I from the drop-down in each cell (or A/R when the same person does and owns it).
- 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