Upload a CSV | spektr Helpcenter

Upload a CSV

Updated over a year agoFelix Mayer Table of contents

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

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

Files must use the .csv extension

Example: country_risk_matrix.csv

CSV Structure

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

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

Country (Required)

Full country name

Full country name

Text field

Text field

Example: "United States of America"

Example: "United States of America"

Country Short (Required)

ISO country code or abbreviated name

ISO country code or abbreviated name

Text field

Text field

Example: "USA"

Example: "USA"

Score (Required)

Numerical risk score

Numerical risk score

Float/decimal number

Float/decimal number

No thousands separators

No thousands separators

Example: 1234.5

Example: 1234.5

Data Format Rules

Country Names:

• Use official country names

• Maintain consistent capitalization

• No leading/trailing spaces

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

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

Decimal numbers allowed

Use period (.) as decimal separator

No thousands separators

Valid range: 0-9999

Example CSV Content

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

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

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

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

Open in a text editor to verify formatting

Check for consistent line endings

Validate UTF-8 encoding

Confirm all required columns are present

Table of contents