RACI Matrix – Free Excel Template

A RACI or Responsibility Assignment Matrix (RAM) describes the participation by various roles in completing tasks or deliverables for a project or business process. It is especially useful in clarifying roles and responsibilities in cross-functional/departmental projects and processes.

The R & R matrix provides a comprehensive visualization of who does what in the project, avoiding redundancy of roles or dilution of responsibilities. RACI is an acronym derived from the four key responsibilities most typically used:

  1. Rresponsible.
  2. Aaccountable (or approver).
  3. Cconsulted.
  4. Iinformed.

Main Features

  • RACI Matrix:
    • Persons in charge (x-axis)
    • Activities (y-axis)
    • Roles & Responsibilities (Matrix)
  • Excel formulas to check some key values:
    • Each activity has at least one R (responsible, leader)
    • No activity has more than one responsible person (accountability)
    • Highlight the members that have no responsibility (consider efficiency improvement ?)
    • Highlight the members that have too many roles
  • Legend & definitions

Download link

To download this tool, click on the following link :


  • This tool is free
  • It can be modified by the user
  • Cannot be redistributed or sold


  • PC Excel 2016: OK
  • PC Excel 2013: OK
  • PC Excel 2010: OK
  • PC Excel 2007: OK
  • MAC – Excel 2016: OK
  • MAC – Excel 2011: not tested

Additional details

  • Language(s): English
  • Revision 2


  1. It’s a nice one !!! Thanks

Leave a Reply