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:
- Link to a downloadable Risk Register Template spreadsheet.
- 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!
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. |
[sociallocker id=”33570″]Get Risk Register Template[/sociallocker] |
How to Use the Risk Register Template
Step 1: Download
Step 2: Edit
Step 3: Share and Collaborate
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
- Sign in to your Google account .
- Open the Risk Register Template spreadsheet in Google Sheets .
- Click File > Make a copy.
- Type a new spreadsheet name.
- Click OK.
- Go to Google Drive (drive.google.com) to find your template copy.
Download File in Other Format
- Open the Risk Register Template spreadsheet in Google Sheets .
- Click File > Download as.
- 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:
Sheet | Description |
---|---|
Instructions | Spreadsheet instructions |
1_RiskIdentification | Stage 1: risk identification |
2_RiskAssessment | Stage 2: risk assessment |
3_RiskResponse | Stage 3: risk response |
4_RiskMonitorControl | Stage 4: risk monitor and control |
RiskRegisterConsolidated | Consolidated version of Risk Register |
Score Matrix | Score Matrix |
Terms of Use | License 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.
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:
- Insert new blank rows.
- Select the last row formatted from the table.
- 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.
LICENCE AGREEMENT: Private Use (not for distribution or resale).