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

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