---
title: "Data import: Importing contact data"
description: "A comprehensive guide to importing contact data, which links individuals to companies already in the system, ensuring an accurate database for communication."
url: https://help.qargo.com/us/articles/410121-data-import-importing-contact-data
locale: us
updated: 2025-12-12
---

# Data import: Importing contact data

Importing contact data is the logical next step after companies have been added to a Qargo tenant. This process allows bulk creation of individuals linked to specific companies. It keeps the database complete and accurate for order management and communication. This article outlines the specific requirements, best practices and common issues related to importing contact data.

* * *

## 📖 Key terminology {#h_c1d84be2fd}

The following terms are defined for clarity throughout this guide.

-   **Contact:** An individual associated with a company record, typically used for communication about orders, billing or operations.
-   **Company name:** The name of the company a contact is linked to. This must exactly match a company already in the Qargo system.
-   **Company accounting code:** A unique identifier from an external system, used to link an individual to the correct company.
-   **Role:** A field that specifies the purpose or job function of a contact (e.g., 'Dispatcher').


* * *

## ✅ Critical import requirements for contacts {#h_de9189acdf}

Before importing contact data, consider the following requirements and warnings to ensure data integrity.

-   **Company prerequisite:** A company record **must** already exist in the Qargo system before a contact can be imported and linked to it. The contact import will fail if the specified company record cannot be found.
-   **Unique company identification:** To link a contact successfully, the **Company name** and **Accounting code** in the contact template must exactly match the corresponding company record already in Qargo. If the **Accounting code** is empty, the system uses the **Company name** as a fallback.


* * *

## 🛠️ Step-by-step data import process {#h_2d3302eac1}

## Step 1: Download the template {#h_65115f2d35}

A specific spreadsheet template is available for uploading contact data. **To edit and upload the data, a copy of the template must be downloaded:**

