How to export your data from Ondorse?

Last updated: November 9, 2026

Export all your cases into a single Excel (.xlsx) file: cases, related persons, related businesses and document information. Use it for audits, reporting, reconciliation or offline analysis.

Run an export

  1. Go to Settings > Data > Import / export and open the Export tab.

  2. In All cases, click Export.

  3. Your export is prepared in the background. You get an email when it's ready. It can take up to 20 minutes, depending on how much data you have.

  4. Come back to the Export tab and click Download now on the latest Download link. Previous exports stay listed with their date and time.

If you see Export failed due to an unexpected error, run the export again later. If it keeps failing, contact support.

Export all cases

What's in the file

The file has four sheets:

  1. applications: one row per case

  2. related_persons: persons linked to your cases

  3. related_businesses: businesses linked to your cases

  4. documents: document information

Some column names still use "application", which means "case".

applications sheet

Case information

  • account_id: your account's identifier

  • id: unique case ID (e.g. AN1234)

  • application_external_reference: your internal reference

  • application_type: person (KYC) or business (KYB)

Main entity

Filled according to the case type:

  • Business cases (KYB): business_id, plus business fields such as name, country, registration_number, legal_type, registration_date, VAT number, phone number, IBAN and closure information.

  • Person cases (KYC): person_id, plus person fields such as given names, last name, email, nationalities, phone number, gender, birth details, PEP status and account access.

Address

Depending on how the data was entered or imported, the address is in a single line or split into several columns: address_country, address_single_line, address_line_1, address_line_2, address_building_number, address_street, address_town, address_state, address_postcode.

Trading address (KYB only): same columns, prefixed with trading_.

Custom fields: one column per custom field on your account, named custom_field.<field_name> (e.g. custom_field.emea_business_unit).

Compliance and risk (latest assessment)

  • risk_level: UNSET, LOW, MEDIUM, HIGH or FORBIDDEN

  • risk_score

  • decision_last_refreshed_at

  • decision_next_refresh_at

  • onboarding_date

Portal (latest portal request)

  • last_portal_request_status

  • last_portal_request_created_at

  • last_portal_request_closed_at

  • portal_url

  • portal_contact_email_address

Assignee: assignee_user_email, assignee_user_fullname

Relationship counts (KYB only), not counting the main business itself: related_party_count, related_person_count, related_business_count, ubo_count, shareholder_count, director_count, account_owner_count

Risk rules: the last columns, one per rule, named [Risk] <Rule Name> (<Rule ID>). Each holds the score the rule gave at the latest evaluation. An empty cell means the rule didn't run for that case.

related_persons sheet

Lists every person linked to your cases other than the main person (e.g. directors, UBOs, signatories).

  • Person information: account_id, application_id, person_id, and personal details (names, email, nationalities, PEP status, etc.)

  • Address: same columns as the applications sheet

  • Relationship with the case, filled only if the person is directly linked to the case: roles (DIRECTOR, SIGNATORY, SHAREHOLDER, UBO), direct_ownership_percentage, appointed_on

  • other_relationships: other links to entities in the case structure, in JSON

  • Custom fields: same logic as the applications sheet

related_businesses sheet

Lists every business linked to your cases other than the main business.

  • Business information: identification and business fields (name, country, registration number, legal type, registration date, VAT number, phone number, IBAN, closure details, etc.)

  • Address and trading address (prefixed with trading_): same columns as the applications sheet

  • Relationship with the case, filled only if the business is directly linked to the case: roles (DIRECTOR, SIGNATORY, SHAREHOLDER), direct_ownership_percentage, appointed_on

  • other_relationships: other links in the case structure, in JSON, excluding the direct relationship with the case

  • Custom fields: same logic as the applications sheet

documents sheet

Lists every document attached to your cases, persons or businesses. The export contains document information only, not the files. To get the files, contact support.

  • Document information: account_id, document_id, external_reference, document_name, document_type, issuing_country, expiry_date, validity (unset / valid / invalid), document_invalidation_motive_code

  • Attached to: application_id and its external reference, person_id and its external reference (if any), business_id (if any)

  • document_details_url: opens the document page in Ondorse (not a download link)

Good to know

  • Columns appear in the order shown in this article.

  • An empty cell means the data is missing or doesn't apply.

  • Lists (e.g. nationalities, roles) are comma-separated.

  • Dates use the YYYY-MM-DD hh:mm:ss format, in UTC.