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

May 18, 2022 01:49
Updated

It has come to our notice that a lot of users need to bulk download the matching images for a data field and store them in an Excel file. With Octoparse, it is easy to automate the process of scraping all the image URLs. However, if you need the actual images instead of the URLs, you have to go the extra mile and use a bulk image downloader to download the images and manually insert them into an Excel file.

The Octoparse team has been hammering away at the development of a built-in image downloader, which should be available later this year. But that is still several months away. So is there any workaround for this simple task? After a little research work, we suggest you use Kutools for Excel with Octoparse to achieve that purpose. The workflow contains two major 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 URLs from a webpage using Octoparse and chose to export them into an Excel file. In this article, we will teach you how to download their matching images to 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.

Download link: https://www.extendoffice.com/product/kutools-for-excel.html

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. Check out this article for more information.

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.

Step 3 Insert Pictures with Path(URL)

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

This feature allows you to bulk insert images in a specified range based on the range containing the image paths (URLs). 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 Path(URL) range to "$B:$B"(the range that contains the image Paths), and insert 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 is only allowed to contain one row or one column. You can also click

to see if you have selected the desired area.