What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv files for reading, editing, and format conversion.

How does the skill ensure formula accuracy?

It utilizes a mandatory verification step using LibreOffice to recalculate all formulas and scan for errors like #REF!, #DIV/0!, and #VALUE! before final delivery.

Does it support financial modeling standards?

Yes, it follows industry conventions such as blue text for hardcoded inputs, black for formulas, and green for internal links, while requiring documentation for all assumptions.

Can this skill work with my existing Excel templates?

Yes, the skill is specifically designed to study and exactly match existing formats, styles, and conventions when modifying your files.

Excel & Spreadsheet Professional

Name: Excel & Spreadsheet Professional
Author: stevessr

bystevessr

0•

数据科学与机器学习

Manages complex spreadsheet tasks including professional financial modeling, data cleaning, and automated formula validation.

This skill enables Claude to perform high-level spreadsheet operations with a focus on professional standards and data integrity. It handles everything from simple CSV conversions to complex financial models, ensuring that all deliverables feature zero formula errors and adhere to industry-standard formatting. By leveraging pandas for data analysis and openpyxl for precise formatting, the skill ensures spreadsheets remain dynamic and updateable rather than relying on static, hardcoded values. It also includes mandatory recalculation steps using LibreOffice to verify that every cell reference and formula functions perfectly across all sheets.

主要功能

01Dynamic formula construction to ensure spreadsheets remain updateable

020 GitHub stars

03Industry-standard financial modeling with specific color-coding for inputs and formulas

04Preservation of existing templates, styles, and formatting conventions

05Automated formula recalculation and error detection (#REF!, #DIV/0!, etc.)

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

使用场景

01Building investment-grade financial models with standardized assumptions and source documentation

02Automating repetitive reporting tasks by updating existing templates with new data while maintaining styles

03Cleaning and restructuring malformed tabular data into professional, multi-sheet workbooks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add stevessr/dotsfiles xlsx

For use in Claude.ai and ChatGPT

Download Skill