Uploading Images
Last updated
Last updated
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.
First, open the file mini-catalog.csv in Tablomat (shown below).
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.
Drag the image directory to the drop zone, and fill the remaining fields of the panel as follows ...
Now click "Upload" to start uploading.
Once complete, the spreadsheet should look like this ...
The upload panel requires the following inputs:
"Add to Column": a selected column to insert images into (must be of type Files).
"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).
"When cell has existing attachments": the behavior of the image upload tool when attempting to insert images to a cell that has existing images.
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.
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 ...
has the following keywords ...
mens (parent directory 1)
mens-1977-knit-hoodie-in-dark-oatmeal (parent directory 2)
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.
The Image Upload tool can be accessed by clicking the ellipsis icon () at the right side of the toolbar then "Upload Images". This will bring up the tool's panel.
