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
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 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).
- Change the picture size if you will, or leave it at the original size.
- Click Ok to confirm the path settings.
- Wait for the downloading process to finish. It should take a while.
You will find all the images in Column C after the process is completed.