Does it follow standard financial modeling conventions?

Yes, it enforces industry standards such as blue text for hardcoded inputs, black for formulas, and specific formatting for currency, percentages, and multiples.

Can I add visual diagrams to my spreadsheets?

Yes, the skill integrates with scientific-schematics to generate AI-powered, publication-quality diagrams that illustrate data flows or model structures.

How does this skill handle Excel formula errors?

The skill includes a mandatory verification step using a recalculation script that identifies #REF!, #DIV/0!, and other errors, ensuring every delivered spreadsheet is mathematically sound.

What Python libraries does this skill use?

It utilizes pandas for heavy data manipulation and analysis, and openpyxl for preserving complex formatting, styles, and Excel-specific features like formulas.

Excel & Spreadsheet Power Tools

Name: Excel & Spreadsheet Power Tools
Author: Sologa

bySologa

0•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with dynamic formulas and industry-standard formatting.

The xlsx skill is a comprehensive toolkit for handling .xlsx and .csv files within the Claude Code environment, specifically designed for high-stakes spreadsheet tasks. It prioritizes data integrity by enforcing a zero-formula-error policy, supported by a mandatory recalculation script that uses LibreOffice to validate outputs. Beyond basic data manipulation with pandas and openpyxl, it applies rigorous industry standards for financial modeling—including specific color-coding for inputs and formulas—and even integrates AI-powered scientific schematics to enhance visual documentation. This skill is essential for developers and analysts who need to generate publication-quality reports, complex financial models, and automated data pipelines without manual spreadsheet oversight.

Key Features

01Zero-error formula validation via automated recalculation scripts

02Scientific schematic integration for visual data storytelling

03Industry-standard financial modeling color-coding and formatting

04Dynamic formula generation to replace hardcoded Python values

050 GitHub stars

06Seamless hybrid workflow using pandas for data and openpyxl for formatting

Use Cases

01Generating complex data processing pipelines that include visual flowcharts and architectural diagrams

02Building investment-grade financial models with standardized color-coded inputs and assumptions

03Automating the transformation of raw CSV data into formatted, formula-driven executive reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sologa/codex-pipeline xlsx

For use in Claude.ai and ChatGPT

Download Skill