How does it handle formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script (recalc.py) that runs the file through LibreOffice to verify all calculations and catch errors before delivery.

Will it overwrite my existing spreadsheet formatting?

No. The skill is instructed to study and exactly match existing styles and conventions when modifying templates to preserve your established patterns.

Can it follow specific financial modeling standards?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring professional-grade financial files.

Does this skill support native Excel formulas?

Yes, it specifically prioritizes using Excel formulas over hardcoding values to ensure spreadsheets remain dynamic and interactive for the user.

What file types are supported?

It supports comprehensive operations for .xlsx, .xlsm, .csv, and .tsv files.

XLSX & Spreadsheet Master

Name: XLSX & Spreadsheet Master
Author: Cam10001110101

byCam10001110101

•

生産性とワークフロー

Automates professional-grade spreadsheet creation, financial modeling, and data analysis with zero-error formula verification.

The XLSX & Spreadsheet Master skill transforms Claude into a powerful Excel automation engine capable of handling complex workbooks with professional precision. It goes beyond simple data entry by enforcing industry-standard financial modeling conventions, such as specific color coding for inputs and formulas, and ensuring every file is delivered without calculation errors. By combining pandas for data manipulation and openpyxl for granular formatting, it allows Claude to generate dynamic, formula-driven spreadsheets that remain fully functional and updateable by end-users.

主な機能

01Preservation of existing workbook templates, styles, and conventions

02Industry-standard financial model color coding (Blue for inputs, Black for formulas)

03Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv

04Automated formula recalculation and error detection via LibreOffice integration

05Dynamic formula-driven spreadsheet creation using openpyxl and pandas

061 GitHub stars

ユースケース

01Building robust financial projection models with automated data sourcing

02Auditing and fixing broken formulas in existing complex spreadsheets

03Transforming raw data sets into formatted, executive-ready Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cam10001110101/claude-skills-base public

For use in Claude.ai and ChatGPT

主な機能

01Preservation of existing workbook templates, styles, and conventions

02Industry-standard financial model color coding (Blue for inputs, Black for formulas)

03Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv

04Automated formula recalculation and error detection via LibreOffice integration

05Dynamic formula-driven spreadsheet creation using openpyxl and pandas

061 GitHub stars

ユースケース

01Building robust financial projection models with automated data sourcing

02Auditing and fixing broken formulas in existing complex spreadsheets

03Transforming raw data sets into formatted, executive-ready Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cam10001110101/claude-skills-base public

For use in Claude.ai and ChatGPT