Which Python libraries does it use?

It utilizes pandas for data-heavy analysis and bulk operations, and openpyxl for maintaining complex formatting and cell-level formula logic.

How does it handle formula errors?

It uses a specialized recalculation script and LibreOffice to identify and fix errors like #REF!, #DIV/0!, and #VALUE! before delivery.

Why use formulas instead of hardcoding values?

Using formulas ensures the spreadsheet remains dynamic, allowing users to update input data and see immediate recalculations without needing to rerun scripts.

Does this skill support existing Excel templates?

Yes, it is designed to study and exactly match existing formats, styles, and conventions when modifying established files.

Can I use it for financial modeling?

Absolutely. It follows industry-standard color conventions (blue for inputs, black for formulas) and strict number formatting rules for professional output.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: horuz-ai

byhoruz-ai

0•

Ciencia de Datos y ML

Manages complex Excel workbooks with automated formula creation, financial modeling standards, and data analysis.

This skill empowers Claude to handle advanced spreadsheet tasks including creating, editing, and analyzing .xlsx and .csv files while strictly adhering to professional financial modeling standards. It features unique capabilities like automated formula recalculation via LibreOffice to ensure zero formula errors, and sophisticated data manipulation using pandas and openpyxl. Whether building dynamic financial models from scratch or auditing existing templates, it prioritizes formula-driven logic over hardcoded values to maintain data integrity and workbook flexibility.

Características Principales

01Automated formula recalculation and error verification using LibreOffice integration

020 GitHub stars

03Strict template preservation to maintain existing styles and conventions

04Advanced financial modeling with industry-standard color coding and formatting

05Seamless integration of pandas for data analysis and openpyxl for cell formatting

06Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file formats

Casos de Uso

01Analyzing and cleaning large datasets within existing spreadsheet templates

02Auditing workbooks to identify and fix formula errors like #REF! or #NAME?

03Building dynamic financial projections with automated assumptions and growth rates

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add horuz-ai/claude-plugins xlsx

For use in Claude.ai and ChatGPT

Download Skill