Excel Inspector Skill

Automated Excel file structure analysis for AI code generation

Overview

This skill analyzes Excel files and outputs structured metadata (JSON) to help AI understand:

• Sheet structure and table definitions
• Column names and data types
• VBA code modules
• Sample data and statistics

When to Use

• Before writing VBA code: understand existing modules and procedures
• Before Python Excel automation: know sheet/column structure and data types
• When analyzing Excel file structure: get complete metadata in JSON format
• When modifying existing Excel macros: extract current VBA code to a file
• When debugging Excel data issues: analyze data types and sample values