excel-auditor
Analyze unknown or inherited Excel files to understand what they do, document their purpose, audit formulas for errors, and assess maintainability risk. Use when: (1) User uploads an Excel file asking 'what does this do?', (2) User needs to understand an inherited/legacy spreadsheet, (3) User wants formula auditing or error detection, (4) User asks about spreadsheet risk, complexity, or documentation, (5) User mentions 'inherited', 'legacy', 'undocumented', or 'someone left' regarding Excel files.
npx skills add majiayu000/claude-skill-registry --skill excel-auditor --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Excel Auditor Analyze unknown Excel files to understand purpose, audit formulas, detect errors, and generate documentation. ## Core Workflow ### 1. Extract Structure Run the structure extraction script on the uploaded file: ```bash python scripts/extract_structure.py /mnt/user-data/uploads/<filename>.xlsx ``` This produces JSON with: sheets, named ranges, tables, external links, data validation rules, conditional formatting, and VBA presence. ### 2. Extract Formulas Run formula extraction to build dependency graph: ```bash python scripts/extract_formulas.py /mnt/user-data/uploads/<filename>.xlsx ``` This produces JSON with: all formulas, cell dependencies, calculation chains, and formula complexity metrics. ### 2b. Validate Extraction Output Before proceeding, verify JSON output contains expected keys: - Structure: `sheets`, `named_ranges`, `tables`, `external_links`, `data_validation`, `conditional_formatting`, `vba_present` - Formulas: `formulas`, `dependencies`, `calculation_chain`, `complexity_metrics` If keys are missing or malformed, note limitations in final report. ### 3. Semantic Analysis With structure and formula data, perform semantic analysis: **Purpose Detection**:
- Core Workflow
- 1. Extract Structure
- 2. Extract Formulas
- 2b. Validate Extraction Output
- 3. Semantic Analysis
- 4. Error Detection
- 5. Generate Report
- Output Formats
- Handling Edge Cases
- Error Response Templates
python scripts/extract_structure.py /mnt/user-data/uploads/<filename>.xlsx python scripts/extract_formulas.py /mnt/user-data/uploads/<filename>.xlsx
What does the excel-auditor skill do?
Analyze unknown or inherited Excel files to understand what they do, document their purpose, audit formulas for errors, and assess maintainability risk. Use when: (1) User uploads an Excel file asking 'what does this do?', (2) User needs to understand an inherited/legacy spreadsheet, (3) User wants formula auditing or error detection, (4) User asks about spreadsheet risk, complexity, or documentation, (5) User mentions 'inherited', 'legacy', 'undocumented', or 'someone left' regarding Excel files.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill excel-auditor --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.