𝐀𝐈 𝐏𝐨𝐰𝐞𝐫𝐞𝐝 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐖𝐞𝐛 𝐒𝐜𝐫𝐚𝐩𝐞𝐫 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐏𝐲𝐭𝐡𝐨𝐧+𝐀𝐈 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥 | 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 - 𝐏𝐚𝐫𝐭 𝟔.

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

Check out dedicated xlwings LIte section on REX AI Co Analyst site

Full templates

How-to guides

Backend code

Technical breakdowns

Resource Links

𝐖𝐢𝐭𝐡 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞, 𝐝𝐢𝐫𝐞𝐜𝐭𝐥𝐲 𝐢𝐧𝐬𝐢𝐝𝐞 𝐄𝐱𝐜𝐞𝐥:

▸ Scrape webpages from a user defined URL list

▸ Define custom columns to be pulled

▸ Add extraction rules and filter conditions

▸ Get formatted Excel tables

𝐈𝐧 𝐭𝐡𝐞 𝐛𝐚𝐜𝐤𝐠𝐫𝐨𝐮𝐧𝐝, 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞:

▸ 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.

𝐏𝐫𝐚𝐜𝐭𝐢𝐜𝐚𝐥 𝐮𝐬𝐞 𝐜𝐚𝐬𝐞𝐬

▸ Lead gen

▸ Market research

▸ Real estate analysis

▸ Job market intel

𝐓𝐫𝐲 𝐢𝐭 𝐨𝐮𝐭

▸ 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

𝐃𝐨𝐜𝐬 + 𝐰𝐚𝐥𝐤𝐭𝐡𝐫𝐨𝐮𝐠𝐡𝐬

Go to rex.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.

𝐏𝐚𝐬𝐭 𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞 𝐛𝐮𝐢𝐥𝐝𝐬

▸ 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

𝐱𝐥𝐰𝐢𝐧𝐠𝐬 𝐋𝐢𝐭𝐞

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.

𝐅𝐢𝐧𝐞 𝐏𝐫𝐢𝐧𝐭

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.