Skip to main content

How can I download and insert the matching image of a product into the same data row?

Updated over 3 weeks ago

Many users need to download product images and insert them into the same data row as the corresponding product information in a file. While Octoparse now supports image downloading, the images are exported separately and not directly placed into the data rows. If you want the images to appear in the same row as the matching product data, you can use an Excel add-in such as Kutools for Excel.

The workflow contains two main steps:

  • Extract image URLs with Octoparse and export them into Excel.

  • Use Kutools for Excel to download the matching images for the URLs.

Say you captured all the image URLs from a webpage using Octoparse and exported them into an Excel file. In this tutorial, we will show you how to download their matching images and insert them into the same spreadsheet with Kutools for Excel.


Step 1. Download and install Kutools for Excel

To begin with, you need to have Kutools for Excel downloaded and installed on your local machine.

Tip: Kindly note that Kutools for Excel only supports Windows at the moment. Mac Users still need to download the images using tools like TabSave.


Step 2. Insert a new column in the spreadsheet to store the images

  • Open the Excel sheet with the image URL datasets and insert a new column next to the Image URLs to store the upcoming images.

Insert_a_new_column.jpg

Step 3. Insert Pictures with Path(URL)

  • Switch to Kutools on the menu bar and select Insert Pictures with Path(URL).

open_kutools.jpg
insert_pictures_from_Path_URL_.jpg

This feature allows you to bulk insert images in a specified range based on the image paths (URLs) range. A pop-up will appear asking you to define the Path(URL) range and Insert range.

  • As the image URLs in our spreadsheet are in column B and we want to store the downloaded images in column C, we should set the Path(URL) range to "$B:$B"(the range that contains the image Paths) and insert the range to "$C:$1" (you only need to select the first cell of the range in which you want to insert images).

Tip: You can either select the area with your mouse (after clicking on each block) or enter the Path range manually. Note that your Path range can only contain one row or column.

  • Change the picture size if you will, or leave it at the original size.

  • Click Ok to confirm the path settings.

path_settings.jpg
  • Wait for the downloading process to finish. It should take a while.

image_downloading.jpg

You will find all the images in Column C after the process is completed.

image_shown.jpg

Did this answer your question?