Does this skill support live Excel formulas?

Yes, it prioritizes creating dynamic Excel formulas over hardcoding values, ensuring the spreadsheet remains functional and updateable by the end user.

Can it follow specific financial modeling standards?

Absolutely. It follows industry-standard color coding: blue for hardcoded inputs, black for formulas, green for internal links, and red for external links.

What file formats are supported?

The skill is designed to handle .xlsx, .xlsm, .csv, and .tsv files, including cross-conversion between these formats.

How does it ensure there are no formula errors?

The skill uses a mandatory recalculation script powered by LibreOffice to scan every cell for errors like #REF!, #DIV/0!, and #VALUE! before delivering the final file.

Professional Excel & Spreadsheet Master

Name: Professional Excel & Spreadsheet Master
Author: Yezez9

byYezez9

0•

数据科学与机器学习

Automates professional-grade spreadsheet creation, editing, and financial modeling with rigorous formula verification and industry-standard formatting.

The xlsx skill transforms Claude into a specialized spreadsheet architect capable of handling complex tabular data tasks. It enforces professional standards for Excel deliverables, including zero-error formula verification, specific font styling, and industry-standard financial modeling conventions like color-coded inputs and calculations. By utilizing pandas for data manipulation and openpyxl for formatting, it ensures that deliverables are not just data dumps but dynamic, audit-ready workbooks. The skill includes a mandatory recalculation workflow using LibreOffice to identify and fix common errors like #REF! or #DIV/0! before the file is finalized.

主要功能

01Preservation of existing templates and custom formatting during file updates

020 GitHub stars

03Automated formula error detection and mandatory recalculation via LibreOffice

04Strict enforcement of financial modeling color standards (blue for inputs, black for formulas)

05Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv

06Dynamic formula construction to ensure spreadsheets remain updateable without Python

使用场景

01Cleaning and restructuring messy or malformed tabular data into professional spreadsheets

02Converting large datasets into multi-sheet Excel reports with automated charting and styling

03Building audit-ready financial models with standardized assumptions and formatting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yezez9/research-agent xlsx

For use in Claude.ai and ChatGPT