What file formats are supported?

The skill comprehensively supports .xlsx, .xlsm, .csv, and .tsv files for both reading and writing operations.

Does this skill support complex Excel formulas?

Yes, it supports full formula construction and includes a recalculation script to ensure all formulas are evaluated correctly rather than being hardcoded.

How does the skill ensure formula accuracy?

The skill uses a dedicated recalculation script that scans for errors like #REF!, #DIV/0!, and #VALUE!, returning a detailed report to fix issues before delivery.

Can I update existing templates without losing formatting?

Yes, the skill is designed to study and exactly match existing formats, styles, and conventions of your templates, ensuring new data blends perfectly with existing patterns.

Can it handle financial modeling standards?

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

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: organvm-iv-taxis

byorganvm-iv-taxis

•

数据科学与机器学习

Automates the creation, modification, and analysis of professional Excel spreadsheets with dynamic formulas and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from generating financial models with industry-standard color coding to performing deep data analysis using pandas. It ensures data integrity by enforcing zero-error formula policies and utilizing a specialized recalculation engine backed by LibreOffice to verify results. Whether building new workbooks from scratch or updating existing templates while preserving formatting, this tool provides a robust framework for professional-grade Excel automation and reliable data management.

主要功能

01Advanced data visualization and statistical analysis capabilities

02Automated spreadsheet creation and editing using openpyxl and pandas

032 GitHub stars

04Strict preservation of existing template styles and conventions

05Industry-standard financial modeling color coding and number formatting

06Zero-error formula verification and recalculation via LibreOffice integration

使用场景

01Updating existing enterprise Excel templates while maintaining structural and styling integrity

02Generating dynamic financial projection models with automated assumptions and links

03Cleaning and analyzing large datasets from CSV/TSV files into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add organvm-iv-taxis/a-i--skills xlsx

For use in Claude.ai and ChatGPT