Can it follow professional financial modeling standards?

Absolutely. It follows industry-standard color conventions (Blue for inputs, Black for formulas, Green for internal links) and specific formatting for currencies, percentages, and multiples.

Will it ruin the formatting of my existing Excel templates?

No. The skill is designed to study and match existing formats, styles, and conventions, ensuring that template-specific patterns override standard guidelines.

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

The skill utilizes a mandatory recalculation workflow that scans every cell for errors after modification, providing a detailed JSON summary of any issues found for immediate correction.

Does this skill support complex Excel formulas?

Yes, it prioritizes Excel formulas over hardcoded values to ensure your spreadsheets remain dynamic. It includes a recalculation script to update values and verify formula integrity.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: ComposioHQ

byComposioHQ

•

7,895

•

Productivity & Workflow

Creates, edits, and analyzes professional spreadsheets with dynamic formulas, financial modeling standards, and automated recalculation.

This skill empowers Claude to perform high-level spreadsheet engineering, ranging from simple data entry to complex financial modeling. By utilizing pandas for data analysis and openpyxl for precise formatting, it ensures that spreadsheets remain dynamic through the use of Excel formulas rather than hardcoded values. It strictly adheres to industry standards for financial reporting—including specific color-coding for inputs and calculations—and features a robust verification workflow using LibreOffice to recalculate and validate formulas, ensuring error-free deliverables in .xlsx, .csv, and .tsv formats.

Key Features

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

02Template preservation logic that matches existing styles and conventions when modifying files.

03Automated formula recalculation and error detection (#REF!, #DIV/0!) using LibreOffice integration.

04Advanced data manipulation and visualization capabilities powered by pandas.

05Industry-standard financial modeling with specific text color-coding and number formatting.

067,895 GitHub stars

Use Cases

01Modifying complex enterprise spreadsheet templates while maintaining formatting and formula integrity.

02Cleaning and analyzing large datasets from CSV/XLSX files to generate summary reports.

03Building automated financial models with separate assumption sections and dynamic projections.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add composiohq/awesome-claude-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill