Xlsx

This handles spreadsheet operations through openpyxl and pandas, with a strong emphasis on financial modeling conventions. The documentation is thorough about color coding standards (blue for inputs, black for formulas, green for internal links), number formatting rules, and crucially, it enforces using Excel formulas instead of hardcoding calculated values in Python. It includes a recalc.py script that uses LibreOffice to evaluate formulas and scan for errors like #REF! and #DIV/0!. The workflow is read data with pandas, build structure and formulas with openpyxl, then recalculate to get actual values. If you're building financial models or any spreadsheet where formulas matter, the detailed standards and error checking are worth following.

skills.sh installs: 1.3K
GitHub stars: 184
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add appautomaton/document-skills --skill xlsx --agent claude-code

Installs into .claude/skills of the current project.

Files

Excel workbooks

You already know openpyxl and pandas. This skill adds what you can't see from the code: a recalculation step that reports what is actually wrong in the workbook, and the behaviours of openpyxl and LibreOffice that silently break files.

Running scripts

<skill> is the directory containing this file. Run bundled scripts by absolute path from the user's working directory, so relative paths to their files keep working:

uv run <skill>/scripts/recalc.py model.xlsx

Run Python you write with its dependencies declared, either uv run --with openpyxl script.py or a PEP 723 header. Recalculation needs LibreOffice (soffice).