XLSX Processing
SkillFiles & storageProcesses Excel spreadsheet files (.xlsx, .xlsm, .csv). Creates workbooks, builds formulas, preserves formatting, analyzes tabular data, and validates financial models with zero-formula-error delivery. Use when working with spreadsheet files or tabular data analysis. Do NOT use for Word documents, PDFs, presentations, or database pipelines.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the XLSX Processing skill
What this skill tells your AI
The instructions your AI receives, as published by telagod/code-abyss in skills/analyzing-spreadsheets/SKILL.md and read by ahel’s review.
Create, edit, analyze .xlsx files. LibreOffice required for formula recalculation via recalc.py.
Iron Rule
Zero formula errors at delivery. All formulas must compute — no #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?. Always run recalc.py after writing formulas.
Decision Matrix
| Task | Tool | Reference |
|---|---|---|
| Data analysis, bulk ops, simple export | pandas | recipes.md |
| Formulas, formatting, Excel features | openpyxl | recipes.md |
| Financial model standards | — | financial-model.md |
| Recalculate formulas | recalc.py | recipes.md |
Common Workflow
- Choose tool: pandas for data, openpyxl for formulas/formatting
- Create/Load workbook
- Modify data, formulas, formatting
- Save
- Recalculate (MANDATORY if formulas):
python recalc.py output.xlsx - Verify & fix errors — check JSON output, fix
#REF!/#DIV/0!/#VALUE!/#NAME?
Hard Constraints
- Use formulas, not hardcoded values — calculations stay dynamic. See recipes.md.
- Preserve existing templates — match existing format/style EXACTLY when updating; user template overrides defaults.
- Financial models — follow color/format conventions in financial-model.md.
Code Style
- Concise Python, no unnecessary comments or print statements.
- Excel files: comment cells with complex formulas, document hardcode sources.
Signals
- GitHub stars
- 240
- Forks
- 32
- Last commit
- Jul 2026
Advanced
- Catalog kind
- skill
- Gateway key
analyzing-spreadsheets- Source
- github.com/telagod/code-abyss