How does the skill ensure formula accuracy?

It utilizes a mandatory recalculation script (recalc.py) that runs the file through a LibreOffice engine to detect and report errors like #REF!, #DIV/0!, and #VALUE! before finalizing the document.

Does it support data visualization?

Beyond standard Excel charts, the skill can generate scientific schematics to visually represent data processing pipelines and complex formula relationships within your documentation.

Can I use this for professional financial modeling?

Yes. The skill strictly follows industry standards, including blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring the output is ready for corporate environments.

Which Python libraries are used for spreadsheet tasks?

The skill uses pandas for high-performance data manipulation and analysis, and openpyxl for tasks requiring specific cell formatting, styles, and formula preservation.

Excel & Data Spreadsheet Toolkit

Name: Excel & Data Spreadsheet Toolkit
Author: BbgnsurfTech

byBbgnsurfTech

•

데이터 과학 및 ML

Creates, edits, and analyzes Excel spreadsheets with production-grade formulas, formatting, and rigorous error validation.

This specialized skill enables Claude to manage complex spreadsheet lifecycles, from initial data ingestion to publication-quality financial modeling. It ensures absolute data integrity by enforcing zero-error formula policies and utilizing mandatory recalculation scripts via LibreOffice. Beyond simple data entry, the skill applies industry-standard formatting conventions—such as specific color-coding for hardcodes versus formulas—and can even generate scientific schematics to visualize data workflows. Whether you're performing bulk data analysis with pandas or granular cell formatting with openpyxl, this toolkit provides a robust framework for professional spreadsheet engineering.

주요 기능

01AI-powered scientific schematic generation for visualizing data pipelines

023 GitHub stars

03Strict documentation requirements for hardcoded values and data sources

04Dual-library support using pandas for analysis and openpyxl for formatting

05Automated formula recalculation and error validation using LibreOffice

06Industry-standard financial modeling color-coding and number formatting

사용 사례

01Automating complex data cleaning and transformation workflows into formatted Excel reports

02Maintaining and updating existing enterprise spreadsheet templates without breaking styles

03Building dynamic, audit-ready financial models with automated error checking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection xlsx

For use in Claude.ai and ChatGPT

Download Skill