# Data Import Setup

The Data Import Setup feature allows you to configure fields for importing data from Excel and specify whether to perform an Insert or Upsert operation. You can choose to either insert new records or update existing records while adding new ones (Upsert). This functionality streamlines the process of adding large datasets efficiently.

{% hint style="warning" %}
For Upsert operations, you must specify a unique key field to identify records.
{% endhint %}

***

### :small\_orange\_diamond: Steps to Configure Data Import

1\. In the **Default Setup** screen, activate the **Allow Import** toggle button.

<figure><img src="https://3800415611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNuSjRiJMvVhtdzNDzWBi%2Fuploads%2FbLWLB3zkD9oKOzA5CmTu%2Fimage.png?alt=media&#x26;token=3007503c-de71-4919-9283-f5ac3ebea149" alt="" width="337"><figcaption><p>Default Setup</p></figcaption></figure>

2\. In the import settings screen, choose **Insert** or **Upsert**. For Upsert, specify a unique key field to identify records.

<figure><img src="https://3800415611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNuSjRiJMvVhtdzNDzWBi%2Fuploads%2FU1Z4o0WsBxkh8RtXwNe6%2Fimage.png?alt=media&#x26;token=424c176f-bfd4-4b91-b6d0-edcea4d35289" alt="" width="338"><figcaption><p>Import Setup</p></figcaption></figure>

3\. In the field selection screen, choose the fields to be imported from Excel and click the Add button.

<figure><img src="https://3800415611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNuSjRiJMvVhtdzNDzWBi%2Fuploads%2FGKozJ893DiFgU7Dv1dGq%2Fimage.png?alt=media&#x26;token=31a751e6-c6be-4cb9-8f05-699e33f8ef9c" alt=""><figcaption><p>Add Fields Modal</p></figcaption></figure>

4\. Verify in the import settings screen that the selected fields have been added correctly.

<figure><img src="https://3800415611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNuSjRiJMvVhtdzNDzWBi%2Fuploads%2FgPqW8mlZNJd5ldnFdwCe%2Fimage.png?alt=media&#x26;token=b298466b-4b48-4da5-9ab4-840e8d89f268" alt="" width="333"><figcaption><p>Added fields</p></figcaption></figure>
