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
Go to Settings > Data > Import / export and open the Export tab.
In All cases, click Export.
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.
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.

What's in the file
The file has four sheets:
applications: one row per case
related_persons: persons linked to your cases
related_businesses: businesses linked to your cases
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) orbusiness(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 sheetRelationship 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:ssformat, in UTC.