What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv files, covering both modern Excel workbooks and standard flat-file data formats.

Does it follow professional financial modeling standards?

Absolutely. It adheres to industry conventions, such as blue text for hardcoded inputs, black for formulas, and green for internal links to ensure models are audit-ready.

Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying files, ensuring template integrity is maintained.

Can this skill handle complex Excel formulas?

Yes, it supports full Excel formula construction and provides a recalculation engine via LibreOffice to ensure accuracy and identify errors like #REF! or #DIV/0!.

How does it handle large datasets?

It utilizes the pandas library for efficient data manipulation, allowing for high-performance reading, cleaning, and statistical analysis of large files.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: Okeysir198

byOkeysir198

0•

Data Science & ML

Automates the creation, formatting, and analysis of professional-grade Excel spreadsheets and financial models.

This skill empowers Claude to perform advanced spreadsheet operations, including generating complex financial models with industry-standard color coding, performing data analysis using pandas, and ensuring formula integrity. It supports various formats like .xlsx and .csv, allows for dynamic formula calculation via LibreOffice integration, and strictly adheres to formatting conventions like blue-text for inputs and black-text for formulas to maintain professional standards. Whether you are building a valuation model or processing large datasets, this skill ensures zero formula errors and preserves existing template conventions.

Key Features

010 GitHub stars

02Automated spreadsheet creation and editing with openpyxl and pandas integration.

03Preservation of existing template styles and conventions during file modifications.

04Dynamic formula recalculation and error verification using automated LibreOffice scripts.

05Industry-standard financial modeling with specific color-coding and number formatting.

06Comprehensive data analysis and visualization capabilities for large datasets.

Use Cases

01Generating dynamic financial models with automated projections and valuation multiples.

02Updating existing corporate Excel templates while maintaining original formatting and formula structures.

03Analyzing and cleaning large CSV or Excel datasets using programmatic data manipulation.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add okeysir198/p20251122-claude-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill