This spreadsheet template should be used to structure your risks ready to import into 6clicks.
This table explains the columns and data requirements.
Risk library data import format
Column Name |
Description |
Data Constraint |
App Reference |
Source |
The author of the content - i.e. vendor name - "Risks 'R Us Pty Ltd" |
30 characters |
N/A |
ContentRef |
A reference to the underlying source of the content if/where the content has been derived online from an online source |
30 characters |
N/A |
RiskLibrary |
This is the name of the risk library as indicated to the right. |
30 characters |
|
RiskLibraryDescription |
The description of the risk library. |
45 characters |
|
RiskDomain |
The risk domain name picked from the list shown here. |
Lookup and reference the risk domain |
|
Risk |
The name of the risk. |
45 characters |
|
Description |
The description of the risk |
140 characters |
|
Cause X |
A common cause related to the risk. Note in the spreadsheet, that for each additional cause, you should populate the additional column - i.e. Cause 1, Cause 2, Cause 3 etc. |
45 characters |
|
Impact X |
A potential impact related to the risk. Note in the spreadsheet, that for each additional cause, you should populate the additional column - i.e. Impact 1, Impact 2, Impact 3 etc. |
45 characters |
Once your data has been structured in the google sheet, please share this sheet with us - instructions are here. Please email the google sheet link to us as support@6clicks.io
Our process once we imported your risk library(s)
To ensure a collective and well structured underlying data model, we may de-duplicate and unify risks, causes and impacts so if we find an existing match we’ll use it (you can directly quote existing risks, causes and impacts if you like and want to help keep our data clean).