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.

About

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

Advanced data manipulation and visualization using pandas integration
Automated formula recalculation and error detection via LibreOffice
1,395 GitHub stars
Dynamic Excel creation and editing with openpyxl formula persistence
Industry-standard financial modeling (color-coding and number formatting)
Intelligent template matching and style preservation for existing files

Use Cases

Cleaning and analyzing large CSV/XLSX datasets to generate executive summaries
Updating corporate spreadsheet templates while maintaining strict formatting rules
Building automated financial models with dynamic projections and scenario analysis

About

Key Features

Advanced data manipulation and visualization using pandas integration
Automated formula recalculation and error detection via LibreOffice
1,395 GitHub stars
Dynamic Excel creation and editing with openpyxl formula persistence
Industry-standard financial modeling (color-coding and number formatting)
Intelligent template matching and style preservation for existing files

Use Cases

Cleaning and analyzing large CSV/XLSX datasets to generate executive summaries
Updating corporate spreadsheet templates while maintaining strict formatting rules
Building automated financial models with dynamic projections and scenario analysis