---
title: "Importing Data Automatically"
description: "Automatic data imports allow you to import contracts, lessors and contract components automatically. This both simplifies the import process and saves you time."
source_url: https://support.lucanet.com/en/documentation/lease-accounting/data-collection/automatic-data-import
language: en
last_updated: 2026-05-01
---
# Importing Data Automatically

## Overview

Automatic data imports allow you to import contracts, lessors and contract components automatically. This both simplifies the import process and saves you time.

## The ‘Automatic Data Import’ Workspace

The **Automatic data import** workspace displays all the data import runs that have been executed to date, regardless of which reporting entity is selected:

![Displays the 'Automatic data import' workspace](https://support.lucanet.com/assets/docs-images/lease-accounting/data-collection/automatic-data-import/_images/en/automatic-data-import-main-page.png)
The 'Automatic data import' workspace

## Importing Data Automatically

To import data, proceed as follows:

1. Open the **Automatic data import** workspace:

    ![Importing data automatically](https://support.lucanet.com/assets/docs-images/lease-accounting/data-collection/automatic-data-import/_images/en/automatic-data-import-main-page.png)
    Importing data automatically

2. Select the **data to be imported**. The following data types can be imported:

       - **Lessors**
       - **Contracts**
       - **Contract components**

3. Use **drag and drop** to attach the **Excel** or **CSV file** you want to import, or add it via the **Browse** function.

4. Click **Start import**.
> **Tip:** **Excel and CSV Import Templates**
>
> To make automatic imports easier for you, we provide templates for both **Excel** and **CSV** files. The structure of these templates matches that required for the import.
>
> The templates include instructions on how to add the data.
>
> Use the following links to download the templates:
>
> **Excel Templates:**
>
> - [Excel Template for Lessor Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQCnJUMt8TaHQJhdewJgo_TsAb8JuUOBXODBT6OOEM2_BNY?e=EI71U5)
> - [Excel Template for Contract Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQApJ5XhiV6pTaHr1SIvRo56ATOX5wTphtJfsPsjSIb94JM?e=gDmxMk)
> - [Excel Template for Contract Component Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQBHNlo_-CUNTZB_V4fS2xX8AYKjSpJCCaV9FrQRkCjkm18?e=vElVRu): this template uses conditional formatting to help you keep your entries within the allowed length. If you enter more than 250 characters in a cell, that cell turns red. Reduce the number of characters before you start the import.
>
> **CSV Templates:**
>
> - [CSV Template for Lessor Imports](https://lnag.sharepoint.com/:x:/s/hubkm/EW5Dq-ZgJa9ItacvIJe8LWgB-kEQVJs-vIoN65A3YiOHJw?e=eVzXt1)
> - [CSV Template for Contract Imports](https://lnag.sharepoint.com/:x:/s/hubkm/EfIU3mB0GSxCrZIUbohuG-IBgdNaejtTwKjbgTV6v6wirA?e=OuhTOB)
> - [CSV Template for Contract Component Imports](https://lnag.sharepoint.com/:x:/s/hubkm/IQAApa9b5yOHQb6ZNbHXtMILAVA8o5568v-C39ro_efqYhA?e=zXA91A)

## Data Import Details

The following details are displayed in the overview table for each data import:

![The 'Automatic data import' workspace is displayed. The overview table is outlined in red.](https://support.lucanet.com/assets/docs-images/lease-accounting/data-collection/automatic-data-import/_images/en/automated-import-chart.png)
Overview table in the 'Automatic Data Import' workspace

The table provides the following information:

| Column | Description |
|---------|---------|
| ID | Import ID |
| Date | Date of the import run |
| User name | Name of the user who executed the import |
| Reporting entity OID | OID of the reporting entity (lessee) for whom the import run was executed |
| File name | Name of the imported file |
| File size | Size of the imported file in KB |
| Import mode | The imported file type. This is always CSV. |
| Import type | The data type that was imported. The following options are displayed:<br>• **StandardExternalParter** for importing **lessors**<br>• **LucanetContract** for importing **contracts**<br>• **LucanetComponent** for importing **contract components** |
| Status | Status of the import. The following options are displayed:<br>• **Success** if the import was completed successfully<br>• **Error** if an error occurred during the import run<br>• **Warning** if a warning was issued during the import run<br>• **Info** if the message is only a notice on the import’s execution status<br>• **TBD** if the import run is still ongoing and it is not yet possible to display a status for it<br><br>**Note:**<br>• You can view the details of the **individual messages** in the [Import History](https://support.lucanet.com/en/documentation/lease-accounting/data-collection/show-import-history.md).<br>• To jump straight to the history of a specific import, click the eye icon in the configuration column icon column. |
| Number of imported lessors | Number of lessors imported successfully during the import run |
| Number of imported contracts | Number of contracts imported successfully during the import run |
| Number of imported components | Number of contract components imported successfully during the import run |
| Number of issues | Number of issues and warnings output during an import that was not executed successfully<br><br>**Note:**<br>• To view the **notes** for imports that were **not executed successfully**, visit the [Import History](https://support.lucanet.com/en/documentation/lease-accounting/data-collection/show-import-history.md).<br>• To jump straight to the history of a specific import, click the eye icon in the configuration column icon column. |
| Configuration column the configuration column icon | To jump straight to the history of a specific import, click the eye icon. |