Can it detect and fix spreadsheet errors?

Yes, it includes a mandatory recalculation and verification step that identifies errors like #REF!, #DIV/0!, and #VALUE! before delivering the final file.

Which file formats are supported?

The skill supports a wide range of spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv.

Does this skill support existing Excel templates?

Yes, it is specifically designed to study and match existing formats, styles, and conventions when modifying your files to ensure seamless integration.

How are formulas handled compared to hardcoded values?

The skill strictly prioritizes native Excel formulas over calculating values in Python, ensuring your spreadsheets remain dynamic and functional for the end-user.

What financial modeling standards does it follow?

It uses industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

Excel Spreadsheet Operations

Name: Excel Spreadsheet Operations
Author: kivilaid

bykivilaid

•

Data Science & ML

Automates the creation, editing, and analysis of Excel spreadsheets with support for complex formulas and industry-standard financial modeling.

This skill provides a comprehensive toolkit for managing spreadsheet workflows within Claude Code, covering everything from basic CSV parsing to the construction of professional financial models. It ensures data integrity by prioritizing native Excel formulas over hardcoded values, maintains existing template conventions, and utilizes a dedicated recalculation engine to identify and eliminate formula errors. By combining the data processing power of pandas with the precise formatting capabilities of openpyxl, it enables Claude to deliver production-ready workbooks that follow strict industry standards for color coding, number formatting, and documentation.

Key Features

01Automated formula recalculation and validation to eliminate #REF! and #DIV/0! errors

02Intelligent template preservation that respects existing styles and conventions

03Professional financial modeling standards including industry-standard color coding

046 GitHub stars

05Native Excel formula integration to ensure dynamic, updateable workbooks

06Support for advanced data analysis and visualization using pandas and openpyxl

Use Cases

01Generating complex financial projection models with automated scenario analysis

02Analyzing large datasets to create formatted summary reports and visualizations

03Bulk updating existing Excel workbooks while preserving formulas and formatting

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