Xlsx

This gives Claude real spreadsheet capabilities through openpyxl and pandas, with an emphasis on producing zero-error Excel files that financial analysts would actually use. The documentation is thorough on formula construction (use cell references, not hardcoded values), color coding standards for financial models (blue for inputs, black for formulas, green for internal links), and number formatting conventions. It includes a recalc.py script that uses LibreOffice to calculate formula values and scan for errors, which is critical since openpyxl writes formulas as strings. The requirements section reads like it was written by someone who's debugged too many broken spreadsheets. If you're building financial models or data analysis tools where formulas need to work correctly and follow industry conventions, this is built for that exact use case.

skills.sh installs: 892
GitHub stars: 467
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add ailabs-393/ai-labs-claude-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