top of page

๐€๐ˆ ๐๐จ๐ฐ๐ž๐ซ๐ž๐ ๐ƒ๐ฒ๐ง๐š๐ฆ๐ข๐œ ๐–๐ž๐› ๐’๐œ๐ซ๐š๐ฉ๐ž๐ซ ๐ข๐ง ๐„๐ฑ๐œ๐ž๐ฅ | ๐๐ฒ๐ญ๐ก๐จ๐ง+๐€๐ˆ ๐ข๐ง ๐„๐ฑ๐œ๐ž๐ฅ | ๐ฑ๐ฅ๐ฐ๐ข๐ง๐ ๐ฌ ๐‹๐ข๐ญ๐ž - ๐๐š๐ซ๐ญ ๐Ÿ”.

Updated: Apr 24



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


๐–๐ข๐ญ๐ก ๐ฑ๐ฅ๐ฐ๐ข๐ง๐ ๐ฌ ๐‹๐ข๐ญ๐ž, ๐๐ข๐ซ๐ž๐œ๐ญ๐ฅ๐ฒ ๐ข๐ง๐ฌ๐ข๐๐ž ๐„๐ฑ๐œ๐ž๐ฅ:

โ–ธ 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.


ย 
ย 

Recent Posts

See All
bottom of page