Does this skill support existing Excel templates?

Yes, it is designed to study and exactly match existing formats, styles, and conventions to ensure seamless integration with your established spreadsheet patterns.

How does it ensure formula accuracy?

The skill uses a mandatory recalculation process via LibreOffice that identifies and reports errors like #REF! or #DIV/0!, ensuring every file is delivered error-free.

Can I use this for professional financial modeling?

Absolutely. It follows industry standards for color coding, number formatting (currency, percentages, multiples), and requires detailed documentation for all hardcoded inputs.

Is it limited to .xlsx files?

While optimized for .xlsx and .xlsm files, it also supports reading and processing common data formats like .csv and .tsv using pandas.

Why does it need LibreOffice?

LibreOffice is used to physically recalculate formula values within the file, allowing Claude to verify that logic works correctly before you ever open the document.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: Weiwei-Mao

byWeiwei-Mao

0•

데이터 과학 및 ML

Enables professional-grade spreadsheet creation, financial modeling, and data analysis with automated formula verification and industry-standard formatting.

The xlsx skill provides Claude with comprehensive capabilities for managing complex Excel workbooks, ranging from basic data entry to sophisticated financial modeling. It ensures high-quality output by enforcing strict standards such as zero-formula-error policies and industry-standard color coding (e.g., blue for inputs, black for formulas). By integrating with pandas for data analysis and openpyxl for structural editing, alongside a specialized LibreOffice recalculation engine, the skill allows for the creation of truly dynamic spreadsheets that maintain functional integrity and professional aesthetics.

주요 기능

010 GitHub stars

02Professional financial modeling standards including color-coded inputs and assumptions

03Automated Excel formula generation and real-time recalculation using LibreOffice

04Preservation of existing templates, formatting, and stylistic conventions

05Multi-sheet data analysis and visualization using pandas and openpyxl

06Robust error detection and verification for #REF!, #DIV/0!, and #VALUE! errors

사용 사례

01Building dynamic financial projection models with automated scenario analysis

02Generating formatted corporate reports from raw data sources with interactive formulas

03Modifying and updating complex legacy spreadsheets without breaking existing styles or logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add weiwei-mao/hydrology-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill