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.

AI Schema Detection: Automate Workflows with LLM APIs

Gemini/OpenAI integration with structured JSON output, automated EDA, and data type detection directly in Excel.

Download Excel Watch Video Guide

What This App Does

#

Connect Excel directly to LLM APIs for AI-powered analysis:

  • Connect to Gemini (2.0-Flash) or OpenAI (GPT-4o)
  • Automatic schema detection with structured JSON output
  • Identify categorical and numerical variables
  • Generate SQL-compatible data types
  • AI-guided exploratory data analysis (EDA)
  • Data visualizations based on detected schema

How to Use

#
  1. Download & Install: get the app and install xlwings Lite
  2. Add API keys:
  3. Built-in Functions:
    • analyze_table_schema_gemini
    • analyze_table_schema_openai
    • perform_eda - EDA with visualizations

How It Works

#

LLM API Integration

  • Samples your data table and sends to chosen LLM
  • Crafted prompt instructs LLM to return structured JSON
  • JSON response parsed and formatted for Excel display
  • Best performance with Gemini's Flash model

Automated Workflows

  • Detected schema configures EDA operations
  • Numeric columns: statistical analysis
  • Categorical columns: frequency distributions
  • Enables automation of database operations

Practical Use Cases

  • Web scraping with structured output
  • Text classification and summarization
  • Text-to-SQL with Excel frontend
  • Data preparation for database uploads

Resources

xlwings Lite

Official website with installation instructions and examples
xlwings Documentation

Comprehensive documentation with Excel object reference and API docs
Mutual Fund Processor

Live app using schema detection for MF data
TIGZIG Co-Analyst

Database connector with schema detection
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]