Will it break my existing spreadsheet formatting?

No. The skill is instructed to study and exactly match existing styles, conventions, and patterns when modifying established templates.

Does it follow standard financial modeling conventions?

Yes. By default, it uses industry-standard color coding: blue for hardcoded inputs, black for formulas, green for internal links, and red for external references.

Can I use it to analyze large datasets?

Absolutely. It leverages the pandas library for efficient reading, filtering, and statistical analysis of XLSX, CSV, and TSV files.

How does this skill handle Excel formulas?

The skill uses openpyxl to write formulas as strings rather than hardcoding values. It then uses a LibreOffice-powered script to recalculate the workbook, ensuring all formulas are active and accurate.

What happens if there is a formula error like #REF! or #DIV/0!?

The skill includes a mandatory verification step using a recalculation script that scans for errors and provides a detailed JSON summary to help Claude identify and fix them immediately.

Excel & Financial Modeling Pro

Name: Excel & Financial Modeling Pro
Author: mrgoonie

bymrgoonie

•

1,395

•

Productivity & Workflow

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

This skill empowers Claude to perform sophisticated spreadsheet operations, ranging from high-performance data analysis using pandas to complex workbook construction with openpyxl. It ensures production-grade quality by enforcing strict financial modeling standards—including specific color-coding for inputs and formulas—and utilizing a mandatory LibreOffice-backed recalculation engine to eliminate formula errors. Whether generating dynamic financial reports, auditing existing workbooks, or visualizing datasets, this skill maintains spreadsheet integrity by prioritizing live formulas over hardcoded values and preserving existing template conventions.

Key Features

01Advanced data manipulation and visualization using pandas integration

02Automated formula recalculation and error detection via LibreOffice

031,395 GitHub stars

04Dynamic Excel creation and editing with openpyxl formula persistence

05Industry-standard financial modeling (color-coding and number formatting)

06Intelligent template matching and style preservation for existing files

Use Cases

01Cleaning and analyzing large CSV/XLSX datasets to generate executive summaries

02Updating corporate spreadsheet templates while maintaining strict formatting rules

03Building automated financial models with dynamic projections and scenario analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mrgoonie/claudekit-skills document-skills

For use in Claude.ai and ChatGPT

Download Skill