Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

INTELISCAPE-X: AI-Powered Web Scraping in Excel

Describe in natural English what data you need - AI extracts it into structured Excel tables using Jina and Gemini APIs.

Download Excel Watch Video Guide

What This App Does

#

This xlwings Lite app turns Excel into a web scraping platform:

  • Extract structured data from multiple websites
  • Process batches of URLs with custom column specifications
  • Use AI to identify and extract data elements from web pages
  • Apply custom filtering instructions to refine results
  • Track processing status and errors automatically
  • Monitor performance metrics and token usage
  • Format results directly into Excel tables

How to Use

#
  1. Install xlwings Lite from the Add-in button in Excel
  2. Configure the MASTER sheet:
    • Add your Jina and Gemini API keys
    • Select your Gemini model (e.g. gemini-2.5-flash)
    • Set scraping parameters (timeout, retries, delays)
  3. Define extraction columns in COLUMN_INPUTS:
    • Specify column names and descriptions for the data you want
    • Add custom filtering instructions if needed
  4. Add target URLs in URL_LIST
  5. Run the scraper: execute scrape_urls_from_list from the xlwings tab
  6. Review results: DATA, DASHBOARD, ERROR_LOG, and URL_LIST sheets

How It Works

#

The web scraper processes URLs through a three-stage pipeline:

Stage 1: Configuration

  • xlwings Lite runs Python code directly in Excel via WebAssembly
  • Reads configuration from MASTER sheet (API keys, model settings)
  • Loads column definitions from COLUMN_INPUTS

Stage 2: Data Extraction

  • Sends each URL to Jina API to fetch and render as markdown
  • Passes rendered content to Gemini API with column specifications
  • Gemini extracts structured data matching your definitions

Stage 3: Results

  • Writes extracted data to DATA sheet as formatted table
  • Logs errors to ERROR_LOG sheet with timestamps
  • Generates DASHBOARD with performance metrics

Process Flow

ExcelURLs + ConfigColumn Specs Jina APIFetch & RenderWeb -> Markdown Gemini APIAI ExtractionStructured JSON PythonParse & FormatError Handling Excel OutputDATA SheetDASHBOARDERROR_LOGURL_LIST Status

URLs flow through Jina API for web rendering, Gemini for AI extraction, then back to Excel with structured data

Resources

xlwings Lite

Official website with installation instructions and examples
xlwings Documentation

Comprehensive documentation with Excel object reference and API docs
Jina AI Web Scraping API

Dashboard for the Jina API that fetches and renders web pages
Google Gemini API

Documentation for AI-powered structured data extraction
xlwings Lite

Built with xlwings Lite

Created by Felix Zumstein, it brings Python into Excel seamlessly - enabling native support for databases, AI agents, LLMs, advanced analytics, ML, APIs, and complete automation workflows.

Bugs,issues,questions? Drop a note: [email protected]