This template is designed to help you track information about identified risks over the course of a project using Google Sheets (G Suite), LibreOffice Calc, or Microsoft Excel. 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!

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.

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).

Up

Step 2: Edit

The workbook has 8 sheets:

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.

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.

LICENCE AGREEMENT:  Private Use (not for distribution or resale).