XLSX Smart Extractor

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).

diegocconsolini Updated

File contents

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.

diegocconsolini/ClaudeSkillCollection/tree/main/xlsx-smart-extractor commit a921874dae

Frequently asked questions

npx skillmds@latest add diegocconsolini/xlsx-smart-extractor