Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and match existing formats, styles, and conventions when modifying established templates.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and includes a verification step to ensure zero formula errors like #REF! or #DIV/0!.

How are formulas recalculated after modification?

The skill uses a specialized recalculation script and LibreOffice to ensure all workbook values are updated and verified for accuracy before delivery.

Can I use this for professional financial models?

Absolutely. The skill follows industry-standard color-coding conventions, such as blue for hardcoded inputs and black for formulas, ensuring model transparency.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: Jst-Well-Dan

byJst-Well-Dan

0•

生产力与工作流

Automates professional spreadsheet creation, data analysis, and financial modeling with precision formula handling and formatting.

This skill empowers Claude to handle complex spreadsheet tasks ranging from simple data entry to sophisticated financial modeling. It ensures high-quality outputs by enforcing industry-standard color coding, precise number formatting, and mandatory formula verification via LibreOffice recalibration. Whether you are analyzing large datasets with pandas or building dynamic models with openpyxl, this skill maintains data integrity and professional standards across all .xlsx, .xlsm, and CSV files while preserving existing template conventions.

主要功能

01Industry-standard financial modeling with automated color-coding and formatting rules

02Advanced formula management with zero-error verification and automatic recalibration

03High-performance data analysis and visualization via seamless pandas integration

04Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file manipulation

050 GitHub stars

06Template preservation that respects and matches existing styles and conventions

使用场景

01Cleaning and analyzing large business datasets for executive reporting and insights

02Building dynamic financial models with automated projections and scenario analysis

03Generating formatted, formula-driven reports from raw data sources automatically

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jst-well-dan/skill-box document-skills-xlsx

For use in Claude.ai and ChatGPT

Download Skill