1.  Click the link: [Contact data import template](https://docs.google.com/spreadsheets/d/15907ITZJPI-0yiFeqXq-7GIGyOzFAHckibeEkCPPsJI/edit?usp=sharing)
2.  Once the template opens, go to **File** and select **Download**
3.  Save the template **(in .xlsx or .csv format)** to a computer and begin entering the company data.

![Download the template from the File menu](https://help.qargo.com/media/4c743d534721-image.png)

:::callout{tone="info"}
📚 Always use a blank template downloaded directly from this article or provided by the Qargo team. Reusing an old template may lead to import errors.
:::

## Step 2: Fill in the Excel template {#h_8a140e9b53}

Open the template and fill it in with the required data. The template contains column headers that correspond to the fields in Qargo.

-   **Required fields:** Fill out all the required fields (a complete list of required fields is in the next section of this article). An import will fail if these fields are left blank.
-   **Formatting:** Pay close attention to the specified data format (e.g., dates, numbers, text).


## Step 3: Submit for upload {#h_4eb63368b2}

1.  **During onboarding:** Work directly with the **onboarding manager** to upload the initial business data. The onboarding manager guides the process and ensures a successful import.
2.  **After onboarding:** For all future data updates and imports, contact the **account manager**. The account manager assists with the upload process and provides ongoing support.


* * *

## 📝 Details of the contact import template {#h_68f0e1c045}

The following table gives a detailed, field-by-field explanation of the Excel template for contact import. It includes data formats, required fields and best practices for filling in each column.

| Column name | Required/optional | Remarks | Example |
| --- | --- | --- | --- |
| company\_name | Required | Customer name used in the application | Qargo |
| company\_accounting\_customer\_code | Required | Unique ID. It's 'accounting\_code' in the customer\_import | 134 |
| company\_is\_customer | Optional |  | TRUE or null |
| company\_is\_subcontractor | Optional |  | TRUE or null |
| name | Required | Name of the contact | Thomas Smith |
| email | Required | Email address of the contact | [thomas.smith@qargo.io](mailto:thomas.smith@qargo.io) |
| job\_title | Optional |  |  |
| has\_portal\_access | Optional | Gives a contact access to their company portal. | TRUE or null |
| note | Optional | Extra text information about the contact. This usually contains useful information that does not fit into one of the other categories described here. |  |
| phone | Optional |  | +324723372 |
| has\_role\_billing | Optional | To send invoices to this contact | TRUE or null |
| has\_role\_operations | Optional | To send operational documents such as transport orders or CMRs. | TRUE or null |
| has\_role\_cmr\_processing | Optional |  | TRUE or null |
| has\_role\_other | Optional | To use in individually created tasks. | TRUE or null |
| custom\_fields\_\_example | Optional | To import custom field values. Note: the format uses a double underscore (`__`) to connect the prefix **custom\_fields** to the unique field ID |  |

* * *

## 🔎 Troubleshooting common contact import errors {#h_38c7c05f77}

This section covers specific errors that may come up when importing contact data.

-   **Company record not found:** This is the most common error. It occurs when a contact's **Company name** or **Accounting code** does not exactly match an existing company in Qargo. All company details must be identical to an existing record.
-   **Missing mandatory fields:** The import will fail for any row where a mandatory field is left blank.
-   **Sheet name:** The sheet in the Excel template file must be named exactly **'Import'**. Any other name will cause an error when uploading the file.
-   **Phone number format:** The phone number should contain the country code followed by the number, without any spaces (e.g., **+3212345678**). In Excel/Google Sheets, set the column format to **Text** and add a ' before the country code and phone number in the formula cell (i.e., '**+3212345678)** so the phone number displays correctly**.** See the example below:

![Phone number entered with a leading apostrophe in a Text column](https://help.qargo.com/media/11e3a690c2da-image.png)

-   **Custom fields:** The column name must follow the convention **custom\_field\_\_\[ID\]** (keep the double underscore that connects the prefix **custom\_field** to the unique field ID). Retrieve the specific ID from the Qargo organization settings. Click the copy button next to the custom field to copy its ID:

![Copy button next to a custom field](https://help.qargo.com/media/e109fd7742ba-796a5c17-3b5e-4a0d-9642-08cfd8176cd4.png)

-   **Case-sensitive column headers:** Column headers must be entered with the correct casing (e.g., `vat_number`, not `VAT_number`). With incorrect casing, the system does not recognize the header, so the data in that column is silently ignored and not imported.
-   **Leading apostrophe errors:** Data in a cell cannot begin with an apostrophe ('). If an apostrophe is used, the system will not recognize the value, and an error may occur. **This rule does not apply only if the article explicitly states that an apostrophe should be used for a specific field.**

* * *

## ✨ Best practices for importing contacts {#h_4d53ccbaf9}

Consider the following best practices for a smooth and accurate import.

-   **Make sure company data is complete:** Before importing contacts, verify that all associated companies have already been imported into the system.
-   **Keep data consistent:** Pay close attention to the **Company name** and **Accounting code** fields in the contact template. Any spelling mistakes, extra spaces or different capitalization will cause the link to fail.


* * *

## ➡️ What to do next {#h_488069e161}

Once contacts have been imported, the system is ready for order creation and communication. The next logical steps include:

-   **Importing drivers:** If required, internal or contract carrier drivers can now be imported.
-   **Importing vehicles:** The vehicle fleet can be populated by importing vehicles owned by the company or its contract carriers.


* * *

## 📈 Use cases for contact import {#h_a3db18ccae}

Importing contact data is a valuable tool for several key business processes.

-   **Initial tenant setup:** After companies are imported, contacts can be added in bulk to populate the system and make it ready for operational use.
-   **Adding contacts to existing companies:** For companies already in the system, this is a quick and efficient way to add multiple new contacts at once.


## Related articles

- [Data import: Importing driver data](https://help.qargo.com/us/articles/410123-data-import-importing-driver-data.md)
- [Data import – importing company data](https://help.qargo.com/us/articles/410118-data-import-importing-company-data.md)
- [Data import: importing container data](https://help.qargo.com/us/articles/410131-data-import-importing-container-data.md)
- [Data import – importing contact location data](https://help.qargo.com/us/articles/494334-data-import-importing-contact-location-data.md)
- [Data import: importing vehicle data](https://help.qargo.com/us/articles/410124-data-import-importing-vehicle-data.md)
