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

•

数据科学与机器学习

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.

主要功能

Automated formula recalculation and validation to eliminate #REF! and #DIV/0! errors
Intelligent template preservation that respects existing styles and conventions
Professional financial modeling standards including industry-standard color coding
6 GitHub stars
Native Excel formula integration to ensure dynamic, updateable workbooks
Support for advanced data analysis and visualization using pandas and openpyxl

使用场景

Generating complex financial projection models with automated scenario analysis
Analyzing large datasets to create formatted summary reports and visualizations
Bulk updating existing Excel workbooks while preserving formulas and formatting

关于

主要功能

Automated formula recalculation and validation to eliminate #REF! and #DIV/0! errors
Intelligent template preservation that respects existing styles and conventions
Professional financial modeling standards including industry-standard color coding
6 GitHub stars
Native Excel formula integration to ensure dynamic, updateable workbooks
Support for advanced data analysis and visualization using pandas and openpyxl

使用场景

Generating complex financial projection models with automated scenario analysis
Analyzing large datasets to create formatted summary reports and visualizations
Bulk updating existing Excel workbooks while preserving formulas and formatting