Can it handle professional financial modeling standards?

Yes, it follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific currency/multiple formatting.

Will it overwrite my existing Excel template styles?

No, the skill is instructed to study and exactly match existing formats and conventions when modifying files, ensuring your templates remain consistent.

Does it support formats other than .xlsx?

Absolutely, it handles .xlsm, .csv, and .tsv files using Python's robust data processing libraries like pandas.

Can it perform data visualization within the spreadsheet?

Yes, it leverages pandas for analysis and openpyxl to create formatted tables and visual representations of data directly within the workbook.

How does this skill ensure Excel formulas actually work?

It uses a specialized recalculation script via LibreOffice to verify all formulas and catch common errors like #REF!, #VALUE!, or #DIV/0! before delivery.

Excel & Data Spreadsheet Specialist

Name: Excel & Data Spreadsheet Specialist
Author: wollfoo

bywollfoo

•

Data Science & ML

Automates complex spreadsheet creation, data analysis, and financial modeling with professional-grade formatting and formula integrity.

This skill empowers Claude to handle comprehensive Excel tasks, ranging from simple data entry and CSV manipulation to building sophisticated financial models. It enforces industry-standard formatting, ensures zero formula errors through automated recalculation scripts, and utilizes powerful Python libraries like pandas and openpyxl. Whether you are generating dynamic reports, analyzing large datasets, or maintaining complex templates, this tool provides the structural and logical guidelines necessary for production-ready spreadsheet deliverables.

Key Features

01Automated Excel formula recalculation and error verification using LibreOffice integration

021 GitHub stars

03Industry-standard financial model color coding and number formatting rules

04Data analysis and visualization using pandas and openpyxl integration

05Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats

06Template preservation and custom style matching for modifying existing workbooks

Use Cases

01Analyzing large CSV/Excel datasets and generating summarized report workbooks with charts

02Building automated financial models with dynamic growth assumptions and professional formatting

03Updating existing corporate Excel templates while preserving legacy formulas and styling

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add wollfoo/setup-factory document-skills

For use in Claude.ai and ChatGPT

Download Skill