Part 10. Importing and Exporting Risk Data into Spreadsheets
The use of spreadsheets is heavily embedded in almost every organisation, no matter how big or small. People are familiar with spreadsheets and are often happy in the knowledge that they can just about do what they need to, albeit a time consuming and labour intensive practice.
However when choosing a risk management solution, you must ensure it is possible to integrate the use of spreadsheets. This can be as simple as allowing users to upload or download information to and from spreadsheets.
What you need to consider;
- Don’t create an additional barrier to reporting risk: if risk data is siloed within your organisation, at the very least your solution needs to make integrating with spreadsheets easy
- Flexible export options: While the standard reports and dashboards are useful for viewing risk data, it is sometimes necessary to be able to export risks as a spreadsheet e.g. for Board meeting handouts
- How the rest of your organisation works: Other functions such as Finance will be comfortable with using spreadsheets so having the ability for your system to integrate with spreadsheets will add further value to your risk management.
- Upgrading existing risk management processes: If you’re struggling to manage your risks using spreadsheets, your new solution will need to provide support for data loading your existing risk data from spreadsheets.