Risk Register Template


This template is designed to help you track information about identified risks over the course of a project using Google Sheets, Open Office, or Microsoft Excel. All for free.

What you will find here are:

  1. Link to a downloadable Risk Register Template spreadsheet.
  2. Instructions to enter your data into the Risk Register Template.

What you will not find here is an article on the topic of risk management. Why settling down to an article when you can have an entire section? Right here .

Get started now with your Risk Register Template!

Image titled risk register template tipsographic rendering spreadsheet

Get started now

All you need to do is download the Risk Register Template and complete the steps described in the rest of this page, and in about ten minutes you’ll have created your Risk Register easily, ready for printing or sharing with your team members.
Up

How to Use the Risk Register Template

The Risk Register Template is an online spreadsheet that lets you create and format a simple yet complete risk register spreadsheets and work with other people.

Designed for Google Sheets, you can access and edit your spreadsheets wherever you go — from your phone, tablet, or computer — even when there’s no connection.

You don’t have to worry about file format too, because it’s fully compatible with Open Office and  Microsoft Excel.

To use this template, after you got a copy of the file, enter identified events or conditions in each row of the sheets following the steps below.

Up

Step 1: Download


To start using the Risk Register Template, you have two options:

Copy File in Google Sheets

  1. Sign in to your Google account .
  2. Open the Risk Register Template spreadsheet in Google Sheets .
  3. Click File > Make a copy.
  4. Type a new spreadsheet name.
  5. Click OK.
  6. Go to Google Drive (drive.google.com) to find your template copy.Image titled risk register template tipsographic copy file

Download File in Other Format

  1. Open the Risk Register Template spreadsheet in Google Sheets .
  2. Click File > Download as.
  3. Click the format of choosing among the following:
    • Microsoft Excel (.xlsx)
    • OpenDocument format (.ods)
    • Adobe® PDF document (.pdf)
    • Comma-separated values (.csv)
    • Tab-separated values (.tsv)
    • Web page (.zip).

Image titled risk register template tipsographic download file

Up

Step 2: Edit


The spreadsheet has 8 sheets:

SheetDescription
InstructionsSpreadsheet instructions
1_RiskIdentificationStage 1: risk identification
2_RiskAssessmentStage 2: risk assessment
3_RiskResponseStage 3: risk response
4_RiskMonitorControlStage 4: risk monitor and control
RiskRegisterConsolidatedConsolidated version of Risk Register
Score MatrixScore Matrix
Terms of UseLicense agreement for using the Risk Register Template

 

Start by editing the 4 core sheets of the Risk Register Template: 1_RiskIdentification, 2_RiskAssessment, 3_RiskResponse, and 4_RiskMonitorControl.

The core part of the spreadsheet follows the cycle of project risk management: risk identification, assessment, response, and monitor and controlling. To avoid errors in the pre-set formulas, enter your data in this sequence.

The cells that you fill in these 4 operative sheets populates the consolidated version of the Risk Register automatically.

Unhide Instruction for Data Entry

Row 7 contains the instruction necessary to enter data into the table.

To unhide row 7, click the arrow around where the row number 7 used to be.

Note: The same applies to the other 3 operative sheets and the consolidated Risk Register.

Enter Data into Header of Sheet 1_RiskIdentification
  • Project name (cell B3): the name of the project.
  • Date prepared (cell F3): the day of the year you have prepared the risk register.

Note: Cells B3 and F3 authomatically populate headers in the other sheets.

Enter data into Table of Sheet 1_RiskIdentification
  • ID (range  B8:B17): authomatically filled, do not enter any data.
  • Phase (range  G8:G17): use the dropdown to choose the project phase when the identify risk occurs, from the following:
    • Initiation
    • Planning
    • Execution
    • UAT
    • Go Live
    • Close Out
    • Post Live.

Note: To edit the dropdown:

  • Select the cell range for the column labeled “Phase” that contains the dropdowns (G7:G#).
  • Click Data > Data validation…
  • To change the options listed, edit the items next to “Criteria:”, separated by commas and no spaces.
  • Click Save.
Image titled risk register template tipsographic data validation
Apply Existing Formatting and Formula to New Rows

For every new row you create to the end of the table, past the formatting and formula from the existing ones.

The faster and safer way is to:

  1. Insert new blank rows.
  2. Select the last row formatted from the table.
  3. Click on the little bottom right corner and drag down, to extend the formatting.
Up

Step 3: Share and Collaborate


Share the Risk Register Template with your team, or people outside your company. Choose whether they can view, edit, or comment on it.

Recommended for You