What libraries does this skill use for spreadsheet operations?

It leverages pandas for high-speed data analysis and openpyxl for tasks requiring complex formatting, formulas, and precise Excel-specific features.

Can I use it to update existing Excel templates?

Yes, the skill is designed to analyze existing workbooks and match their specific styles, conventions, and formatting patterns without overriding them.

Can this skill handle complex Excel formulas?

Yes, it prioritizes writing native Excel formulas over hardcoded Python results to ensure your spreadsheets remain dynamic and recalculate correctly when data changes.

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

The skill utilizes a mandatory recalculation workflow via LibreOffice and a custom script to verify all cell references and formula logic before the file is finalized.

Does it support professional financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and strict number formatting (currency units, multiples, and accounting zeros).

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: zhu1090093659

byzhu1090093659

•

Productivity & Workflow

Automates comprehensive spreadsheet creation, data analysis, and professional financial modeling using Excel formulas and Python integration.

This skill empowers Claude to act as a sophisticated spreadsheet engineer, capable of creating, editing, and analyzing .xlsx, .csv, and .tsv files with high precision. It bridges the gap between Python's data manipulation libraries (pandas, openpyxl) and native Excel functionality by prioritizing dynamic formulas over hardcoded values. Whether building complex financial models with industry-standard color coding or performing deep data analysis, the skill ensures data integrity through a mandatory formula recalculation and error-checking workflow using LibreOffice, delivering error-free models suitable for professional environments.

Key Features

01Support for multi-sheet workbooks, data visualization, and comprehensive documentation of assumptions.

02Dynamic formula generation to ensure spreadsheets remain interactive and updateable.

03Automated formula recalculation and error detection to eliminate #REF! and #DIV/0! errors.

0465 GitHub stars

05Professional financial modeling standards including specific color coding and number formatting.

06Seamless integration with pandas for data analysis and openpyxl for complex formatting.

Use Cases

01Automating the cleaning and analysis of large CSV datasets into polished, formatted Excel reports.

02Updating existing corporate Excel templates while strictly preserving original styles and formula logic.

03Building investment-grade financial models with standardized formatting and dynamic projections.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhu1090093659/codeconductor xlsx

For use in Claude.ai and ChatGPT

Download Skill