Can this skill handle complex Excel formulas?

Yes, it supports full formula construction using openpyxl and includes a mandatory recalculation script to ensure all formulas resolve correctly without errors.

What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv formats for comprehensive reading, writing, and data manipulation operations.

Does it follow financial modeling standards?

Yes, the skill enforces industry-standard color coding (blue for inputs, black for formulas) and specific number formatting for currencies, percentages, and valuation multiples.

How does it ensure formulas are not broken after editing?

It utilizes a recalc.py script that leverages LibreOffice to verify all cell references and identifies errors like #REF! or #VALUE! before finalizing the file.

Can I use this for data visualization within spreadsheets?

Absolutely. It leverages pandas for data processing and openpyxl for applying visual formatting, cell fills, and structural layouts to create presentation-ready workbooks.

Excel Spreadsheet Management & Analysis

Name: Excel Spreadsheet Management & Analysis
Author: ttmouse

byttmouse

•

Ciencia de Datos y ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV processing to building sophisticated financial models. It ensures data integrity by enforcing zero-error formula policies and adhering to industry-standard formatting conventions like specific color coding for inputs and calculations. Whether you are generating data-heavy reports with pandas, applying granular styles with openpyxl, or recalculating dynamic formulas via LibreOffice integration, this skill provides a robust, production-ready framework for professional Excel automation and data visualization.

Características Principales

01Advanced formula creation and verification with zero-error enforcement (#REF!, #DIV/0!)

02Seamless integration with pandas for data analysis and openpyxl for structural styling

03Intelligent template preservation that matches existing styles and conventions

04Automated formula recalculation using a specialized LibreOffice-based script

05Industry-standard financial modeling color coding and professional number formatting

0631 GitHub stars

Casos de Uso

01Building dynamic financial models with standardized assumptions, formatting, and source documentation

02Automating the generation of recurring business reports while maintaining complex, updateable formula chains

03Analyzing and visualizing large datasets from CSV or XLSX files using automated pandas workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ttmouse/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill