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.

Python in Excel: Field Guide & Practice Lab for AI-assisted xlwings Lite

Published: September 3, 2025

I am sharing my workflow and documents for using AI to reliably generate xlwings Lite Python code. This is not a theoretical guide. It's a set of practical tools and hard rules which I use day to day in my client projects.

What's in the xlwings Lite Practice Lab:

1. AI Coder Instruction File: My personal 1,855-line directive file. This is the core context you feed the AI to ensure it get clean, reliable xlwings Lite code.

2. Step-by-Step Field Guides: Three hands-on modules (Data Manipulation, Cleaning, Campaign Build) with the exact workbooks, guides and codes I use to test and validate.

3. Live Apps: xlwings Lite apps: web scrapers, database connect, AI schema detection, machine learning, quants reports

The Core Protocol for AI code generation

1. Show - Context is King: Give the AI everything - images, schemas, rules.

2. Tell - Instruct, Don't Assume: Be direct and iterate. One instruction is never enough.

3. Inspect - Trust, but Verify: All AI output must be validated. It makes mistakes.

How to get the materials

Go to www.tigzig.com (Path: xlwings Lite Practice Lab)

All guides, workbooks, apps and the AI instruction file are available for download.

xlwings Lite

Part of my primary stack.

Created by Felix Zumstein.

TIGZIG Co-Analyst

This is part of my open-source suite of 25+ tools for analysts and builders.

xlwings Lite official site: lite.xlwings.org