Can this skill edit existing Excel files?

Yes, it can load, modify, and save existing .xlsx and .xlsm files while preserving your current data and formulas.

Why does it use Excel formulas instead of calculating in Python?

Using formulas ensures the spreadsheet remains dynamic and interactive, allowing users to update values in Excel and see results change instantly.

Does it support professional financial formatting?

Yes, it follows industry standards for color-coding (e.g., blue for inputs, black for formulas) and advanced number formatting for currencies and percentages.

How are formula errors prevented?

The skill follows a strict verification checklist and uses a recalculation script to identify and fix errors like #REF!, #DIV/0!, and #VALUE! before outputting the file.

Excel Spreadsheet Assistant

Name: Excel Spreadsheet Assistant
Author: jawhnycooke

byjawhnycooke

•

数据科学与机器学习

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and data visualization.

This skill empowers Claude to handle complex spreadsheet tasks by leveraging Python libraries like pandas and openpyxl while adhering to strict financial modeling standards. It ensures dynamic workbooks by prioritizing Excel formulas over hardcoded values and includes automated verification to prevent common formula errors like #REF! or #DIV/0!. Whether building financial models from scratch, performing bulk data analysis, or applying professional cell formatting and color-coding, this skill provides a robust framework for high-quality, production-ready spreadsheet management within the Claude Code environment.

主要功能

01Advanced data analysis and bulk operations using integrated pandas support

024 GitHub stars

03Professional financial modeling standards with standardized color-coding and formatting

04Comprehensive styling support for custom headers, borders, fills, and alignment

05Automated formula recalculation and error verification to eliminate broken references

06Dynamic formula generation to ensure spreadsheets remain interactive and updateable

使用场景

01Transforming raw CSV datasets into formatted, multi-sheet Excel reports for business stakeholders

02Auditing and repairing existing workbooks to fix broken formulas and inconsistent data types

03Building dynamic financial models with automated growth assumptions and cross-sheet references

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jawhnycooke/claude-plugins xlsx

For use in Claude.ai and ChatGPT

Download Skill