In this article:

Free RACI Template for Google Sheets (2024 Update)

May 8, 2024

RACI Template in Google Sheets

A RACI matrix is a chart that helps in identifying the role of each person or team in completing tasks or deliverables for a project. RACI stands for Responsible, Accountable, Consulted, and Informed. Each column in the matrix represents a different role or person involved in the project, while each row represents a task or deliverable.

Get a copy of our free RACI template in Google Sheets here. 

raci template google sheets

Select File > Make a copy.

google sheets raci template

How to Use the Google Sheets RACI Template

Follow the steps below on how to use the free Google Sheets RACI template. 

1. Open Your RACI Template in Google Sheets

Start by opening your Google Sheets RACI template. Look for the legend in the top left corner to understand the color codes and letters (R, A, C, I). The legend explains what each color and letter stands for. R means Responsible, A means Accountable, and so on. This helps you know who does what.

raci matrix template google sheets

2. Switch Between Task List and Customization Sheets

Use the tabs at the bottom to switch between Sheet 1 and Sheet 2. Sheet 1 has the project tasks. Sheet 2 lets you change colors and letters.

3. Fill in Responsibilities for Each Task

Go back to Sheet 1 to assign tasks. Put the right letter under each role for each task. Use R, A, C, or I based on the legend.

4. Edit Colors and Roles in Sheet 2

If you need to change colors or the meaning of R, A, C, I, go to Sheet 2. Here, you can edit the dropdown keys as needed.

Just click on a cell and select the fill color in the menu. Select ‘Conditional formatting’.

Click on the the Conditional format rules that you want to edit.

You can edit the color of the cell here. 

5. Sort and Filter Tasks for Better Management

Apply filters in Google Sheets to sort tasks. You can organize them by priority, status, or who's responsible. This makes managing the project easier.

6. Regularly Update Task Progress and Roles

Keep the spreadsheet updated with the progress of tasks and any role changes. This keeps everyone on the same page and the project on track.

We hope that you now have a better understanding of how to use our free RACI template in Google Sheets. If you enjoyed this article, you might also like our article on our free roadmap template in Google Sheets or our article on Google Sheets timeline template.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->