Xlsx

This handles Excel file operations through Python libraries, using pandas for data analysis and openpyxl for formulas and formatting. The skill enforces zero formula errors and includes a recalc.py script that uses LibreOffice to compute formula values after creation. It's built for financial modeling with specific conventions: blue text for inputs, black for formulas, green for internal links, and proper number formatting (zeros as dashes, negatives in parentheses). The workflow is straightforward: create or modify with openpyxl, save, run the recalculation script, then fix any errors it flags. One catch: you need to use Excel formulas instead of hardcoding calculated values in Python, which keeps spreadsheets dynamic but adds a verification step.

skills.sh installs: 2.5K
GitHub stars: 849
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add tfriedel/claude-office-skills --skill xlsx --agent claude-code

Installs into .claude/skills of the current project.

Files

Requirements for Outputs

All Excel files

Zero Formula Errors

Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)

Preserve Existing Templates (when updating templates)

Study and EXACTLY match existing format, style, and conventions when modifying files
Never impose standardized formatting on files with established patterns
Existing template conventions ALWAYS override these guidelines

Financial models

Color Coding Standards

Unless otherwise stated by the user or existing template

Industry-Standard Color Conventions

Blue text (RGB: 0,0,255): Hardcoded inputs, and numbers users will change for scenarios
Black text (RGB: 0,0,0): ALL formulas and calculations
Green text (RGB: 0,128,0): Links pulling from other worksheets within same workbook
Red text (RGB: 255,0,0): External links to other files
Yellow background (RGB: 255,255,0): Key assumptions needing attention or cells that need to be updated