# Uploading Images

#### Introduction

Tablomat contains a bulk image upload tool, to make it easier to upload and add a large number of images to a spreadsheet. This article will showcase this tool through a hands-on tutorial.

We'll be using the following spreadsheet and image directory. Please download both.

{% file src="/files/nFznJdekCSkm0rIulhfH" %}

{% file src="/files/le92hiIJR8PEc3eb0weQ" %}

#### Tutorial

First, open the file `mini-catalog.csv` in Tablomat (shown below).

<figure><img src="https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTDwmfyeZRuajecSvhNn5%2Fuploads%2FOVD1IChLsBvcQ48DIAlA%2Fimage.png?alt=media&#x26;token=69c80484-fb14-4c34-b47b-9ebbced05c73" alt=""><figcaption></figcaption></figure>

The sheet contains a simple product catalog. We'll be using the Image Upload tool to upload all the images in the supplied image directory, and insert them into the appropriate cells of the column `Image Src`.

The Image Upload tool can be accessed by clicking the ellipsis icon (![](/files/n2WayLBU7WDYfAPCEzgb)) at the right side of the toolbar then "Upload Images". This will bring up the tool's panel.

Drag the image directory to the drop zone, and fill the remaining fields of the panel as follows ...

<figure><img src="/files/hZvHSRPCbxfhVzHV93ww" alt=""><figcaption></figcaption></figure>

Now click "Upload" to start uploading.

Once complete, the spreadsheet should look like this ...

<figure><img src="/files/z4FiCmWvFAzpq0Jj2TW5" alt=""><figcaption></figcaption></figure>

#### Image Upload Options

The upload panel requires the following inputs:

1. "Add to Column": a selected column to insert images into (must be of type `Files`).
2. "Match filename to column": a selected column whose values are matched against images, to determine at which row each image should be inserted (see "How Matching Works" below).
3. "When cell has existing attachments": the behavior of the image upload tool when attempting to insert images to a cell that has existing images.

#### How Uploading Works

Images are uploaded to Tablomat's Content Delivery Network (CDN), and their URLs are inserted inside cells.

Since cells of the "Add to Column" are of type `Files`, the URLs are rendered as image previews. You can inspect the underlying URLs by double-clicking any cell to enter editing more.

#### How Matching Works

The Image Upload tool decides where to insert each image based on its filename and parent sub-directories. These are taken as "keywords" and compared to each value of the column under "Match Filename to Column" (the comparison is case insensitive).

For example, in the tutorial above, the image ...

```
./mens/mens-1977-knit-hoodie-in-dark-oatmeal/Mens_1977_KnitHoodieinDarkOatmeal-1.jpg
```

has the following keywords ...

1. `mens` (parent directory 1)
2. `mens-1977-knit-hoodie-in-dark-oatmeal` (parent directory 2)
3. `Mens_1977_KnitHoodieinDarkOatmeal-1` (filename)

and the second keyword matches the `Handle` value on row 8. The image was this inserted in the `Image Src` cell of row 8.

Because of the flexibility of Image Upload tool, uploaded images can be organized in any hierarchy, and matched to any column on the sheet.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tablomat.com/learn/uploading-images.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
