Does this skill support existing Excel templates?

Yes, the skill is designed to study and exactly match existing formatting, styles, and conventions, ensuring that template patterns are preserved during updates.

How does it handle formula verification?

It uses a specialized recalculation workflow involving LibreOffice to scan all cells for errors like #REF!, #DIV/0!, and #VALUE!, ensuring models are delivered error-free.

Are there specific standards for financial modeling?

Yes, it follows industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal links, along with specific rules for currency and percentage formatting.

What libraries does this skill utilize?

The skill leverages pandas for data analysis and bulk operations, and openpyxl for complex formatting, formula preservation, and Excel-specific features.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: XD3an

byXD3an

•

数据科学与机器学习

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

This skill empowers Claude to handle complex spreadsheet tasks ranging from simple CSV parsing to building institutional-grade financial models. It combines the data processing power of pandas with the formatting precision of openpyxl, ensuring that spreadsheets are not just static data dumps but dynamic, formula-driven tools. It enforces industry-standard financial formatting and includes a robust verification system via LibreOffice to ensure zero formula errors before delivery. Whether you are generating reports, analyzing datasets, or building complex financial workbooks, this skill provides the necessary domain-specific guidance and technical implementation patterns.

主要功能

01Dynamic formula injection with automated recalculation and error-checking workflows

02Seamless integration with pandas for high-performance data analysis and visualization

03Industry-standard financial modeling standards including specific color coding and number formatting

04Precise formatting control to preserve existing template styles and conventions

05Comprehensive spreadsheet lifecycle management for .xlsx, .xlsm, .csv, and .tsv formats

066 GitHub stars

使用场景

01Automating the migration and transformation of data from CSV sources into formatted executive reports

02Building dynamic financial models with automated scenario analysis and standardized formatting

03Analyzing large-scale datasets using pandas and exporting insights into interactive, formula-based workbooks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xd3an/awesome-ai-coding-all-in-one xlsx

For use in Claude.ai and ChatGPT

Download Skill