Skills
.Work. You
Rest

excel-inspector

Community

Reveal Excel file structure at a glance.

Data & Analytics#automation#json#metadata#excel#structure-analysis#data-types#vba
AuthorRukkha1024
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Excel files often contain complex sheet structures and embedded VBA code that are hard to interpret without digging through cells. The Excel Inspector automates this analysis and outputs structured metadata (JSON) including sheets, tables, column data types, and extracted VBA modules, enabling AI to understand the workbook before code generation or modification.

Core Features & Use Cases

  • Sheet structure analysis: names, dimensions, tables, and ranges
  • Data type inference per column and NA statistics
  • VBA code extraction: saves modules to .claude/vba directory
  • Sample data previews and quick validation
  • Use Cases: before automating Excel workflows with Python or VBA, or debugging data issues; AI can read the JSON to adapt code

Quick Start

Analyze an Excel workbook to generate a complete JSON structure and extracted VBA modules that you can feed to AI for understanding and code generation.

Dependency Matrix

Required Modules

openpyxlpolarspandasxlwings

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: excel-inspector
Download link: https://github.com/Rukkha1024/elderly-balance-assessment/archive/main.zip#excel-inspector

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.