---
title: How to prepare case importing files
description: Everything you need to know to start using Pascal Screening.
---

[Skip to content](https://help.vartion.com/how-to-prepare-case-importing-files#main-content)

English

Show submenu for translations

[Customer portal](https://portal.vartion.com/tickets-view?hsLang=en)

[![pascal\_logo.png\]](https://help.vartion.com/hs-fs/hubfs/pascal_logo.png?width=160&height=42&name=pascal_logo.png)](https://help.vartion.com/?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://portal.vartion.com/tickets-view)
- [Go to Pascal](https://pascal.vartion.com/)

[Go to Pascal](https://pascal.vartion.com/)

 How can we help?

- There are no suggestions because the search field is empty.

1. [Product Documentation](https://help.vartion.com/?hsLang=en)
2. [Screening](https://help.vartion.com/screening?hsLang=en)
3. [Getting Started with Pascal Screening](https://help.vartion.com/screening?hsLang=en#getting-started-with-pascal-screening)

# How to prepare case importing files

Cases in Pascal can be imported in CSV, XLSX and JSON file formats.

The import file can be up to 10 MB in size or contain a maximum of 5,000 rows.

### Case fields to fill

Pascal consists of **Person**, **Business** and **Asset** cases. Each case has a set of common fields (case type, confidence, assignee, description, client), that makes it easier for Pascal to identify and organise them in the system. Each of these fields is described below.

 

#### Generic fields:

- **type** - **Person**, **Business** or **Asset**. This indicates what type of case you like to register on that line. This column should be filled in for all case types, as this field is mandatory.
- **confidence** - **Relative** or **Exact**. This tells Pascal if the case should be searched relative or exact. The default value is **Relative** if this field is not filled in.
- **assignee** - email address of a user in your Pascal environment. This column should be filled in for all case types. If no email address is provided, Pascal will leave the case unassigned or use the default assignee if configured in the **Screening Policies** settings.
- **clients\_1** - name of the client you want the case to be a part of. This column can be filled in for all case types. (a second client can be added by creating a new column called **clients\_2**. If more clients should be added to a case, the column **clients\_3** can be added and so on).
- **description** - any additional relevant information or notes about the case. This information is not included in the screening of the case.

There are also fields that identify the entity with various kinds of descriptive information. **Person**, **Business** and **Asset** cases do not have all the same input fields.

- Person check related fields: 
    - **name** - any name input, up to a maximum of 255 characters. This will be the name of the case added to Pascal. This column should be filled in as this field is mandatory.
    - **aliases\_1** - name of the alias you want to add to the case. This column can be filled in for all case types. (a second alias can be added by creating a new column called **aliases\_2** and the same works for more aliases)
    - **nationalities\_1** - any country name, in ISO\_3166 format. (a second nationality can be added by creating a new column called **nationalities\_2** and the same works for more nationalities)
    - **country\_of\_birth** - any country name, in ISO\_3166 format.
    - **country\_of\_residence** - any country name, in ISO\_3166 format.
    - **date\_of\_birth** - date in the format of YYYY-MM-DD, DD-MM-YYYY or MM-DD-YYYY. This format should be consistent for all cases in the CSV file.
    - **gender** - **Male** or **Female**.
    - **additional\_terms\_1** - name of the additional term you want to add to the case. This column can be filled in for all case types. (a second additional term can be added by creating a new column called **additional\_terms\_2** and the same works for more additional terms). The field refers to a keyword or a phrase, that may link the entity.

- Business check related fields: 
    - **name** - any name input, up to a maximum of 255 characters. This will be the name of the case added to Pascal. This column should be filled in as this field is mandatory.
    - **aliases\_1** - name of the alias you want to add to the case. This column can be filled in for all case types. (a second alias can be added by creating a new column called **aliases\_2** and the same goes for more aliases)
    - **country** - any country name, in ISO\_3166 format.
    - **company\_number** - any text input, up to a maximum of 190 characters.
    - **address** - any input up to a maximum of 190 characters.
    - **additional\_terms\_1** - name of the additional term you want to add to the case. This column can be filled in for all case types. (a second additional term can be added by creating a new column called **additional\_terms\_2** and the same goes for more additional terms). The field refers to a keyword or a phrase, that may link the entity.

- Asset check related fields: 
    - **name** - any name input, up to a maximum of 255 characters. This will be the name of the case added to Pascal. This column should be filled in as this field is mandatory.
    - **aliases\_1** - name of the alias you want to add to the case. This column can be filled in for all case types. (a second alias can be added by creating a new column called **aliases\_2** and the same works for more aliases)
    - **nationalities\_1** - any country name, in ISO\_3166 format. (a second nationality can be added by creating a new column called **nationalities\_2** and the same works for more nationalities)
    - **asset\_type** - **aircraft,** **vessel** and, **cryptowallet**.
    - **identifier** - the identifier of the asset.
    - **additional\_terms\_1** - name of the additional term you want to add to the case. This column can be filled in for all case types. (a second additional term can be added by creating a new column called **additional\_terms\_2** and the same goes for more additional terms). The field refers to a keyword or a phrase, that may link the entity.

 

### Preparing a CSV file

Use the CSV template file that you can download from the **Import cases** dialog in the **Cases** page. The easiest way to edit the CSV file is in a plain text editor, like notepad, or Excel.

To open a CSV file in Excel, the following steps should be followed:  

1. Open a new Excel document.
2. Navigate to the **Data** tab.
3. Click on **From Text/CSV**.
4. Navigate to the CSV file you would like to open and open it.
5. Click on **Transform Data**.
6. Under the tab **Transform** select **User First Row as Headers** if the column names are displayed as **Column1**, **Column2**, **Column3**, etc. If the column headers are already **type**, **confidence**, **name**, etc., this step should be skipped.
7. Select the **File** tab in the left upper corner and click on **Close and Load**.

Excel should now have opened the CSV file correctly, with the correct headers. After completing the file, the file should be saved as the file type **CSV UTF-8(\*.csv)** (or another suitable CSV file format) and named like **import\_cases.csv** for example.

When editing a CSV file in a plain text editor, it is important to check that every value is separated with a comma. After completion, the file should be saved as a CSV file, for example **import\_cases.csv**.

 

 

**This documentation, including images, videos and text, is accurate as of Version 7.18 of Pascal.**

We strive to keep our documentation up to date with each release to ensure it remains a reliable resource for our users. However, given the dynamic nature of our software development, there might be instances where changes introduced in subsequent versions are not immediately reflected in this documentation. We encourage users to refer to [the latest release notes](https://help.vartion.com/knowledge/general?hsLang=en#release-notes) and to use the feedback mechanism for any discrepancies or requests for clarification.

 

- [General](https://help.vartion.com/general?hsLang=en#main-content)

    - [Release Notes](https://help.vartion.com/general?hsLang=en#release-notes)
    - [What's New](https://help.vartion.com/general?hsLang=en#whats-new)
    - [Risk Classification Settings](https://help.vartion.com/general?hsLang=en#risk-classification-settings)
    - [HubSpot](https://help.vartion.com/general?hsLang=en#hubspot)
    - [User Account Settings](https://help.vartion.com/general?hsLang=en#user-account-settings)
    - [General](https://help.vartion.com/general?hsLang=en#general)
    - [Billing](https://help.vartion.com/general?hsLang=en#billing)
    - [Organisation Settings](https://help.vartion.com/general?hsLang=en#organisation-settings)
    - [Integrations](https://help.vartion.com/general?hsLang=en#integrations)
    - [Zapier](https://help.vartion.com/general?hsLang=en#zapier)
- [Screening](https://help.vartion.com/screening?hsLang=en#main-content)

    - [FAQ](https://help.vartion.com/screening?hsLang=en#faq)
    - [Cases](https://help.vartion.com/screening?hsLang=en#cases)
    - [Clients](https://help.vartion.com/screening?hsLang=en#clients)
    - [Statistics](https://help.vartion.com/screening?hsLang=en#statistics)
    - [Getting Started with Pascal Screening](https://help.vartion.com/screening?hsLang=en#getting-started-with-pascal-screening)
    - [Results in Pascal](https://help.vartion.com/screening?hsLang=en#results-in-pascal)
    - [Notifications in Pascal Screening](https://help.vartion.com/screening?hsLang=en#notifications-in-pascal-screening)
    - [Screening Settings](https://help.vartion.com/screening?hsLang=en#screening-settings)
- [Onboarding](https://help.vartion.com/onboarding?hsLang=en#main-content)

    - [Getting Started with Pascal Onboarding](https://help.vartion.com/onboarding?hsLang=en#getting-started-with-pascal-onboarding)
    - [Onboarding Settings](https://help.vartion.com/onboarding?hsLang=en#onboarding-settings)
    - [Clients](https://help.vartion.com/onboarding?hsLang=en#clients)
- [Transactions](https://help.vartion.com/transactions?hsLang=en#main-content)

    - [Getting Started with Pascal Transactions](https://help.vartion.com/transactions?hsLang=en#getting-started-with-pascal-transactions)
    - [Settings](https://help.vartion.com/transactions?hsLang=en#settings)

[![vartion\_logo@0,5x-1](https://help.vartion.com/hs-fs/hubfs/vartion_logo@0%2c5x-1.png?width=125&height=45&name=vartion_logo@0%2c5x-1.png "vartion_logo@0,5x-1")](https://vartion.com)

 

Copyright © 2025, Vartion B.V.