Does it use hardcoded values or formulas?

It prioritizes Excel formulas (like =SUM() or cell references) over hardcoded Python results to ensure the spreadsheet remains dynamic and recalculates when data changes.

How does it handle formula errors?

The skill includes a mandatory recalculation step using a specialized script that identifies errors like #REF!, #DIV/0!, and #NAME?, allowing Claude to fix them before final delivery.

Can this skill modify existing Excel templates?

Yes, it is specifically designed to study and match existing formats, styles, and conventions, ensuring modifications blend seamlessly with your established templates.

What standards are used for financial models?

It follows industry-standard color conventions: blue text for inputs, black for formulas, green for internal links, and red for external links, along with specific number formatting for currencies and multiples.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: kaodean

bykaodean

0•

Data Science & ML

Automates the creation, professional formatting, and deep analysis of Excel workbooks using industry-standard modeling practices.

The xlsx skill enables Claude to act as a sophisticated spreadsheet engineer and data analyst. It goes beyond simple data export by enforcing professional financial modeling standards, including specific color-coding (blue for inputs, black for formulas) and rigorous error checking. By integrating pandas for data manipulation and openpyxl for formatting, the skill ensures that spreadsheets remain dynamic through Excel formulas rather than static values. It includes a specialized recalculation engine powered by LibreOffice to verify formula integrity and eliminate common spreadsheet errors before delivery.

Key Features

01Dynamic formula generation to ensure spreadsheets remain interactive and updateable

02High-performance data analysis and visualization using the pandas library

030 GitHub stars

04Professional financial modeling with industry-standard color-coding and formatting rules

05Automated formula verification and error detection (e.g., #REF!, #DIV/0!) using LibreOffice

06Template preservation that respects existing styles, conventions, and formatting when editing

Use Cases

01Building dynamic financial projections and valuation models with multi-period scenarios

02Auditing and correcting complex existing spreadsheets for formula errors and structural integrity

03Automating the transformation of raw CSV data into formatted, formula-driven Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kaodean/monco xlsx

For use in Claude.ai and ChatGPT

Download Skill