XLSX Smart Extractor

---

name: xlsx-smart-extractor description: Use this skill to extract and analyze large Excel workbooks (1MB-50MB+) with minimal token usage. Losslessly extracts formulas, cell formatting, and complex tables while achieving 20-100x token reduction through local extraction, semantic chunking, and intelligent caching. Use when an .xlsx is too large for the context window (compliance matrices, financial models, audit logs). license: MIT

Excel Smart Extractor Skill

Extract once locally, query forever. Reduces token cost by loading only the relevant sheets/columns instead of an entire workbook.

Usage

# 1. Extract (one-time, local — caches to ~/.claude-cache/xlsx/)
python scripts/extract_xlsx.py workbook.xlsx

# 2. Chunk the extracted content
python scripts/chunk_sheets.py {cache_key}

# 3. Query / list
python scripts/query_xlsx.py search {cache_key} "your query"
python scripts/query_xlsx.py list

Requires openpyxl. Cache lives in ~/.claude-cache/xlsx/; extract, chunk, and query all resolve to that same location via the shared smart_cache library.