Does this skill support existing Excel formulas?

Yes, it is designed to read, preserve, and modify existing formulas using openpyxl, ensuring that spreadsheets remain dynamic rather than static.

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

The skill includes a mandatory recalculation step using a LibreOffice-based script (recalc.py) that scans all cells for errors and requires fixes before the file is considered complete.

Is it better for data processing or visual formatting?

It excels at both by using pandas for efficient data manipulation and openpyxl for granular control over fonts, colors, borders, and cell alignment.

Can I use this for professional financial models?

Absolutely. The skill follows industry-standard conventions such as blue text for hardcoded inputs and black text for formulas, and enforces strict documentation for data sources.

Do I need any external software to use the recalculation feature?

Yes, it assumes LibreOffice is installed. The recalc.py script automatically configures the necessary environment to evaluate formulas and detect errors across all worksheets.

Excel & Spreadsheet Expert

Name: Excel & Spreadsheet Expert
Author: macnversion

bymacnversion

0•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and industry-standard financial modeling.

This skill provides a robust framework for Claude to interact with Excel files (.xlsx, .xlsm, .csv) at a professional level. It goes beyond simple data dumping by enforcing strict financial modeling standards, such as color-coding hardcodes and formulas, preserving existing template styles, and ensuring zero formula errors through automated LibreOffice recalculation. By combining the data processing power of pandas with the granular formatting capabilities of openpyxl, it allows for the generation of dynamic, production-ready workbooks that are ready for immediate corporate use.

Key Features

01Automated formula verification and error detection using LibreOffice integration

020 GitHub stars

03Industry-standard financial model formatting and color-coding conventions

04Smart template preservation that respects existing workbook styles

05Comprehensive support for data analysis, visualization, and multi-sheet management

06Dynamic formula construction to avoid brittle hardcoded values

Use Cases

01Performing complex data analysis on large datasets and exporting results to formatted Excel reports

02Building automated financial projection models with separate assumption sheets and dynamic growth rates

03Updating corporate spreadsheet templates while maintaining strict adherence to existing formatting patterns

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