How to export your data from Ondorse?
Last updated: November 28, 2025
The Export feature lets you download all your application data (also called cases) into a single Excel (.xlsx) file. This export gives you a complete, structured view of applications, related entities, and associated documents—useful for audits, reporting, reconciliation, and offline analysis.
You can find the export interface by clicking your name in the bottom left, accessing Settings > Import / Export and navigating to the tab Export.
Your export file contains four tabs:
1. applications
2. related_persons
3. related_businesses
4. documents
Each tab presents specific information about your cases. Below is a detailed explanation of what you’ll find in each one.
Applications tab
This tab includes all core information about each application in your account.
Basic application information
account_id – Your account’s identifier
id – Unique application ID (e.g., AN1234)
application_external_reference – Your internal reference
application_type –
person(KYC) orbusiness(KYB)
Main Entity Information
Depending on the application type, the corresponding entity fields are populated.
For KYB (business)
business_id
plus built-in business fields such as: name, country, registration_number, legal_type, registration_date, VAT number, phone number, IBAN, and closure information.
For KYC (person)
person_id
plus canonical person fields such as: given names, last name, email, nationalities, phone number, gender, birth details, PEP status, and account access.
Address Information
Depending on how data was entered or imported, address data may appear in either single-line or multi-line formats:
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 fields as above, prefixed with trading_.
Custom Fields
Any custom fields configured on your account appear with the prefix:
custom_field.<field_name>
Examples:
custom_field.has_hq_in_belgiumcustom_field.emea_business_unit
Compliance & risk Information
Includes the most recent risk assessment:
risk_level – UNSET, LOW, MEDIUM, HIGH, or FORBIDDEN
risk_score
decision_last_refreshed_at
decision_next_refresh_at
onboarding_date
Portal information
Information about the 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)
Overview of related entities (excluding the main business itself):
related_party_count
related_person_count
related_business_count
ubo_count
shareholder_count
director_count
account_owner_count
Risk Rules
Risk rule columns appear at the end in the format:
[Risk] <Rule Name> (<Rule ID>)
Each contains the score produced by that rule during the most recent evaluation.
Empty cells mean the rule did not run for the application.
Related persons tab
This tab lists all non-primary persons associated with your applications (e.g., directors, UBOs, signatories).
Basic person information
Includes account_id, application_id, person_id, and personal details (names, email, nationalities, PEP status, etc.).
Address Information
Same structure as in the Applications tab.
Relationship with the Application
Filed only if the person is directly linked to the application:
roles – DIRECTOR, SIGNATORY, SHAREHOLDER, UBO
direct_ownership_percentage
appointed_on
Relationships with other entities
The other_relationships field lists additional links (in JSON format) to other entities within the application structure.
Custom fields
Same logic as in the Applications tab.
Related businesses tab
This tab contains data about related businesses that are not the main business of the application.
Basic business information
Includes identification and core business fields (name, country, registration number, legal type, registration date, VAT number, phone number, IBAN, cessation details, etc.).
Address information
Same structure as other tabs.
Trading address
Same fields, prefixed with trading_.
Relationship with the application
Filed only if the business is directly linked:
- roles – DIRECTOR, SIGNATORY, SHAREHOLDER
- direct_ownership_percentage
- appointed_on
Relationships with other entities
Listed under other_relationships (JSON format), excluding the direct relationship with the application.
## Custom Fields
Configured per account.
Documents Tab
This tab lists all documents associated with applications or related entities.
Note: The export does not include the document files—only the metadata. To get the files, reach out to the 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 entity information
The document is either attached to an application, a person or a business. Depending on this, these columns will be filled:
application_id + external reference
person_id + external reference (if applicable)
business_id (if applicable)
Links
document_details_url – Opens the document details page in Ondorse (not a download link)
Additional Notes
Columns appear in the exact order shown in this guide.
Empty cells indicate missing or non-applicable data.
Lists (like nationalities or roles) appear as comma-separated values.
Dates are formatted to
YYYY-MM-DD hh:mm:ssfrom UTC timezone