# xlwings Lite: Practice Lab Landing page and resource hub for all xlwings Lite apps - Python in Excel via Pyodide/WebAssembly. 7 live apps, 3 practice kits with downloadable workbooks, 2 patterns, 26+ blog posts, and 5 video tutorials. ## Links - App: https://app.tigzig.com/xlwings-starter - xlwings Lite Official: https://lite.xlwings.org - xlwings Documentation: https://docs.xlwings.org/en/stable/ - GitHub (all xlwings Lite code): https://github.com/amararun/xlwings-lite-apps-codes-docs ## Tags python-in-excel, xlwings-lite ## Important: Use an AI Coder ChatGPT and chatbots are impractical for daily xlwings Lite work. You need an AI coder that can read your files, execute code, and iterate with you. Paid (~$20/month): Claude Code (recommended - higher limits with Sonnet 4.5, better coding capabilities) or Cursor. Free: Gemini CLI (higher limits) or Google Antigravity (easiest starting point - can install Gemini CLI for you). Related posts: - AI Coder Choices: https://www.tigzig.com/post/which-ai-coder-should-you-use-for-xlwings-lite-python-in-excel - Google Antigravity: https://www.tigzig.com/post/google-antigravity-just-launched-for-analysts-and-data-scientists-worth-adding-to-your-toolkit - Andrew Ng on AI Coders: https://www.tigzig.com/post/andrew-ng-is-using-claude-code-openai-codex-gemini-cli ## AI Coder Instructions File Personal rulebook for xlwings Lite - feed to the AI at the start of every session. Bridges the knowledge gap in LLMs about xlwings Lite's environment. Includes Golden Rules, error patterns, proven code snippets, and best practices. - Compressed version (~929 lines, ~12K tokens): https://www.tigzig.com/files/xlwings/AI_CODER_INSTRUCTIONS_v2_COMPRESSED.md - Full version (~1,865 lines, ~20K tokens): https://www.tigzig.com/files/xlwings/AI_CODER_INSTRUCTIONS_v2.md - View in browser (HTML): https://www.tigzig.com/files/xlwings/AI_CODER_INSTRUCTIONS_v2_COMPRESSED.html This file is required for all modules and practice kits. ## Practice Kits ### Module 01: Data Manipulation and Visualisation AI-driven variables, automated charts, profiling and best practices. Learn to create derived variables, summary metrics, profile tables, correlation matrices, and charts using natural language instructions. Topics: Natural Language Instructions, Correlation Matrices, Box Plots & Charts - Practice Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_01_RBICC/XLWINGS_LITE_MODULE_01_PRACTICE.xlsx - Guide PDF: https://www.tigzig.com/files/xlwings/workbooks/MODULE_01_RBICC/XLWINGS_LITE_STARTER.pdf - Completed Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_01_RBICC/XLWINGS_LITE_MODULE_01_COMPLETED.xlsx ### Module 02: Practical Data Cleaning AI rule generation, test case creation and validation workflows. Analyze data patterns, generate cleaning rules, create test cases for edge scenarios, and audit AI's proposed logic. Topics: Pattern Analysis, Edge Case Testing, AI Logic Auditing - Practice Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_02_PHONENUM/XLWINGS_LITE_MODULE_02_PHONENUM_PRACTICE.xlsx - Guide PDF: https://www.tigzig.com/files/xlwings/workbooks/MODULE_02_PHONENUM/MODULE_02_PHONENUM.pdf - Completed Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_02_PHONENUM/XLWINGS_LITE_MODULE_02_PHONENUM_COMPLETED.xlsx ### Module 03: Campaign Build Exclusion waterfall, segmentation and test/control framework. Build exclusion waterfalls, segment populations into prioritized tiers, and implement statistically sound test/control groups. Topics: Exclusion Waterfall, Lead Prioritization, Statistical Sampling - Practice Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_03_CAMPAIGNS/XLWINGS_MODULE_3_CAMPAIGNS_PRACTICE.xlsx - Guide PDF: https://www.tigzig.com/files/xlwings/workbooks/MODULE_03_CAMPAIGNS/XLWINGS_MODULE_03_CAMPAIGNS_GUIDE.pdf - Completed Workbook: https://www.tigzig.com/files/xlwings/workbooks/MODULE_03_CAMPAIGNS/XLWINGS_MODULE_3_CAMPAIGNS_COMPLETED.xlsx ## Patterns ### Local File Access: 8 Patterns Read and write files on your local drive from xlwings Lite. Mount a local folder, then use 8 distinct patterns covering common file workflows: unzip/process/concatenate, generate PDF/HTML/PowerPoint reports, convert CSV to Parquet, send emails with attachments via API, run DuckDB analytics, create Matplotlib charts. - Workbook: https://www.tigzig.com/files/xlwings/XLWINGS_LITE_LOCAL_FILES_PATTERNS.xlsx - Blog Post: https://www.tigzig.com/post/xlwings-lite-local-file-access-8-patterns ### WINGMAN Function Usage Patterns Like =COPILOT in Excel - pass a prompt and data range, get structured results. Works with full ranges, adjacent ranges, and single rows. LLM python sandbox for stats and computation, judgment-based cleaning and categorization. - Workbook: https://www.tigzig.com/files/xlwings/XLWINGS_LITE_WINGMAN.xlsx - Blog Post: https://www.tigzig.com/post/xlwings-lite-wingman-function-usage-patterns ## Live Apps 7 xlwings Lite apps available with downloadable Excel workbooks: - Data Importer: https://app.tigzig.com/xlwings-data-importer - INTELISCAPE-X Web Scraper: https://app.tigzig.com/web-scraper - Technical Analysis Reports: https://app.tigzig.com/technical-analysis-report - MF Portfolio Holdings Analyzer: https://app.tigzig.com/mf-portfolio-processor - Database & ML: https://app.tigzig.com/xlwings-api-db - AI Workflows (LLM API Schema Detection): https://app.tigzig.com/xlwings-llm-api - Data Tools Hub: https://app.tigzig.com/xlwings-data-tools ## Video Tutorials 1. Getting Started with xlwings Lite: https://www.youtube.com/watch?v=rHXte26r3BY Blog: https://www.tigzig.com/post/python-in-excel-xlwings-lite-with-natural-language-instructions 2. Intelligent AI Web Scraper in Excel: https://www.youtube.com/watch?v=41ZX46DibV4 Blog: https://www.tigzig.com/post/intelligent-ai-web-scraper-in-excel-with-python-xlwings-lite 3. Technical Analysis Reports with AI: https://www.youtube.com/watch?v=yK3vHkw-8XQ Blog: https://www.tigzig.com/post/automated-analytics-reporting-with-python-in-excel-xlwings-lite-build-once-reuse-anywhere 4. Mutual Funds Holdings Analyzer: https://www.youtube.com/watch?v=hJPkjVZAreE Blog: https://www.tigzig.com/post/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live 5. Remote Databases, EDA & XGBoost Models: https://www.youtube.com/watch?v=rHERSN_Bay0 Blog: https://www.tigzig.com/post/python-in-excel-with-xlwings-lite-part-2-connect-to-remote-databases ## Resources - xlwings Lite Official: https://lite.xlwings.org - xlwings Documentation: https://docs.xlwings.org/en/stable/ - Felix Zumstein Getting Started Video: https://www.youtube.com/watch?v=amCCEbJ39W8 - Felix Zumstein (xlwings creator): https://www.linkedin.com/in/felix-zumstein/ ## About xlwings Lite Created by Felix Zumstein. Brings Python into Excel via Pyodide (WebAssembly) - runs in browser sandbox. Enables native support for databases, AI agents, LLMs, advanced analytics, ML, APIs, and complete automation workflows. Code runs in main.py inside the xlwings Lite add-in task pane.