AI Schema Detection: Automate Workflows with LLM APIs

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

1. Download & Install: get the app and install xlwings Lite
2. Add API keys:
   • Gemini: free at aistudio.google.com
   • OpenAI: at platform.openai.com
3. Built-in Functions:
   • analyze_table_schema_gemini
   • analyze_table_schema_openai
   • perform_eda - EDA with visualizations

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