SkillAgentSearch skills...

xlsx-toolkit

Audit Microsoft Excel (.xlsx) workbooks for formula density, external references, named ranges, hidden sheets, and data validation

Install / Use

npx skills add borghei/Claude-Skills --skill xlsx-toolkit

Installs into whichever agent you are using.

About this skill
📄

SKILL.md

Installable skill definition

Quality Score

86/100

Category

Automation

Supported Platforms

Universal

Our assessment of xlsx-toolkit

xlsx-toolkit scores 86/100 on our quality scale, 1838th of 2,769 Automation skills we index.

Its SKILL.md is 5.3 KB long, well organised into 15 sections with 2 code examples: a solid amount of guidance for an agent.

It has 817 GitHub stars, a meaningful sign that others use it.

Substance
26/30
Structure
18/20
Description
15/15
Adoption
12/20
Freshness
15/15

Maintenance, license and trust

  • The repository was last updated about 2 months ago, so xlsx-toolkit is actively maintained.
  • Our last check on 2026-11-03 found the source still online.
  • No license is declared. By default that means all rights are reserved: you can read it, but reusing or redistributing it is not clearly permitted. Ask the author before building on it commercially.
  • Its trust signals score 88/100, with 1 caution from licensing, adoption, age or documentation. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.

Safety scan

No issues found

Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.

AI review by kimi-k2.7-code on 2026-10-07. Automated pattern scan on 2026-10-07. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.

xlsx-toolkit compared with similar skills

All 4 of these similar skills score higher than xlsx-toolkit; compare them before choosing.

SkillScoreStarsUpdatedFormat
xlsx-toolkit (this skill)by borghei8681757d agoSKILL.md
Agent-Reachby Panniantong100112.7k9d agoCLAUDE.md
rufloby ruvnet10082.0ktodayCLAUDE.md
headroomby headroomlabs-ai10079.9ktodayCLAUDE.md
Claude-Code-Game-Studiosby Donchitos10039.9k8d agoCLAUDE.md

Frequently asked questions

How do I install xlsx-toolkit?
Run npx skills add borghei/Claude-Skills --skill xlsx-toolkit. The install tabs above show the steps for each supported agent.
Which AI agents does xlsx-toolkit work with?
It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
Is xlsx-toolkit safe to use?
Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It declares no license and scores 88/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
Is xlsx-toolkit still maintained?
The repository was last updated about 2 months ago, so xlsx-toolkit is actively maintained.

name: xlsx-toolkit description: > Audit Microsoft Excel (.xlsx) workbooks for formula density, external references, named ranges, hidden sheets, and data validation. Use when reviewing a financial model, sharing a workbook externally, or checking for data leakage. license: MIT + Commons Clause metadata: version: 1.0.0 author: borghei category: documents domain: document-automation updated: 2026-05-04 python-tools: xlsx_auditor.py tech-stack: xlsx, OOXML

Xlsx Toolkit

Audit .xlsx files using the standard library only — no openpyxl required. Reads OOXML directly via zipfile + xml.etree.


Table of Contents


Keywords

xlsx, Excel, spreadsheet, workbook, financial model, formula audit, hidden sheets, external references, named ranges, data validation


Clarify First

Before running the audit, confirm these inputs. If any is unknown or vague, ASK — do not assume:

  • [ ] Audit purpose (pre-send leak check, financial-model review, or handoff portability check) — selects the workflow and what you flag
  • [ ] Recipient context (external partner, another team, their machine) — sets the tolerance for hidden sheets and external links
  • [ ] Which sheets are inputs vs calculations (for model review) — drives where to focus formula-density reading

Stop rule: ask only the 2-3 that most change the output. If the user says "just draft it," proceed and list your assumptions at the top of the artifact.

Quick Start

python scripts/xlsx_auditor.py model.xlsx

Outputs: sheet count and names, hidden-sheet count, cell count per sheet, formula count per sheet, external link count, named range count, data validation rule count.


Core Workflows

Workflow 1: Pre-Send Workbook Audit

Goal: Catch the issues that embarrass the sender — leftover hidden sheets, broken external links, unused named ranges, formulas referencing local file paths.

Steps:

  1. Run audit
  2. Hidden sheets > 0 → confirm intentional or delete
  3. External links > 0 → verify links point to public / shared sources, not your local drive
  4. Named-range count anomalies (very high) → likely cruft from prior model versions; clean up
  5. Re-run until clean

Time Estimate: 5-10 minutes per workbook.

Workflow 2: Financial Model Review

Goal: Quantify the rough complexity of a financial model before reading cell-by-cell.

Steps:

  1. Run audit; capture per-sheet cell counts and formula counts
  2. Sheets with formula density > 70% are calculation sheets; should be well-structured
  3. Sheets with formula density 0-10% are inputs; should be obviously labeled
  4. Sheets with formula density 10-70% are mixed — easiest place for errors to hide
  5. Cross-reference with references/financial_model_audit_guide.md

Time Estimate: 30-60 minutes per model audit (audit + targeted reading).

Workflow 3: Workbook Handoff Check

Goal: Ensure a workbook handed off to another team or partner won't break on their machine.

Steps:

  1. Run audit
  2. External links → re-link to shared paths (OneDrive, SharePoint, S3) or hard-code values
  3. Custom named ranges → document if recipient is expected to extend; remove if internal
  4. Macros (xlsm) → audit shows non-.xlsx extension expected; convert if recipient cannot run macros
  5. File size > 10 MB → consider splitting or removing image / chart blobs

Time Estimate: 10-20 minutes per workbook.


Tools

xlsx_auditor.py

Reads a .xlsx file as a ZIP archive and parses OOXML directly.

python scripts/xlsx_auditor.py model.xlsx
python scripts/xlsx_auditor.py model.xlsx --json

Reports:

  • Sheet list with name, hidden status, cell count, formula count, formula density %
  • Total cell and formula counts
  • Named ranges and their scopes
  • External link references (file paths or URLs)
  • Data validation rule count
  • File size

Limits:

  • Does not evaluate formulas. To check whether formulas are correct, use Excel itself or a financial-model-checker library.
  • Does not read cell values for non-shared-string cells beyond counting; full value extraction requires more parsing than this tool does.

Reference Guides

  • references/financial_model_audit_guide.md — Patterns for auditing financial models; common error categories; defensive structure tips

Templates

  • assets/workbook_handoff_checklist.md — Pre-send xlsx sign-off checklist

Best Practices

  • Hide internal-only sheets only when intended. If a sheet is hidden because it's WIP, delete it before sending.
  • Avoid external links across handoffs. A formula referencing 'C:\Users\you\Desktop\old-model.xlsx' is the workbook equivalent of leaving your laptop name in the document author field.
  • Name your inputs. Cells like Inputs!B7 mean nothing. Named ranges like WACC and RevenueGrowth survive structural changes.
  • One model, one purpose. Workbooks that calculate, present, and serve as a database of records always end up broken.

Integration Points

  • Pairs with finance/ skills for financial-model review
  • Pairs with c-level-advisor/cfo-advisor for board-pack workbook review
  • Used by data-analytics/ for ad-hoc analytics handoff

Related Skills

View on GitHub
GitHub Stars817
CategoryAutomation
Updated1mo ago
Forks141

Languages

HTML

Trust signals

88/100

From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.

1 medium