Will it break the formatting in my existing templates?

No. The skill is designed to study and exactly match the existing style, formatting, and conventions of your templates when performing updates.

What libraries does this skill use for Excel operations?

It leverages pandas for high-level data analysis and openpyxl for detailed formatting and formula management, providing a complete spreadsheet toolset.

How does it prevent formula errors?

The skill uses a mandatory verification script that scans all cells for common errors like #REF!, #DIV/0!, and #NAME? to ensure the spreadsheet is fully functional.

Does this skill support complex Excel formulas?

Yes, it supports full Excel formula syntax and includes a specialized recalculation engine to ensure all values are correctly computed and error-free.

Can it handle professional financial modeling standards?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black text for formulas, and specific number formatting for currencies and multiples.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: arthur0824hao

byarthur0824hao

0•

Productivity & Workflow

Creates, edits, and analyzes complex Excel spreadsheets with support for professional financial modeling, dynamic formulas, and automated recalculation.

This skill provides Claude with advanced capabilities to manage spreadsheet workflows including .xlsx, .xlsm, and .csv formats. It goes beyond simple data export by enforcing professional financial modeling standards, such as industry-standard color coding and rigorous formula error checking. By combining pandas for data manipulation and openpyxl for formatting, it allows for the creation of production-ready workbooks. A key feature is the integrated recalculation engine that uses LibreOffice to verify formula integrity, ensuring that every spreadsheet delivered is free of errors like #REF! or #DIV/0!.

Key Features

01Support for complex Excel features including formatting, visualizations, and multi-sheet references

02Smart template preservation that matches existing file styles and conventions during updates

03Professional financial modeling standards including color-coded inputs and formula conventions

04Data analysis and processing integration using pandas for high-performance manipulation

05Automated formula recalculation and error verification using an integrated engine

060 GitHub stars

Use Cases

01Modifying existing business templates while maintaining original formatting and structural integrity

02Automating the transformation of raw CSV/TSV data into formatted, professional Excel reports

03Building dynamic financial projection models with automated assumptions and zero-error formulas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add arthur0824hao/skill xlsx

For use in Claude.ai and ChatGPT

Download Skill