Can I use this for professional financial modeling?

Yes, it follows industry conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

How does it handle Excel formula errors?

It uses a mandatory recalculation script and a verification checklist to detect and resolve errors like #REF!, #DIV/0!, and #VALUE! before final delivery.

Does it require LibreOffice?

LibreOffice is required specifically for formula recalculation tasks using the recalc.py script to ensure all cell values are updated correctly.

Does this skill support existing Excel templates?

Yes, the skill is specifically designed to study and exactly match existing formats, styles, and conventions when modifying established templates.

Which Python libraries are utilized?

It uses pandas for heavy data manipulation and analysis, and openpyxl for precise control over formatting, styles, and Excel-specific features.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: anthropics

byanthropics

•

24,064

•

Data Science & ML

Automates the creation, editing, and analysis of Excel spreadsheets with professional formatting, formula integrity, and financial modeling standards.

This skill provides a robust framework for Claude to manage complex spreadsheet operations including .xlsx, .xlsm, and CSV files. It emphasizes formula-driven models over hardcoded values to ensure spreadsheets remain dynamic and updateable. The skill includes specialized support for industry-standard financial modeling, such as specific color coding for inputs and formulas, and integrates a recalculation engine to guarantee zero formula errors. By leveraging pandas for data analysis and openpyxl for precision formatting, it bridges the gap between raw data processing and professional-grade reporting.

Key Features

01Automated spreadsheet creation with formula preservation

02Formula verification and error prevention (#REF!, #DIV/0!)

0324,064 GitHub stars

04Automated formula recalculation via LibreOffice integration

05Industry-standard financial model formatting and color coding

06Advanced data analysis and visualization using pandas

Use Cases

01Analyzing large datasets and exporting insights into formatted workbooks

02Building dynamic financial models and valuation sheets from scratch

03Updating existing corporate templates while maintaining original styling

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add anthropics/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill