What file formats are supported?

It provides comprehensive support for .xlsx, .xlsm, .csv, and .tsv files, including reading, editing, and creating new workbooks from scratch.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values, allowing spreadsheets to recalculate automatically when source data changes.

Does it preserve existing spreadsheet templates?

Yes, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying established files rather than imposing new ones.

How does it ensure there are no formula errors?

The skill utilizes a mandatory recalculation workflow that scans every cell for errors like #REF!, #DIV/0!, and #VALUE!, providing a detailed summary to fix issues before delivery.

Can it handle professional financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for valuation multiples and currency.

Excel & Spreadsheet Specialist

Name: Excel & Spreadsheet Specialist
Author: amano--

byamano--

0•

生产力与工作流

Automates professional spreadsheet creation, complex financial modeling, and data analysis with dynamic formulas and industry-standard formatting.

This skill transforms Claude into a sophisticated spreadsheet engineer capable of generating, modifying, and analyzing Excel files with high precision. It handles everything from basic CSV manipulation to building intricate financial models that follow strict industry-standard color coding and formatting conventions. By leveraging pandas for data processing and openpyxl for structural integrity, the skill ensures that all calculations remain dynamic through Excel formulas rather than static values. It includes a robust verification workflow using LibreOffice to recalculate formulas and eliminate common errors like #REF! or #DIV/0!, ensuring every output is production-ready.

主要功能

010 GitHub stars

02Template preservation that matches existing styles and conventions during modifications.

03Automated formula verification and recalculation to eliminate spreadsheet errors.

04Dual-engine support using pandas for analysis and openpyxl for precise formatting.

05Industry-standard financial modeling with strict color-coding for inputs and calculations.

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

使用场景

01Analyzing large datasets and exporting formatted, formula-driven reports to Excel.

02Building automated financial projection models with standardized accounting formats.

03Updating existing enterprise templates while preserving original styles and complex cell dependencies.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add amano--/call-center document-skills

For use in Claude.ai and ChatGPT

Download Skill