Can this skill handle complex Excel formulas?

Yes, it specifically prioritizes dynamic Excel formulas over hardcoded values and uses a recalculation engine to verify accuracy across the entire workbook.

Does it support professional financial modeling standards?

Absolutely. It follows industry conventions for color-coding inputs (blue), formulas (black), and links (green/red), and enforces strict number formatting for currencies and multiples.

Which Python libraries are used for spreadsheet tasks?

It leverages pandas for data-heavy analysis and openpyxl for detailed formatting, formula-based workbook creation, and editing.

How are formula errors prevented?

The skill includes a verification checklist and uses a dedicated recalc.py script to identify and report #REF!, #DIV/0!, and other errors before the file is finalized.

Can I use it to update existing company templates?

Yes, the skill is designed to study and match existing formats, styles, and conventions to ensure that modifications blend seamlessly with your established patterns.

XLSX Spreadsheet Expert

Name: XLSX Spreadsheet Expert
Author: xiaxingxiaowei1983

byxiaxingxiaowei1983

0•

Data Science & ML

Creates, edits, and analyzes professional Excel spreadsheets with automated formula verification and industry-standard formatting.

This skill enables Claude to perform advanced spreadsheet operations, ranging from simple data entry to building complex financial models. It leverages pandas for high-performance data analysis and openpyxl for precise formatting and formula management. A key differentiator is its commitment to dynamic spreadsheets; it prioritizes live Excel formulas over hardcoded values and utilizes a dedicated recalculation engine to ensure zero formula errors. Designed with professional standards in mind, it automatically applies industry-standard color coding for financial modeling and preserves existing template styles during modifications.

Key Features

010 GitHub stars

02Seamless data analysis and visualization using pandas

03Preservation of existing workbook styles and templates

04Industry-standard financial model color-coding and formatting

05Automated Excel formula generation and verification

06Formula recalculation and error detection via LibreOffice

Use Cases

01Analyzing large datasets from CSV/XLSX files and generating formatted summary reports.

02Updating enterprise spreadsheet templates while maintaining original formatting and formula logic.

03Building dynamic financial models with automated projections and scenario assumptions.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xiaxingxiaowei1983/ai xlsx

For use in Claude.ai and ChatGPT