Skip to main content

Upload a CSV

Felix Mayer avatar
Written by Felix Mayer
Updated over 11 months ago

To import existing risk matrices via CSV file, navigate to Process Engine > Risk Matrices and click on Upload a CSV.

You can select a file by clicking on Browse or drag and drop a file into the designated area.

Upon uploading, the system validates the file's structure and data consistency.

Once the file is successfully uploaded, the dialog window will show you your risk matrix.

You will find the all risk matrices under Your Risk Matrices
​

To make sure the CSV file can be processed, please ensure to use the correct format as described below.

CSV formatting

General Requirements

Character Encoding:

  • Use UTF-8 encoding

  • This ensures proper handling of special characters in country names

File Extension:

  • Files must use the .csv extension

  • Example: country_risk_matrix.csv

CSV Structure

Header Row: The first row must contain these exact column names:

CopyCountry,Country Short,Score

Column Specifications:

  1. Country (Required)

    • Full country name

    • Text field

    • Example: "United States of America"

  2. Country Short (Required)

    • ISO country code or abbreviated name

    • Text field

    • Example: "USA"

  3. Score (Required)

    • Numerical risk score

    • Float/decimal number

    • No thousands separators

    • Example: 1234.5

Data Format Rules

Country Names:

  • Use official country names

  • Maintain consistent capitalization

  • No leading/trailing spaces

Country Short:

  • Use consistent abbreviation format

  • Preferably use ISO 3166-1 alpha-2 or alpha-3 codes

  • No spaces or special characters

Score Format:

  • Decimal numbers allowed

  • Use period (.) as decimal separator

  • No thousands separators

  • Valid range: 0-9999

Example CSV Content

csvCopyCountry,Country Short,Score Denmark,DNK,10 Iran,IRN,9999 United States of America,USA,50

Common Issues and Solutions

Formatting Issues:

  • Ensure no hidden characters in headers

  • Check for consistent delimiter usage (commas)

  • Remove any blank rows

  • Strip any trailing commas

Data Validation:

  • Verify all required fields are present

  • Check for duplicate country entries

  • Ensure scores are within valid range

  • Validate country codes against ISO standards

Error Prevention:

  • No quotes around numeric values

  • No formatting (bold, italics, etc.)

  • No extra columns

  • No merged cells

Testing Your File

Before uploading:

  1. Open in a text editor to verify formatting

  2. Check for consistent line endings

  3. Validate UTF-8 encoding

  4. Confirm all required columns are present

Did this answer your question?