Can this skill handle complex Excel formulas?

Yes, the skill prioritizes Excel formulas over hardcoded values and includes a mandatory recalculation step to ensure all logic is dynamic and error-free.

Does it support industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

Can I use it to modify existing Excel templates?

Yes, the skill is designed to study and exactly match existing formats and styles, ensuring that your established template conventions are always preserved.

How does it prevent formula errors like #REF! or #DIV/0!?

It uses a specialized recalculation script powered by LibreOffice that scans every cell for errors and returns a detailed report for automated fixing.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: kivilaid

bykivilaid

•

Data Science & ML

Automates the creation, editing, and analysis of Excel spreadsheets with a focus on dynamic formulas and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV processing to building sophisticated financial models. It ensures data integrity by prioritizing Excel formulas over hardcoded values and includes a dedicated verification process using LibreOffice to recalculate and validate every cell. Whether you are generating reports from data frames using pandas or applying professional formatting with openpyxl, this skill maintains industry-standard conventions for color coding, number formatting, and structural documentation, making it indispensable for data-driven workflows.

Key Features

01Professional financial modeling standards for color coding and formatting

02Advanced spreadsheet creation and editing using openpyxl and pandas

03Comprehensive data analysis and visualization capabilities

046 GitHub stars

05Automatic formula recalculation and error detection via LibreOffice

06Intelligent preservation of existing workbook templates and styles

Use Cases

01Building dynamic financial models with automated scenario analysis and standardized formatting

02Transforming raw data sets into formatted, boardroom-ready Excel reports with charts

03Updating existing complex spreadsheets while preserving original formulas and structure

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kivilaid/plugin-marketplace xlsx

For use in Claude.ai and ChatGPT

Download Skill