# Import Excel with Image

{% hint style="info" %}
Excel with the Image Import feature is available in the **Scale** plan only. Feel free to contact us if you want to try it out!
{% endhint %}

### How do I enable Image upload in Import?

The first step for image import is to add or update a column with the `Image` type. In case providing [runtime-schema](https://docs.impler.io/features/runtime-schema "mention") keep column type as `Image` and importer will be ready to import images.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2Fwqz2jC7veUTxwmlb690i%2Fimage.png?alt=media&#x26;token=6837c68b-5b7a-436c-a203-56fd312c3775" alt=""><figcaption><p>Add Column with Type Image</p></figcaption></figure>

### How does Image Import work?

Once the import is configured to import data with Image. We can start importing data with Images. Here is the image import flow,

#### 1. Generate a Template with Images,

The first step is to upload all images and generate a template with uploaded image names. All columns with the type Image will appear in `Select Column` dropdown and Uploaded images will be shown below `Upload Image` section.

Once all image files are selected, click on `Generate Template` to generate an Excel file holding the names of all uploaded images.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FKuBXd8fj5ydxD3M8AsmG%2Fimage.png?alt=media&#x26;token=cbfd7c8b-778d-4a17-9a04-a38229421001" alt=""><figcaption><p>Upload Images and Generate Template</p></figcaption></figure>

#### 2. Upload Excel with data and image names.

Clicking on Generate Template will download an Excel file and Importer will move to the Upload section. You can enter data in the downloaded Excel file and select image names for image columns.

It's possible to generate a template again by clicking on `Generate Template`.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FLB6Ff35gnGdC9EWOv8DE%2Fimage.png?alt=media&#x26;token=ea46b05a-845a-46e1-ac4b-c82dc4bc4c69" alt=""><figcaption><p>Upload data file with image cell values</p></figcaption></figure>

Once selected click on `Map Columns`.

#### 3. Do mapping for columns

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FtQQanwm1jExDwjm0TENt%2Fimage.png?alt=media&#x26;token=d328a79d-3be6-4e44-9e78-2dfa6e56562b" alt=""><figcaption><p>Do and verify mapping for columns</p></figcaption></figure>

Click on `Review Data` to verify data getting imported.

#### 4. Review Data

The review step checks if image columns contain the name of the uploaded image. If not shows a validation error.

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FA0X1SxatXVxEbMy2D943%2Fimage.png?alt=media&#x26;token=5bcbd60f-87e4-46bf-ab5b-b0f5d2211549" alt=""><figcaption><p>Review data getting imported</p></figcaption></figure>

Click on `Re-Review Data` to complete the import, once all records are valid.

#### 5. Complete Import

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FY7p044VTArwdpHXDLmo4%2Fimage.png?alt=media&#x26;token=6ef67d19-9200-4064-b168-d58a47637e81" alt=""><figcaption><p>Data Imported Confirmation</p></figcaption></figure>

#### 6. Get Imported Data

Imported data will be sent to a webhook with an endpoint to download and access the uploaded file. &#x20;

<figure><img src="https://3446432046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdcNtx1PbzBQcufHhuySW%2Fuploads%2FKAlKqsClTnN4j0xJsjjP%2Fimage.png?alt=media&#x26;token=b564e606-9b5b-40c3-8e2d-b6e0d28d8cd0" alt=""><figcaption><p>Import Webhook Response</p></figcaption></figure>

#### 7. Download or Access the uploaded file

The download file endpoint is secured using `accesskey` which is available in `Settings` section on the left side. Here is the CURL for a review,

{% code overflow="wrap" %}

```
curl --location --request GET 'https://api.impler.io/v1/upload/66b759d087a854c817cd3e98/asset/logo-icon.png' \
--header 'accesskey: <ACCESS_TOKEN>'
```

{% endcode %}

***

If you have any questions, suggestions, or comments. Feel free to reach out to us over [**Discord**](https://discord.impler.io). We’re constantly improving to deliver the best Data Importer for your product, and we value your input.