# Python in Excel (xlwings Lite) Build full-stack apps inside Excel with Python using xlwings Lite. APIs, databases, AI, web scraping, charts, PDFs, automation - all from a spreadsheet. ## Apps (8) ### Convert CSV/TSV to DuckDB, create shareable links for xlwings Lite - App: https://duckit.tigzig.com - Docs: https://tigzig.com/app-documentation/duckit-xlwings.html - GitHub: https://github.com/amararun/DUCKIT_UPLOADER-final - AI Docs: https://www.tigzig.com/ai/apps/duckit-xlwings.md - Convert CSV/TSV to DuckDB, create shareable links for xlwings Lite ### Mutual fund holdings analyzer with ISIN standardization in Excel - App: https://www.tigzig.com/mf-portfolio-processor - Docs: https://tigzig.com/app-documentation/mf-portfolio-processor.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/mf-portfolio-processor.md - Mutual fund holdings analyzer with ISIN standardization in Excel ### AI-powered technical analysis reports with Gemini Vision from Excel - App: https://www.tigzig.com/technical-analysis-report - Docs: https://tigzig.com/app-documentation/technical-analysis-report.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/technical-analysis-report.md - AI-powered technical analysis reports with Gemini Vision from Excel ### INTELISCAPE-X - AI web scraping with Jina + Gemini pipeline in Excel - App: https://www.tigzig.com/web-scraper - Docs: https://tigzig.com/app-documentation/web-scraper.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/web-scraper.md - INTELISCAPE-X - AI web scraping with Jina + Gemini pipeline in Excel ### Connect to PostgreSQL/MySQL and build XGBoost models in Excel - App: https://www.tigzig.com/xlwings-api-db - Docs: https://tigzig.com/app-documentation/xlwings-api-db.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/xlwings-api-db.md - Connect to PostgreSQL/MySQL and build XGBoost models in Excel ### Import data into xlwings Lite via shareable links, tokens, or raw file import - App: https://www.tigzig.com/xlwings-data-importer - Docs: https://tigzig.com/app-documentation/xlwings-data-importer.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/xlwings-data-importer.md - Import data into xlwings Lite via shareable links, tokens, or raw file import ### Hub page linking data import, DuckDB, database, and LLM tools for Excel - App: https://www.tigzig.com/xlwings-data-tools - Docs: https://tigzig.com/app-documentation/xlwings-data-tools.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/xlwings-data-tools.md - Hub page linking data import, DuckDB, database, and LLM tools for Excel ### LLM API integration for schema detection and EDA in Excel - App: https://www.tigzig.com/xlwings-llm-api - Docs: https://tigzig.com/app-documentation/xlwings-llm-api.html - GitHub: https://github.com/amararun/RBICC_AUTH_EMBED - AI Docs: https://www.tigzig.com/ai/apps/xlwings-llm-api.md - LLM API integration for schema detection and EDA in Excel ## Blog Posts (40) - [Pull 81 Risk and Performance Metrics Into Excel With One Formula](https://www.tigzig.com/post/qrep-excel-webservice-81-metrics-sep2026) - Tags: portfolio-quants, excel One Excel formula pulls 81 risk and performance metrics for any Yahoo Finance ticker straight into a sheet, using WEBSERVICE against the QREP API and TEXTSPLIT to lay the tab-separated response out across cells. Covers the working formula, the two troubleshooting steps, and how to read the same data in a browser as TSV or JSON. Also sets out the limits: WEBSERVICE fires every cell at once so a few hundred symbols runs into the host rate limit, and Power Query or Python in Excel is the route for that. Parameters explained: the risk free rate is a decimal fraction so 0.05 means 5 percent and 5 is rejected, six symbols is the maximum per call, and the benchmark sits outside that count. Backend is the Python QuantStats library with documented changes to the calculations. AI-readable: https://www.tigzig.com/ai/posts/qrep-excel-webservice-81-metrics-sep2026.md - [YFIN API Now Returns Plain CSV on Most Endpoints. Add format=csv to the Same URL.](https://www.tigzig.com/post/yfin-api-csv-format-multiple-tickers-sep2026) - Tags: portfolio-quants, excel The free YFIN Yahoo Finance API now answers with a plain CSV table on most endpoints: add format=csv to the same URL and skip unwrapping JSON. Every endpoint also takes a comma-separated list of up to 25 symbols, so a whole watchlist comes back in one request. Includes the data pull agent at quants.tigzig.com, what it will and will not do, and its separate AI technical analysis report. AI-readable: https://www.tigzig.com/ai/posts/yfin-api-csv-format-multiple-tickers-sep2026.md - [Three Upgrades on the India Mutual Fund NAV API. Easier to Pull, Whatever You Already Use.](https://www.tigzig.com/post/mf-nav-api-three-upgrades-aug2026) - Tags: mutual-funds, excel Three changes to the free India mutual fund NAV API aimed at Power Query, Excel WEBSERVICE and browser-based trackers. The all-scheme snapshot is now gzipped on the wire, dropping from 9.3 MB to about 1.1 MB on the same link. Any NAV call accepts format=csv and returns plain rows instead of JSON. The bulk download files now send a CORS header so they can be fetched from a web page. Includes a paste-ready Excel LET formula that pulls ten funds in one call using the batch schemes= parameter, which takes up to 50 codes, plus links to the MFPRO docs, FAQ and ISIN checker. AI-readable: https://www.tigzig.com/ai/posts/mf-nav-api-three-upgrades-aug2026.md - [Pulling Yahoo Finance Data Into Your Own Trackers. Excel, Sheets, a Web Tool, or Straight From an AI Agent.](https://www.tigzig.com/post/yfin-integrate-your-tools-aug2026) - Tags: excel, portfolio-quants Getting Yahoo Finance prices, calendars, financials and recommendations into whatever you already work in, through the free keyless Tigzig YFIN API. In Excel that means Power Query, Python-in-Excel via xlwings Lite, VBA or a WEBSERVICE formula, each with its own trade-off; Google Sheets needs a few lines of Apps Script; a web tool needs one JavaScript call; and an AI agent needs no code at all because it is on MCP. The practical route for most people is to hand the API docs to an agent with a desktop app, which edits the workbook directly. Also four things worth knowing: Yahoo wants the exchange ticker rather than the company name, there is now a search endpoint aimed at agents that stops them guessing symbols from memory, the /v1/excel/ statement endpoints return sheet-ready rows while the plain ones are pipe delimited, and WEBSERVICE should batch 25 tickers a call rather than firing one cell each. AI-readable: https://www.tigzig.com/ai/posts/yfin-integrate-your-tools-aug2026.md - [Three Fixes on the Yahoo Finance API This Week, All of Them Found by Reading My Own Error Logs.](https://www.tigzig.com/post/yfin-three-fixes-aug2026) - Tags: portfolio-quants, excel Three fixes to the free Tigzig Yahoo Finance API, each one found by reading the server's own error logs rather than waiting for a report. The worst of them had price history failing and then blaming the caller's ticker symbol or date range when both were fine and the real fault was upstream, so someone at the other end would have sat re-typing a symbol that was correct all along. Detailed company info could also run long and return nothing, throwing away the tickers that had already come back cleanly, and it now returns whatever it managed to fetch. A single ISIN dropped into a symbol list used to fail the entire request, and the rest of the list now comes back regardless. Also why a WEBSERVICE-based Excel tracker trips rate limits, the xlwings Lite workbook that avoids it, and why Indian tickers need the exchange symbol. AI-readable: https://www.tigzig.com/ai/posts/yfin-three-fixes-aug2026.md - [Pull India Mutual Fund NAVs Straight Into Excel. 50, 100 or More Schemes, in a Few Clicks.](https://www.tigzig.com/post/mfpro-nav-into-excel-aug2026) - Tags: mutual-funds, excel Getting India mutual fund NAV history into Excel for fifty or a hundred schemes at a time, free and without signing in, from the MFPRO Data and API screen. Comes out as a plain CSV that opens as ordinary rows, ready for the returns, CAGR and drawdown work you would normally do with formulas, and an AI assistant sitting alongside Excel will write those formulas or fetch and compute the whole thing itself. Also the three things that break an analyst's join: SEBI's February categorisation rework means the same fund can appear under a new category or scheme name between two files, so match on the AMFI scheme code rather than the name; ISIN coverage is not complete, with roughly one in fourteen live schemes carrying none; and Direct, Regular, Growth and IDCW are separate scheme codes, so one fund is usually four rows. Full history is 37 million rows from April 2006, too large for Excel. AI-readable: https://www.tigzig.com/ai/posts/mfpro-nav-into-excel-aug2026.md - [An Excel Tracker for Hundreds of Yahoo Finance Tickers, Built with xlwings Lite. For When WEBSERVICE Keeps Failing.](https://www.tigzig.com/post/sp500-excel-tracker-xlwings-yfin-aug2026) - Tags: excel, xlwings-lite, python-in-excel A downloadable Excel workbook that pulls dividend and earnings calendar data and prices for hundreds of Yahoo Finance tickers through the free Tigzig YFIN API, built for the case where a WEBSERVICE formula keeps failing because it is volatile and fires every cell at once. Built with xlwings Lite, which runs Python inside Excel as an add-in you install once. It uses the API's batching at up to 25 tickers per call with a configurable batch size, and each batch writes back to the sheet as it arrives with a spinner and a running status cell so the load is visible in progress. An important data caveat is documented: all dates are UTC calendar dates in YYYY-MM-DD with no time of day, because Yahoo timestamps each event to an exact instant and the UTC date of that instant is reported, so a US company reporting after roughly 8 PM Eastern crosses midnight UTC and lands on the next date, meaning readers should convert from UTC rather than assume the US trading date. Ships configured for S&P 500 tickers and takes about nine minutes for a full calendar pull and about two minutes for four trading days of prices, with the ticker list swappable and the Python source editable in place, so any AI assistant can modify it. Also points to the API error guide and notes the same pattern works against the India mutual fund APIs, including adding risk, return and benchmark calculations. AI-readable: https://www.tigzig.com/ai/posts/sp500-excel-tracker-xlwings-yfin-aug2026.md - [Getting 429s on the YFIN API from an Excel WEBSERVICE Formula? Here Is What Is Happening.](https://www.tigzig.com/post/yfin-excel-webservice-429s-aug2026) - Tags: infrastructure, excel Why Excel WEBSERVICE formulas hitting the free TigZig Yahoo Finance API return 429s, and what to do instead. WEBSERVICE is a volatile function, so it recalculates on any change anywhere in the workbook, meaning a few hundred such cells all fire simultaneously and breach the per-IP rate limit at once. Two mitigations: the endpoint accepts up to 25 tickers in a single call, turning a few hundred names into a few dozen calls, though hundreds of symbols will still take minutes because calls are paced server-side to manage concurrency and stay polite to Yahoo Finance. For anything at that scale the recommendation is Power Query with M, or Python in Excel via xlwings Lite, where requests run in sequence and refresh on demand rather than on every recalculation. Notes that any AI assistant can set up either option, points to the xlwings Lite hub for free guides and templates, and confirms the limits have been raised and tracker templates are in progress. AI-readable: https://www.tigzig.com/ai/posts/yfin-excel-webservice-429s-aug2026.md - [Claude for Analytics on Tigzig.com - New Hub: Excel, PowerPoint, Cowork, 7 MCP Servers, 20+ Guides.](https://www.tigzig.com/post/tigzig-claude-for-analytics-hub-jul2026) - Tags: claude-in-excel, mcp, excel Launch announcement for the new 'Claude for Analytics' hub on tigzig.com (canonical URL /ai-in-excel) - one page that pulls together everything the author has built and written on driving analyst work with Claude in Excel, PowerPoint and Cowork. Contents: 20+ guides, 5 PDF playbooks, 7 MCP servers, plus the source workbooks (formulas, charts, models). Specific capabilities highlighted: talk to Postgres and DuckDB from inside Excel, pull 81 risk and return metrics live into a sheet (QREP MCP), work with Claude-in-Excel and have it push results into Claude-in-PowerPoint for a deck, and Cowork extending the same Claude beyond the sheet to files, databases, ML models and code as one frontend. Two ways to consume - browse the hub yourself or ask Claude / ChatGPT / Gemini to read the page and summarise. All free, almost all open source. 2-page overview PDF included as a small carousel. AI-readable: https://www.tigzig.com/ai/posts/tigzig-claude-for-analytics-hub-jul2026.md - [QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in Excel.](https://www.tigzig.com/post/qrep-claude-in-excel-mcp-jun2026) - Tags: mcp, claude-in-excel, portfolio-analytics, excel Standalone one-pager release: QREP, a Tigzig MCP server, brings 81 risk and return metrics straight into Excel through Claude in Excel - asset returns, drawdowns, Sharpe, Sortino, alpha, beta, volatility and more. Just ask Claude in Excel things like 'Compare gold and bitcoin, last 10 years' or 'compare Mag 7 past 10 years' - any stock, commodity or crypto that's on Yahoo Finance. Change symbols, time period, run cuts your own way, format it your way, push it into a deck, or do it directly in PowerPoint. MCP guide at tigzig.com -> MCP -> QREP. For AI-coders, just ask Gemini / ChatGPT / Claude to help connect Claude in Excel to QRep from tigzig.com - it walks through. Wary of someone else's MCP server? The code is open source, a single Python file - ask your AI to deploy the QREP MCP server from tigzig.com. Free to use. Powered by Ran Aroussi's QuantStats. Three companion guides linked: Claude Cowork Guide, Claude in Excel & PowerPoint 26 working tips, and Claude as the universal agent. AI-readable: https://www.tigzig.com/ai/posts/qrep-claude-in-excel-mcp-jun2026.md - [Connect Excel to a Database with Tens of Millions of Rows? Tigzig.com Has 15+ Apps and Guides for That Alone. Just Ask Your AI.](https://www.tigzig.com/post/tigzig-excel-to-databases-ai-find-jun2026) - Tags: excel, python-in-excel, mcp Standalone one-pager release: how to connect Excel to a database with tens of millions of rows and GBs of data. There are 15+ apps, repos and guides on tigzig.com just for this one niche - xlwings-Lite (Python in Excel), a Claude-in-Excel MCP server, open repos connecting to MySQL, PostgreSQL and DuckDB, plus security setups, auth and semantic layers. And Excel-to-databases is only one corner - the whole site has 250+ assets, from live tools to open repos. The point of the post: don't click around. Tigzig.com is indexed across ChatGPT, Gemini, Claude, Google AI and Meta AI on WhatsApp, so just ask whichever AI you keep open what you want to pull from the site - it will find it and walk you through. If you are on Claude Code, Cursor or any AI coder, it will download and implement it for you. Sample agent prompts in the deck: 'What does tigzig.com have for connecting Excel to a database?' and 'What about security, semantic layer, auth?' AI-readable: https://www.tigzig.com/ai/posts/tigzig-excel-to-databases-ai-find-jun2026.md - [Pull your quants numbers directly with Claude / ChatGPT in Excel (with MCP).](https://www.tigzig.com/post/qrep-mcp-quants-numbers-claude-chatgpt-excel) - Tags: mcp, quantstats, excel, open-source QREP MCP server for pulling 81 quant metrics (returns, sharpe, sortino, drawdowns) directly into Claude in Excel, ChatGPT in Excel, Claude Desktop, Cursor, n8n or any MCP client. Powered by QuantStats library. Free public server, full source code open. AI-readable: https://www.tigzig.com/ai/posts/qrep-mcp-quants-numbers-claude-chatgpt-excel.md - [Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate It.](https://www.tigzig.com/post/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools) - Tags: claude-in-excel, mcp, xlwings-lite, ai-coders, portfolio-analytics Live walkthrough of S&P 500 forward returns scenario model built with four tools. Claude in Excel pulls data via YFIN MCP server and builds MAP/LAMBDA formula model. Claude Code validates offline with independent Python recomputation - catches a formula error that in-Excel checks missed. xlwings Lite generates distribution charts (fan, ridgeline, raincloud) from Python into Excel. Covers when to use each tool and MCP architecture for client work. AI-readable: https://www.tigzig.com/ai/posts/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools.md - [xlwings Lite Local File Access: 8 Patterns You Can Use Today](https://www.tigzig.com/post/xlwings-lite-local-file-access-8-patterns) - Tags: xlwings-lite, python-in-excel Demonstrates 8 local file system access patterns in xlwings Lite using Pyodide in the browser. Patterns include: unzipping and processing files, CSV-to-Parquet conversion via DuckDB, analytics with charts in Excel, HTML report generation, PDF creation with ReportLab, Parquet file persistence, email with attachments via Brevo API, and PowerPoint generation with python-pptx. Uses cricket ball-by-ball data as demo. Requires mounting a local folder. AI-readable: https://www.tigzig.com/ai/posts/xlwings-lite-local-file-access-8-patterns.md - [How to Extract Python Code from xlwings Lite Excel Files](https://www.tigzig.com/post/extract-python-code-from-xlwings-lite-excel-files) - Tags: xlwings-lite, converters-tools Python script to extract main.py and requirements.txt from xlwings Lite .xlsx files without opening Excel. The .xlsx is a ZIP archive; code is stored in xl/webextensions/webextension1.xml as JSON-encoded text. Script uses standard library only (zipfile, xml.etree, json). Also extracts Pyodide and add-in version info. Includes a command-line one-liner version. AI-readable: https://www.tigzig.com/ai/posts/extract-python-code-from-xlwings-lite-excel-files.md - [xlwings Lite new WINGMAN function - some usage patterns: python sandbox, stats, cleaning, bucketing, judging](https://www.tigzig.com/post/xlwings-lite-wingman-function-usage-patterns) - Tags: xlwings-lite, python-in-excel Explores usage patterns for xlwings Lite's new WINGMAN function (similar to Excel COPILOT). Tested patterns include: LLM Python sandbox execution, passing full ranges and adjacent ranges, structured output formatting, judgment-based data cleaning, and customer profile categorization. Works with OpenAI, Gemini, and custom models via OpenRouter. Includes downloadable test file. AI-readable: https://www.tigzig.com/ai/posts/xlwings-lite-wingman-function-usage-patterns.md - [Claude in Excel & PowerPoint. Is it worth it? What works and what doesn't](https://www.tigzig.com/post/python-in-excel-with-claude-what-works-and-what-doesnt) - Tags: claude-in-excel, python-in-excel Evaluation of Claude in Excel focusing on Excel/PowerPoint productivity and Python sandbox capabilities. Covers what works: pivots, formulas, stats, image reading, web search, ML models, charts. Python limitations: no API calls, no external databases, no local file writes, 30MB upload limit, non-deterministic outputs. Compares Claude in Excel (AI assistant) vs xlwings Lite (full Python environment). Includes 18-page slide deck. AI-readable: https://www.tigzig.com/ai/posts/python-in-excel-with-claude-what-works-and-what-doesnt.md - [Python In Excel - Claude Vs. xlwings Lite? Who Wins?](https://www.tigzig.com/post/python-in-excel-claude-vs-xlwings-lite) - Tags: claude-in-excel, python-in-excel, xlwings-lite Comparison of Claude in Excel and xlwings Lite as different tools for different jobs. Claude in Excel: AI assistant for Excel heavy lifting, Python sandbox, no API calls, no automation, no local file access, non-deterministic. xlwings Lite: pure Python in Excel, API calls, web scraping, database connections, local folders, automation. Also covers when to use Jupyter/Colab for ML models and Claude Code for full-stack development. AI-readable: https://www.tigzig.com/ai/posts/python-in-excel-claude-vs-xlwings-lite.md - [Claude in Excel just one-shotted an XGBoost response model with train-test split, AUC and full decile table. In a spreadsheet.](https://www.tigzig.com/post/claude-in-excel) - Tags: claude-in-excel, python-in-excel First-hand test of Claude in Excel building an XGBoost response model with train-test split, AUC, and full decile table inside a spreadsheet. Also tested pivot table creation. Notes Python sandbox runs on Anthropic servers with no visible code editor. Discusses data privacy implications across different deployment models (direct Anthropic vs AWS Bedrock/Azure). Shared as downloadable Excel file. AI-readable: https://www.tigzig.com/ai/posts/claude-in-excel.md - [xlwings Lite Data Importer v2 Released](https://www.tigzig.com/post/xlwings-lite-data-importer-v2-released) - Tags: xlwings-lite, python-in-excel, duckdb xlwings Lite Data Importer v2 adds support for any file type (PDFs, images, ZIPs, data files), files up to 1.2GB tested, and token-based private access (Dropbox, Google Drive, GitHub) alongside shareable links. Auto-converts data files to DuckDB or imports as-is. Uses token access pattern from xlwings_utils package. Includes CORS proxy and token setup guides with AI coder instructions. AI-readable: https://www.tigzig.com/ai/posts/xlwings-lite-data-importer-v2-released.md - [xlwings_utils: Secure Cloud Access & VBA Bridge](https://www.tigzig.com/post/xlwings-utils-secure-cloud-access-vba-bridge) - Tags: xlwings-lite, python-in-excel Review of xlwings_utils package by Ruud van der Ham solving two xlwings Lite limitations. First: secure OAuth token-based access to Dropbox, Google Drive, and GitHub (tested by author) instead of shareable URLs with CORS proxy. Second: VBA bridge for local filesystem access using base64 encoding through Excel sheets, enabling PDF export to local folders, batch image processing, and zip file handling. Also includes stdout capture and openpyxl integration utilities. AI-readable: https://www.tigzig.com/ai/posts/xlwings-utils-secure-cloud-access-vba-bridge.md - [DuckDB Meets Excel: xlwings Lite Data Tools](https://www.tigzig.com/post/duckdb-meets-excel-xlwings-lite-data-tools) - Tags: duckdb, xlwings-lite, python-in-excel Two tools for getting large datasets into xlwings Lite. DuckIt: browser-based file converter that turns CSVs into DuckDB or Parquet with shareable links (tested up to 1.5GB, 10M+ records). xlwings Lite Data Importer: pulls files from URLs into Excel, supports DuckDB, SQLite, CSV, Parquet, JSON (tested up to 1.2GB, 20M+ records). Uses Cloudflare Worker for CORS bypass. Both open source. AI-readable: https://www.tigzig.com/ai/posts/duckdb-meets-excel-xlwings-lite-data-tools.md - [The xlwings Lite AI Coder Instruction File - December 2025 Release](https://www.tigzig.com/post/the-xlwings-lite-ai-coder-instruction-file-december-2025-release) - Tags: xlwings-lite, python-in-excel, ai-coders 1,867-line instruction file for AI coders writing xlwings Lite scripts. Contains 21 golden rules (e.g., never use .expand() on just-written data), InvalidArgument troubleshooting guide, custom function patterns, API stability workarounds, and complete limitation documentation. Built from five months of client work. Includes five production app examples: AI web scraper, technical analyst, MF holdings analyzer, database connector, and EDA+ML workflow. AI-readable: https://www.tigzig.com/ai/posts/the-xlwings-lite-ai-coder-instruction-file-december-2025-release.md - [Intelligent AI Web Scraper in Excel with Python (xlwings Lite)](https://www.tigzig.com/post/intelligent-ai-web-scraper-in-excel-with-python-xlwings-lite) - Tags: xlwings-lite, python-in-excel AI-powered web scraper built in Excel using xlwings Lite, Jina.ai for content extraction, and Gemini for intelligent data transformation. Accepts natural language instructions for filtering, selecting, normalizing, and deriving fields. Configurable LLM parameters (topP, temperature, thinking budget) and scrape settings. Outputs structured data with status logs and a 30-KPI dashboard. AI-readable: https://www.tigzig.com/ai/posts/intelligent-ai-web-scraper-in-excel-with-python-xlwings-lite.md - [Automated Analytics & Reporting with Python in Excel (xlwings Lite). Build Once - Reuse Anywhere.](https://www.tigzig.com/post/automated-analytics-reporting-with-python-in-excel-xlwings-lite-build-once-reuse-anywhere) - Tags: xlwings-lite, python-in-excel, technical-analysis Reusable architecture for automated PDF and HTML report generation using xlwings Lite. Demonstrates an AI-driven technical analysis report for Yahoo Finance symbols in 45 seconds. Covers 9 reusable building blocks: API data fetching, Python transformations, Matplotlib charting, multi-modal AI calls, markdown-to-report assembly, and backend URL generation. AI-readable: https://www.tigzig.com/ai/posts/automated-analytics-reporting-with-python-in-excel-xlwings-lite-build-once-reuse-anywhere.md - [New Open Source Tool. Mutual Funds Holdings Analyzer. Python in Excel (xlwings Lite). Now Live.](https://www.tigzig.com/post/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live) - Tags: mutual-funds, xlwings-lite, python-in-excel Open-source xlwings Lite tool for standardizing and comparing Indian mutual fund portfolio disclosure data. Handles ISIN-based name standardization, corporate action merging, and human-in-the-loop data quality review. Two-stage pipeline: Stage 1 generates data quality reports, Stage 2 produces final analysis after manual review. Built with Gemini CLI. AI-readable: https://www.tigzig.com/ai/posts/new-open-source-tool-mutual-funds-holdings-analyzer-python-in-excel-xlwings-lite-now-live.md - [Which AI Coder should you use for xlwings Lite (Python in Excel)?](https://www.tigzig.com/post/which-ai-coder-should-you-use-for-xlwings-lite-python-in-excel) - Tags: ai-coders, xlwings-lite, python-in-excel Recommendations for AI coding tools for xlwings Lite development. Beginners: Gemini 2.5 Pro on aistudio.google.com (free, 1M context). Heavy work: Claude Code or Cursor. Default choice: Gemini CLI for its strong free tier and simplicity. Emphasizes using a 1,855-line AI Coder Instruction File for reliable code generation. Compares ChatGPT, Claude, and Gemini CLI tradeoffs. AI-readable: https://www.tigzig.com/ai/posts/which-ai-coder-should-you-use-for-xlwings-lite-python-in-excel.md - [Python in Excel (xlwings Lite) with Natural Language Instructions.](https://www.tigzig.com/post/python-in-excel-xlwings-lite-with-natural-language-instructions) - Tags: xlwings-lite, python-in-excel Workflow for AI-assisted xlwings Lite code generation using voice dictation and natural language. Covers 5 rules: be specific, iterate one step at a time, demand pseudocode plans, validate rigorously, and run AI audit passes. Recommends Gemini 2.5 Pro on AI Studio as primary tool. Includes a 1,855-line AI Coder instruction file for reliable output. AI-readable: https://www.tigzig.com/ai/posts/python-in-excel-xlwings-lite-with-natural-language-instructions.md - [Python in Excel: Field Guide & Practice Lab for AI-assisted xlwings Lite.](https://www.tigzig.com/post/python-in-excel-field-guide-practice-lab-for-ai-assisted-xlwings-lite) - Tags: xlwings-lite, python-in-excel, ai-coders Comprehensive practice lab for AI-assisted xlwings Lite development containing a 1,855-line AI Coder instruction file, three hands-on modules (data manipulation, cleaning, campaign build) with workbooks and guides, and live apps (web scrapers, database connectors, ML models). Core protocol: Show context, Tell instructions, Inspect and validate all output. AI-readable: https://www.tigzig.com/ai/posts/python-in-excel-field-guide-practice-lab-for-ai-assisted-xlwings-lite.md - [Build Full Campaign in Excel with Python , xlwings Lite & AI](https://www.tigzig.com/post/build-full-campaign-in-excel-with-python-xlwings-lite-ai) - Tags: xlwings-lite, python-in-excel Module 03 field guide for building marketing campaigns in Excel using xlwings Lite and AI. Covers waterfall execution, rule-based segmentation, stratified test/control setup with statistical checks, and validation/audit reports. Includes a 1,855-line AI Coder instruction file, practice workbooks, and completed examples. Based on live SMB client campaign work. AI-readable: https://www.tigzig.com/ai/posts/build-full-campaign-in-excel-with-python-xlwings-lite-ai.md - [Releasing Module 02 — Practitioner’s Series on xlwings Lite. Python in Excel. Data Cleaning & Rule Based Transformation](https://www.tigzig.com/post/releasing-module-02-practitioner-s-series-on-xlwings-lite-python-in-excel-data-cleaning-rule-b) - Tags: xlwings-lite, python-in-excel Module 02 guide on data cleaning with xlwings Lite using a real-world mobile number example. Covers multi-step rule-based transformations, AI instruction methodology, context file usage, and output validation. Emphasizes that validation is non-negotiable regardless of AI assistance. Includes practice workbook and AI Coder instruction file. AI-readable: https://www.tigzig.com/ai/posts/releasing-module-02-practitioner-s-series-on-xlwings-lite-python-in-excel-data-cleaning-rule-b.md - [Tool: A 1,450-line context file. Purpose: To ensure clean, efficient xlwings Lite code generation.](https://www.tigzig.com/post/a-1-450-line-context-file-to-ensure-clean-efficient-xlwings-lite-code-ge) - Tags: xlwings-lite, python-in-excel, ai-coders A 1,450-line AI context file for reliable xlwings Lite code generation. Contains 5 golden rules for preventing common script failures, 13 sections covering interface and API integration, and 6 advanced examples (database connections, web scraping, XGBoost). Addresses specific xlwings Lite requirements like @script decorator, Pyodide-compatible packages, and CORS-enabled endpoints. AI-readable: https://www.tigzig.com/ai/posts/a-1-450-line-context-file-to-ensure-clean-efficient-xlwings-lite-code-ge.md - [xlwings Lite Practice Lab - a free, hands-on guide for Excel professionals](https://www.tigzig.com/post/a-free-hands-on-guide-for-excel-professionals) - Tags: xlwings-lite, python-in-excel Launch of xlwings Lite Practice Lab for Excel professionals with zero coding experience. Module 01 starter kit includes AI Coder guidelines, pre-built example workbook, and visual step-by-step guide covering data manipulation, visualization, and AI-driven variables. xlwings Lite capabilities extend to database integration, web scraping, and ML models. AI-readable: https://www.tigzig.com/ai/posts/a-free-hands-on-guide-for-excel-professionals.md - [Live Python-in-Excel systems built with xlwings Lite](https://www.tigzig.com/post/live-python-in-excel-with-xlwings-lite) - Tags: xlwings-lite, python-in-excel Roundup of six Python-in-Excel apps built with xlwings Lite covering AI web scraping (Jina AI + Gemini), technical analysis with PDF/web reports, AI schema detection, remote database connectivity via FastAPI, EDA with XGBoost modeling, and Yahoo Finance data extraction. Each app includes downloadable Excel files, source code, and setup guides. Demonstrates API calls, LLM integration, and automation workflows running entirely inside Excel. AI-readable: https://www.tigzig.com/ai/posts/live-python-in-excel-with-xlwings-lite.md - [AI Powered Dynamic Web Scraper in Excel | Python+AI in Excel | xlwings Lite - Part 6.](https://www.tigzig.com/post/ai-powered-dynamic-web-scraper-in-excel-python-ai-xlwings-lite-part-6) - Tags: xlwings-lite, python-in-excel AI-powered web scraper running inside Excel via xlwings Lite. Users define URLs, target columns, and extraction rules in a spreadsheet. Backend uses Jina AI API for markdown extraction and Gemini API for structured data output via auto-generated JSON schemas. Outputs formatted Excel tables with detailed logs. Practical for lead generation, market research, and real estate analysis. Includes downloadable Excel template and setup guide. AI-readable: https://www.tigzig.com/ai/posts/ai-powered-dynamic-web-scraper-in-excel-python-ai-xlwings-lite-part-6.md - [AI-Powered Technical Analysis in Excel - with Python & Gemini Vision](https://www.tigzig.com/post/9e37b53b) - Tags: xlwings-lite, python-in-excel, technical-analysis Technical analysis system running inside Excel via xlwings Lite (Part 5). Pulls Yahoo Finance OHLCV data, computes indicators with Finta, resamples to weekly timeframes with pandas, builds multi-subplot Matplotlib charts (EMA, Bollinger Bands, MACD, RSI, ROC), sends chart images to Gemini Vision API for AI analysis, and generates PDF/web reports via FastAPI. Single downloadable Excel file with free Gemini API key. AI-readable: https://www.tigzig.com/ai/posts/9e37b53b.md - [Stock Data to AI Reports | Python-in-Excel | xlwings Lite - Part 4](https://www.tigzig.com/post/stock-data-to-ai-reports-python-in-excel-xlwings-lite-part-4) - Tags: xlwings-lite, python-in-excel, technical-analysis xlwings Lite Part 4: pulling stock data from Yahoo Finance, computing technical indicators, sending to Gemini for AI insights, and generating PDF technical analysis reports directly from Excel. Also extracts multi-period financials (P&L, balance sheet, cash flows, quarterlies). Uses a FastAPI backend that doubles as an MCP server. Includes Excel template, GitHub repo, 8-minute video walkthrough, and build guide. AI-readable: https://www.tigzig.com/ai/posts/stock-data-to-ai-reports-python-in-excel-xlwings-lite-part-4.md - [AI + Python in Excel with xlwings Lite - LLM API Calls | Part 3](https://www.tigzig.com/post/ai-python-excel-xlwings-lite-llm-api-calls-part-3) - Tags: xlwings-lite, python-in-excel xlwings Lite Part 3: making LLM API calls from Excel to Gemini 2.0 Flash and GPT-4o for schema detection (column names, types) with structured JSON output. Demonstrates automated workflows using detected schemas for EDA tables, plots, and downstream processing. Covers API calls via requests/httpx, comparison of LLM vs Python schema detection, and practical automation use cases including web scraping, text classification, and text-to-SQL. AI-readable: https://www.tigzig.com/ai/posts/ai-python-excel-xlwings-lite-llm-api-calls-part-3.md - [xlwings lite |Connect to Remote Databases](https://www.tigzig.com/post/python-in-excel-with-xlwings-lite-part-2-connect-to-remote-databases) - Tags: xlwings-lite, python-in-excel, database-ai xlwings Lite Part 2: connecting Excel to remote PostgreSQL databases via a custom FastAPI web layer. Demonstrates exploring tables, pulling records, running custom SQL, then performing EDA with descriptive stats, frequency tables, distribution plots, and building an XGBoost response model with evaluation metrics, decile table, and ROC/Gains chart. Includes FastAPI server source code, Render deployment guide, and 20-minute video walkthrough. AI-readable: https://www.tigzig.com/ai/posts/python-in-excel-with-xlwings-lite-part-2-connect-to-remote-databases.md - [Python Workflows. Inside Excel. With xlwings Lite (free) - Powerful.](https://www.tigzig.com/post/python-workflows-inside-excel-with-xlwings-lite-free) - Tags: xlwings-lite, python-in-excel Introduction to xlwings Lite, a free Python-in-Excel add-in with built-in code editor, console, and Excel object model integration. Demonstrates running XGBoost model builds, feature engineering, basic statistics, and data transformations directly inside Excel. Covers key features: Excel object manipulation, custom functions (@func/@script decorators), Web API calls, and package management via requirements.txt. No Python installation needed. AI-readable: https://www.tigzig.com/ai/posts/python-workflows-inside-excel-with-xlwings-lite-free.md ## Related Topics - [Database AI & Text-to-SQL](https://www.tigzig.com/ai/tags/database-ai.md) - [Claude in Excel](https://www.tigzig.com/ai/tags/claude-in-excel.md) - [DuckDB - Analytics & Dashboards](https://www.tigzig.com/ai/tags/duckdb.md) - [MCP Servers & Agents](https://www.tigzig.com/ai/tags/mcp-servers.md) - [Portfolio & Quantitative Analysis](https://www.tigzig.com/ai/tags/portfolio-quants.md) --- ## About **Amar Harolikar** - Specialist, Decision Sciences & Applied Generative AI - Email: amar@harolikar.com - LinkedIn: https://www.linkedin.com/in/amarharolikar - GitHub: https://github.com/amararun - Site: https://www.tigzig.com ## Legal - Privacy: https://www.tigzig.com/privacy - Terms: https://www.tigzig.com/terms --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/ai/tags/python-in-excel.md Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms