---
title: Preparing Data for Import (Risks)
description: "These rules are for the Register Risks module. They add to the rules in [Preparing Data for Import (Default)](https://support.symbiant.co.uk/kb/preparing-data-for-import/), which also apply. **Warning:** Follow these rules carefully. If you're unsure, raise a support ticket and we'll help you through it.…"
url: "https://support.symbiant.co.uk/kb/preparing-data-for-import-risks/"
updated: "2026-10-30"
category: Importing Data
tags:
  - Add
  - Import
---

# Preparing Data for Import (Risks)

These rules are for the Register Risks module. They add to the rules in [Preparing Data for Import (Default)](https://support.symbiant.co.uk/kb/preparing-data-for-import/), which also apply.

**Warning:** Follow these rules carefully. If you're unsure, raise a support ticket and we'll help you through it.

## An Example File

![An example risks import file](https://support.symbiant.co.uk/wp-content/uploads/2026/10/preparing-data-for-import-risks-01-prep-risks-csv.png)

## The Rules

1. **Save the file as CSV (UTF-8)**, with one column per field.
2. **Fill in every required field.** Reference and Summary are always required, and on most systems Register and Score Set are too (marked with a red asterisk on the risk form).
3. **Make references unique.** Use only letters, numbers, underscores (_), dashes (-) and dots (.), up to 15 characters, with no spaces. An existing reference is **overwritten** by the import.
4. **Match the case exactly**, and avoid commas and special characters except in free text.
5. **Write divisions as full paths**, for example `Company/UK/Sales`, and only use divisions you have access to.
6. **Write dates in UK format**, DD/MM/YYYY.
7. **Include a Register and a Score Set on every risk.** Without a register, the risk won't appear in Register Risks. Without a score set, it can't be scored.
8. **Only import Impact and Likelihood for each score.** For Inherent, Residual and Target scores, give the Impact and Likelihood as numbers from your score set (for example Inherent Impact 4, Inherent Likelihood 3). Symbiant works out the totals.
9. **Give checkbox fields a value on every row** (for example Requires Capital: `true` or `false`).
10. **Owners are optional**, but must already exist as users. Use their full name or email address.

## Next Step

[Importing Data (Risk Register Specific)](https://support.symbiant.co.uk/kb/importing-data-risk-register-specific/)
