Preparing your risk library for import

This spreadsheet template should be used to structure your risks ready to import into 6clicks.

This table explains the columns and data requirement.

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 In the mobile app, the risk will then appear on a card with the risk domain as the title and the background colour as indicated 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

Sharing the completed google sheet with us

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 [email protected]

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

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us