How does this skill handle Excel formulas?

It prioritizes dynamic Excel formulas over hardcoded Python values to ensure workbooks remain updateable, and uses a LibreOffice-based script to recalculate and verify results.

Does it support professional financial modeling standards?

Yes, it implements industry conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for multiples (0.0x) and negative numbers.

Can I use this to modify existing Excel templates?

Absolutely. The skill is designed to study and match existing formats and styles, ensuring that template conventions always override default guidelines during updates.

How are formula errors prevented?

The skill utilizes a 'recalc.py' script that scans all cells for errors like #REF!, #DIV/0!, and #VALUE!, providing a JSON summary of any issues that need fixing.

Which Python libraries are used for processing?

The skill primarily uses pandas for heavy data manipulation and analysis, and openpyxl for complex formatting, styles, and preserving workbook structure.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: nguyendinhquocx

bynguyendinhquocx

0•

Data Science & ML

Automates professional-grade spreadsheet creation, financial modeling, and data analysis with formula preservation and industry-standard formatting.

This skill empowers Claude to interact deeply with .xlsx, .xlsm, and CSV files, moving beyond simple data export to sophisticated workbook management. It ensures structural integrity by using native Excel formulas instead of hardcoded values and incorporates a mandatory recalculation engine via LibreOffice to verify formula accuracy. Designed with high-stakes financial environments in mind, it follows strict industry conventions for color-coding inputs and calculations while providing robust data manipulation and visualization capabilities through integrated pandas and openpyxl workflows.

Key Features

01Automated formula creation and verification with zero-error enforcement for #REF! and #DIV/0!.

02Professional financial modeling standards including industry-standard color-coding and number formatting.

03Seamless data analysis and visualization using pandas and openpyxl integration.

04Precise template preservation that maintains existing styles and conventions during modifications.

05Integrated formula recalculation and error reporting using specialized LibreOffice scripts.

060 GitHub stars

Use Cases

01Generating dynamic financial models with automated projections, assumptions, and scenario analysis.

02Transforming raw data from CSV or TSV formats into formatted, presentation-ready Excel reports.

03Updating existing corporate templates while maintaining complex cell references and established formatting.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai xlsx

For use in Claude.ai and ChatGPT

Download Skill