---
title: "AI Powered Dynamic Web Scraper in Excel | Python+AI in Excel | xlwings Lite - Part 6."
slug: ai-powered-dynamic-web-scraper-in-excel-python-ai-xlwings-lite-part-6
date_published: 2025-04-15T04:39:08.611Z
original_url: https://www.tigzig.com/post/ai-powered-dynamic-web-scraper-in-excel-python-ai-xlwings-lite-part-6
source: migrated
processed_at: 2025-12-02T10:00:00.000Z
---

# AI Powered Dynamic Web Scraper in Excel | Python+AI in Excel | xlwings Lite - Part 6.

**Extract structured data from websites into Excel - with Jina AI and Gemini.**

![Web Scraper](https://static.wixstatic.com/media/ef0c19_79852894f3404ab3b0794be9018dd78b~mv2.png/v1/fill/w_360,h_233,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/ef0c19_79852894f3404ab3b0794be9018dd78b~mv2.png)

Check out detailed info page on dedicated xlwings LIte section on [REX AI Co Analyst](https://tigzig.com/web-scraper) site

* Full templates
* How-to guides
* Backend code
* Technical breakdowns
* Resource Links

**Detailed info , source codes, how-to guides, resources and templates available on REX**

## With xlwings Lite, directly inside Excel:

* Scrape webpages from a user defined URL list
* Define custom columns to be pulled
* Add extraction rules and filter conditions
* Get formatted Excel tables

## In the background, xlwings Lite:

* Extracts content in markdown from Jina AI via an API call
* Auto-generates JSON schema and structured prompt for Gemini
* Gets structured output from Google Gemini via an API call
* Generates detailed logs.

## Practical use cases

* Lead gen
* Market research
* Real estate analysis
* Job market intel

## Try it out

* Single Excel file - download below
* Excel → Home → Add-in → 'xlwings Lite'
* Get API keys for Gemini and Jina AI - no credit card, takes less than a minute. aistudio.google.com / [jina.ai](http://jina.ai/)

## Docs + walkthroughs

Go to tigzig.com and head to the xlwings Lite section - full templates, how-to guides, backend code, and technical breakdowns for every xlwings Lite app in the series.

## Past xlwings Lite builds

* AI Technical Analysis
* Formatted PDF Report
* Web Report
* Complex visualizations with subplots
* Remote Database Queries
* API calls
* AI Schema detection
* Automated workflows
* Exploratory Data Analysis
* Machine Learning Models

## xlwings Lite

Built by [Felix Zumstein](https://www.linkedin.com/feed/update/urn:li:ugcPost:7317739896104779778/), xlwings Lite is a free and powerful Python-in-Excel solution that enables complex automation workflows, custom functions, database access, AI agents, LLMs, analytics, ML, APIs, and web services.

## Fine Print

This is an example app to show how to set up AI web scraping inside Excel using xlwings Lite. Works well for simple sites; complex or recursive scrapes need custom code. Always check site terms, robots.txt, and rate limits.



xlwings Lite official site: [lite.xlwings.org](https://lite.xlwings.org)