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

Published: April 15, 2025

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

Check out detailed info page on dedicated xlwings LIte section on REX AI Co Analyst 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

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, 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