How to Download Bulk Images from an Excel Sheet Using Product Names (Python + Anti-CAPTCHA + Auto-ZIP)

A free, open-source automation tool to scrape high-res Google images directly from product names in Excel/CSV and auto-package them into ZIP archives.

If you have ever built an e-commerce catalog, digital canteen menu, or an AI training dataset, you know how frustrating it is to manually search and download product images one by one from Google.

When you search online for ”bulk image downloader through excel with product name” or ”bulk image downloader with product name”, almost every existing tool fails because:

1. They expect direct image URLs: If your Excel sheet only has product titles (e.g., Masala Dosa, Cotton Hoodie, Cold Coffee), standard downloaders are completely useless.
2. Google blocks scraping bots: Standard scrapers get hit with Google CAPTCHAs after just 5–10 queries.
3. Messy & low-res results: Scraping blindly gives you YouTube video thumbnails, recipe blogs, or watermarked low-res graphics.

To solve this problem once and for all, I built and open-sourced Universal Google Image Bulk Downloader Pro — a Python automation tool designed to parse product names from Excel/CSV, fetch high-resolution images safely, and automatically bundle them into a ready-to-use .zip file.

🔗 GitHub Repository: https://github.com/hariompatel61/universal-image-downloader

## 💡 What Makes This Tool Unique?

## 🛠️ How It Works Under the Hood

### 1. Two-Tier Smart Search Algorithm

Tier 1 (Stock Photography First):The script first queries Google Images specifically targeting high-quality stock photo domains like Freepik, Unsplash, Pexels, and Pixabay to ensure crisp, watermark-free images. -Tier 2 (Filtered Fallback):If no stock image is found, it automatically falls back to general Google Images while filtering out negative terms like -recipe, -video, and -youtube.

### 2. Anti-CAPTCHA Architecture Built on undetected-chromedriver, the script uses a persistent profile folder (chrome_profile/). You only solve a CAPTCHA once (if prompted on the first run). After that, session cookies are preserved, bypassing Google bot detection.

### 3. Automatic ZIP Packaging & Audit Trail

• Once the download queue is completed, all images in the output directory are automatically compressed into a .zip archive (e.g. product_images.zip).
• It generates a detailed .csv audit report detailing whether each item succeeded, skipped, or failed.

## 🚀 Quick Step-by-Step Guide

### Step 1: Clone the Repository & Install Dependencies git clone https://github.com/hariompatel61/universal-image-downloader.git cd universal-image-downloader pip install -r requirements.txt