How does it handle complex calculations?

The skill prioritizes using native Excel formulas over hardcoded Python results. This ensures that the resulting spreadsheet remains dynamic and can update itself when users change input values.

Can it maintain existing Excel templates?

Yes, the skill is designed to study and match established formats, styles, and conventions, ensuring that modifications to existing templates preserve the original professional look and feel.

How does this skill handle formula errors?

It uses a specialized recalc.py script that leverages LibreOffice to recalculate all formulas and scan for errors like #REF!, #DIV/0!, and #VALUE!, providing a detailed report to ensure every deliverable is error-free.

Does it support professional financial modeling standards?

Absolutely. It follows industry conventions such as blue text for hardcoded inputs, black for formulas, and green for internal links, along with specific rules for currency and percentage formatting.

Comprehensive Excel & Spreadsheet Management

Name: Comprehensive Excel & Spreadsheet Management
Author: kivilaid

bykivilaid

•

Productivity & Workflow

Creates, edits, and analyzes complex Excel spreadsheets with a focus on dynamic formulas, financial modeling standards, and automated data processing.

This skill empowers Claude to handle sophisticated spreadsheet tasks by integrating Python libraries like pandas and openpyxl with a robust recalculation engine. It ensures professional-grade output by enforcing financial modeling standards—including industry-standard color coding and number formatting—while strictly avoiding hardcoded values in favor of dynamic Excel formulas. Whether you need to generate a complex financial model from scratch, analyze large datasets, or update existing templates without breaking formats, this skill provides the tools and guardrails necessary for error-free spreadsheet automation within the Claude Code environment.

Key Features

01Dynamic formula generation to replace hardcoded values

02Financial modeling standards with automated color-coding and formatting

03Integration with pandas for high-performance data analysis and visualization

04Automated formula recalculation and error detection via LibreOffice integration

05Preservation of existing styles and conventions in legacy templates

066 GitHub stars

Use Cases

01Automating the extraction of data from various sources into professional, formatted Excel reports

02Cleaning and analyzing large CSV or XLSX datasets with Python-powered data manipulation

03Building dynamic financial models with industry-standard formatting and assumption tracking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kivilaid/plugin-marketplace document-processing

For use in Claude.ai and ChatGPT

Download Skill