Can Claude recalculate formulas in Excel files using this skill?

Yes, the skill includes a specialized recalculation script that uses LibreOffice to evaluate all formulas and verify that no calculation errors like #REF! or #DIV/0! exist.

How does it handle data analysis versus spreadsheet creation?

It uses a hybrid approach: pandas for high-performance data analysis and visualization, and openpyxl for tasks requiring formula preservation and specific cell styling.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and match existing styles, ensuring that template conventions are preserved and not replaced by generic formatting.

Does this skill support industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links to ensure professional financial model standards.

Advanced Excel & Spreadsheet Engineer

Name: Advanced Excel & Spreadsheet Engineer
Author: kjgarza

bykjgarza

0•

データサイエンスとML

Provides comprehensive spreadsheet creation, financial modeling, and data analysis with strict formula preservation and industry-standard formatting.

This skill transforms Claude into a sophisticated spreadsheet architect capable of building, auditing, and analyzing complex Excel workbooks. It enforces high-fidelity financial modeling practices, including specific color-coding for inputs and calculations, and ensures zero formula errors through an integrated LibreOffice recalculation engine. By combining pandas for data manipulation and openpyxl for cell-level formatting, it allows Claude to generate dynamic, production-ready spreadsheets that maintain logical integrity and professional aesthetic standards.

主な機能

01Support for complex Excel features including formulas, styles, conditional formatting, and cell comments.

02Hybrid data processing using pandas for analysis and openpyxl for preserved workbook logic.

03Dynamic spreadsheet construction that replaces hardcoded values with updateable cell references.

040 GitHub stars

05Industry-standard financial modeling with automated color-coding (Blue for inputs, Black for formulas).

06Automated formula recalculation and error detection via LibreOffice-powered verification.

ユースケース

01Updating corporate spreadsheet templates while strictly preserving existing brand styles and conventions.

02Auditing and repairing broken Excel files by identifying #REF!, #DIV/0!, and circular references.

03Building automated financial models with standard currency, multiple, and percentage formatting.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kjgarza/marketplace-claude xlsx

For use in Claude.ai and ChatGPT

Download Skill