Will it overwrite my existing spreadsheet formatting?

No, the skill is specifically instructed to study and match existing styles, formats, and conventions when modifying existing templates.

Can it handle professional financial modeling standards?

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

Does it require any external software?

It relies on LibreOffice for formula recalculation via a Python script, which is automatically configured upon the first run within your environment.

Does this skill support complex Excel formulas?

Yes, it uses openpyxl to write formulas and an integrated recalculation script to ensure all values are correctly updated and verified for errors like #REF! or #DIV/0!.

Advanced Excel & Spreadsheet Automator

Name: Advanced Excel & Spreadsheet Automator
Author: CongDon1207

byCongDon1207

•

Data Science & ML

Automates the creation, editing, and analysis of professional spreadsheets with support for complex formulas and financial modeling standards.

This skill empowers Claude to handle comprehensive spreadsheet tasks ranging from simple CSV processing to complex financial modeling in .xlsx format. It ensures formula integrity by using automated recalculation tools, adheres to industry-standard formatting (like color-coding for hardcodes vs. formulas), and provides robust data analysis capabilities using pandas and openpyxl. It is particularly useful for developers and analysts who need to programmatically generate production-ready Excel files that remain dynamic and updateable rather than containing static values.

Key Features

01Industry-standard financial model formatting including color-coded inputs and formulas

02Preservation of existing styles and conventions when modifying established templates

031 GitHub stars

04Automated formula recalculation and error verification using LibreOffice integration

05Sophisticated data analysis and visualization using the pandas library

06Support for various formats including .xlsx, .xlsm, .csv, and .tsv

Use Cases

01Updating legacy Excel templates while maintaining original branding and formula structures

02Analyzing large datasets to generate formatted reports with charts and statistical summaries

03Building automated financial models with dynamic projections and assumption-based calculations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add congdon1207/agents.md document-skills

For use in Claude.ai and ChatGPT

Download Skill