What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv files, covering both modern Excel workbooks and standard flat-file data formats.

Does it follow professional financial modeling standards?

Absolutely. It adheres to industry conventions, such as blue text for hardcoded inputs, black for formulas, and green for internal links to ensure models are audit-ready.

Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying files, ensuring template integrity is maintained.

Can this skill handle complex Excel formulas?

Yes, it supports full Excel formula construction and provides a recalculation engine via LibreOffice to ensure accuracy and identify errors like #REF! or #DIV/0!.

How does it handle large datasets?

It utilizes the pandas library for efficient data manipulation, allowing for high-performance reading, cleaning, and statistical analysis of large files.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: Okeysir198

byOkeysir198

数据科学与机器学习

Automates the creation, formatting, and analysis of professional-grade Excel spreadsheets and financial models.

关于

This skill empowers Claude to perform advanced spreadsheet operations, including generating complex financial models with industry-standard color coding, performing data analysis using pandas, and ensuring formula integrity. It supports various formats like .xlsx and .csv, allows for dynamic formula calculation via LibreOffice integration, and strictly adheres to formatting conventions like blue-text for inputs and black-text for formulas to maintain professional standards. Whether you are building a valuation model or processing large datasets, this skill ensures zero formula errors and preserves existing template conventions.

主要功能

0 GitHub stars
Automated spreadsheet creation and editing with openpyxl and pandas integration.
Preservation of existing template styles and conventions during file modifications.
Dynamic formula recalculation and error verification using automated LibreOffice scripts.
Industry-standard financial modeling with specific color-coding and number formatting.
Comprehensive data analysis and visualization capabilities for large datasets.

使用场景

Generating dynamic financial models with automated projections and valuation multiples.
Updating existing corporate Excel templates while maintaining original formatting and formula structures.
Analyzing and cleaning large CSV or Excel datasets using programmatic data manipulation.

关于

主要功能

0 GitHub stars
Automated spreadsheet creation and editing with openpyxl and pandas integration.
Preservation of existing template styles and conventions during file modifications.
Dynamic formula recalculation and error verification using automated LibreOffice scripts.
Industry-standard financial modeling with specific color-coding and number formatting.
Comprehensive data analysis and visualization capabilities for large datasets.

使用场景

Generating dynamic financial models with automated projections and valuation multiples.
Updating existing corporate Excel templates while maintaining original formatting and formula structures.
Analyzing and cleaning large CSV or Excel datasets using programmatic data manipulation.