--- title: Understanding Data Import Wizard and Data Loader description: "Based on your user's profile permissions, you have access to two tools for importing data into Kooltra: the Data Import Wizard and the Data Loader.  When importing records, you must map the columns i" --- [Skip to content](https://help.kooltra.com/knowledge-base/how-to-import-data#main-content) English Show submenu for translations [Customer portal](https://help.kooltra.com/client-portal?hsLang=en) ![Kooltra\_Logo\_Green\_Eggplant\_RGB-1](https://help.kooltra.com/hs-fs/hubfs/Kooltra_Logo_Green_Eggplant_RGB-1.webp?width=200&height=67&name=Kooltra_Logo_Green_Eggplant_RGB-1.webp) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://help.kooltra.com/client-portal) - [Go to Kooltra Platform](https://kooltracore.cloudforce.com/) [Go to Kooltra Platform](https://kooltracore.cloudforce.com/) Search the knowledge base - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://help.kooltra.com/knowledge-base?hsLang=en) 2. [Counterparty Management](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en) 3. [Data Importing](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#data-importing) # Understanding Data Import Wizard and Data Loader Based on your user's profile permissions, you have access to two tools for importing data into Kooltra: the Data Import Wizard and the Data Loader.  ### Data Import Wizard The Data Import Wizard is ideal for handling smaller files and supports standard and custom objects with simplified mapping options. For larger or more complex data imports, consider using tools like Data Loader. #### **Automated Data Mapping** #### The Data Import Wizard includes automatic data mapping that maps data from CSV files to the appropriate Object fields. If any mappings are missing or incorrect, you can manually edit them to ensure the data is imported correctly. ![](https://help.kooltra.com/hs-fs/hubfs/Screenshot%202024-12-04%20at%204-24-02%E2%80%AFPM-png.png?width=437&height=391&name=Screenshot%202024-12-04%20at%204-24-02%E2%80%AFPM-png.png) ### Data Loader  Kooltra uses Data Loader to insert and update data during the data loading process, especially for files containing large amounts of information. Data loader contains a number of key features: #### **Save Mappings** When importing records, you must map the columns in your CSV file to the corresponding fields in the object you're importing into. The Data Loader tool lets you save these mappings, so you can reuse them for future imports, making the process quicker and more consistent. #### **Set Batch Size** Data imports can be processed in batches, with a default batch size of **200 records**. If you encounter errors during the import process, especially those related to system limits, consider reducing the batch size and retrying. #### Recommended Batch Sizes by Object Type - **Accounts**: 200 records - **Contacts**: 50 records - **Beneficiary**:  200 records - **Nostro**: 50 records - **FxTrade**: 200 records - **Cashflow**: 50 records **Use External IDs** Importing data into lookup fields can be challenging without using **external IDs**. Lookup fields require either a **Salesforce ID** or an **external ID**. To illustrate this challenge, consider the example below. The **Account** field on a contact record is a lookup field that connects the contact to its associated account. Should you choose to utilize Salesforce IDs to link the contact to the account record, the process involves multiple steps: 1. **Insert Account Records** You must first upload all account records into Salesforce. 2. **Retrieve Salesforce-Generated Account IDs** After the account records are created, you'll need to query Salesforce to get the system-generated Account IDs. 3. **Update the Contact Import File** Add these retrieved Account IDs into the contact import file to associate the correct contact with its account. This process introduces manual steps, making it tedious and error-prone. You can prevent this issue by using the **External ID** field. Since External IDs are predetermined, you can establish the connections between records during the extraction and transformation process. This allows the records to be imported in the correct order. #### **![](https://help.kooltra.com/hs-fs/hubfs/image-png-Dec-04-2024-09-44-05-1769-PM.png?width=688&height=219&name=image-png-Dec-04-2024-09-44-05-1769-PM.png)** - [Getting started](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#main-content) - [Kooltra Access](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#kooltra-access) - [Knowledge Resources](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#knowledge-resources) - [Entity Setup](https://help.kooltra.com/knowledge-base/getting-started?hsLang=en#entity-setup) - [Client Journey at a Glance](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#main-content) - [Onboarding and Client Setup](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#onboarding-and-client-setup) - [Trading and Settlements](https://help.kooltra.com/knowledge-base/client-journey-at-a-glance?hsLang=en#trading-and-settlements) - [Counterparty Management](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#main-content) - [Counterparty Setup & Management](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#counterparty-setup-management) - [Counterparty Overview](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#counterparty-overview) - [Beneficiaries](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#beneficiaries) - [Data Importing](https://help.kooltra.com/knowledge-base/counterparty-management?hsLang=en#data-importing) - [Trading & Trade Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#main-content) - [Trade Creation & Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-creation-management) - [Spread Groups](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#spread-groups) - [Trade Blotters](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-blotters) - [Trade Matching](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#trade-matching) - [Order Creation & Management](https://help.kooltra.com/knowledge-base/trading-trade-management?hsLang=en#order-creation-management) - [Cash Management](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#main-content) - [Cashflows & Adjustments](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#cashflows-adjustments) - [Account Balances](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#account-balances) - [Settlements](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#settlements) - [Reconciliation](https://help.kooltra.com/knowledge-base/cash-management?hsLang=en#reconciliation) - [Reporting](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#main-content) - [Custom Reports](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#custom-reports) - [Confirmations & Documentation](https://help.kooltra.com/knowledge-base/reporting?hsLang=en#confirmations-documentation) - [Compliance](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#main-content) - [Regulatory Reporting](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#regulatory-reporting) - [Client Onboarding & KYC](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#client-onboarding-kyc) - [Transaction Risk Monitoring](https://help.kooltra.com/knowledge-base/compliance?hsLang=en#transaction-risk-monitoring) - [Risk Management](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#main-content) - [Client Margin](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#client-margin) - [Trading Limits](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#trading-limits) - [Credit Engine](https://help.kooltra.com/knowledge-base/risk-management?hsLang=en#credit-engine) - [Payments Portal](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#main-content) - [Trading & Cash Management](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#trading-cash-management) - [Beneficiaries](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#beneficiaries) - [Dealer Intervention](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#dealer-intervention) - [Blotters & Reports](https://help.kooltra.com/knowledge-base/payments-portal?hsLang=en#blotters-reports) [![Kooltra\_Logo\_Green\_Eggplant\_RGB-1](https://help.kooltra.com/hs-fs/hubfs/Kooltra_Logo_Green_Eggplant_RGB-1.webp?width=200&height=67&name=Kooltra_Logo_Green_Eggplant_RGB-1.webp "Kooltra_Logo_Green_Eggplant_RGB-1")](https://help.kooltra.com/?hsLang=en) kooltra.com Help Center Copyright © 2026, Kooltra, Ltd