Does this skill support live Excel formulas?

Yes, it specifically prioritizes using Excel formulas (like SUM or AVERAGE) over hardcoded values to ensure the spreadsheet remains dynamic and recalculates correctly when data changes.

How does the skill ensure there are no formula errors?

The skill utilizes a mandatory recalculation script (recalc.py) that runs through LibreOffice to verify all formulas and catch errors like #REF! or #DIV/0! before finishing the task.

Can it follow specific financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and yellow backgrounds for key assumptions.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and exactly match your existing templates, styles, and conventions unless you specifically request a change.

XLSX Master

Name: XLSX Master
Author: Within-7

byWithin-7

0•

Data Science & ML

Automates professional spreadsheet creation, data analysis, and financial modeling with dynamic formulas and industry-standard formatting.

This skill empowers Claude to perform advanced spreadsheet engineering, enabling the creation, modification, and analysis of complex .xlsx and .csv files. It goes beyond simple data entry by implementing dynamic Excel formulas, preserving existing template styles, and adhering to strict financial modeling standards like color-coded cell conventions. With integrated support for pandas and openpyxl, plus a dedicated recalculation engine, it ensures that every spreadsheet delivered is functionally accurate, professionally formatted, and free of formula errors.

Key Features

01Automated formula recalculation and error detection via LibreOffice integration

020 GitHub stars

03Template preservation to maintain existing styles, conventions, and formatting

04Professional financial modeling standards including industry-standard color coding

05Dynamic Excel formula generation to avoid hardcoded calculation values

06Deep data analysis and visualization using pandas and openpyxl

Use Cases

01Building automated financial models with projected growth and scenario analysis

02Updating existing corporate templates with new data while preserving complex formatting

03Performing bulk data analysis and generating visual reports directly in Excel format

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add within-7/minto-plugin-tools skills

For use in Claude.ai and ChatGPT

Download Skill