Does it preserve my existing Excel formatting?

Absolutely. The skill is designed to study and match existing template conventions, styles, and formatting when modifying your files.

Can I use this for professional financial modeling?

Yes, it follows industry standards such as blue text for inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

Do I need any external software for this to work?

For full formula recalculation and error checking, the skill utilizes LibreOffice, which is automatically configured to handle the calculation engine.

How does this skill handle Excel formula errors?

The skill includes a mandatory recalculation workflow using a specialized script that detects and reports common errors like #REF!, #DIV/0!, and #VALUE! before the file is finalized.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: macnversion

bymacnversion

0•

Data Science & ML

Automates advanced spreadsheet creation, financial modeling, and data analysis with support for dynamic formulas and professional formatting.

This skill transforms Claude into a high-level financial analyst and data engineer, enabling the creation and manipulation of sophisticated Excel workbooks. It enforces rigorous financial modeling standards, including industry-standard color coding and precise number formatting, while ensuring zero formula errors through an integrated LibreOffice recalculation engine. By combining the data processing power of pandas with the formatting precision of openpyxl, it allows users to build dynamic models, analyze large datasets, and modify existing templates without compromising style or structural integrity.

Key Features

01Multi-format support for .xlsx, .xlsm, .csv, and .tsv files

02Industry-standard financial modeling with automated color coding and formatting

030 GitHub stars

04Automated formula recalculation and validation via LibreOffice integration

05Preservation of existing styles and conventions when modifying templates

06Deep data analysis and visualization capabilities using pandas and openpyxl

Use Cases

01Updating corporate Excel templates while maintaining formula integrity and structural consistency

02Building dynamic three-statement financial models with automated projections and assumption cells

03Performing complex data cleaning and generating professionally formatted reports from raw data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add macnversion/skills xlsx

For use in Claude.ai and ChatGPT

Download Skill