How does it ensure there are no formula errors?

The skill utilizes a dedicated recalculation script that runs the workbook through LibreOffice to detect and report errors such as #REF!, #DIV/0!, and #VALUE! before final delivery.

What file formats can this skill handle?

It primarily handles .xlsx and .xlsm files, but it is also highly effective at managing and converting .csv and .tsv tabular data.

Does it support complex Excel formulas?

Absolutely. It prioritizes using native Excel formulas (like SUM, AVERAGE, and cell references) over hardcoding values, ensuring the spreadsheet remains dynamic.

Can this skill update existing Excel templates?

Yes, the skill is designed to study and match existing formats, styles, and conventions of your templates without imposing unwanted standardized formatting.

Professional Excel & Spreadsheet Management

Name: Professional Excel & Spreadsheet Management
Author: henriquescastilho

byhenriquescastilho

•

データサイエンスとML

Automates the creation, editing, and professional formatting of Excel workbooks and tabular data files with an emphasis on dynamic formulas and financial standards.

This skill provides a robust toolkit for handling spreadsheet tasks within Claude Code, covering everything from basic CSV cleaning to complex financial modeling in .xlsx and .xlsm formats. It ensures professional delivery by enforcing strict formatting rules, such as specific font styles and industry-standard color coding for inputs and calculations. The skill prioritizes dynamic Excel formulas over hardcoded values and includes an automated recalculation and verification workflow using LibreOffice to guarantee error-free deliverables with zero formula faults like #REF! or #DIV/0!.

主な機能

01Multi-format support for .xlsx, .xlsm, .csv, and .tsv files

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

03Dynamic formula generation to ensure workbooks remain updateable

041 GitHub stars

05Comprehensive formula verification and error detection via recalc scripts

06Automated spreadsheet creation and editing using pandas and openpyxl

ユースケース

01Cleaning and restructuring malformed tabular data into professional reports

02Converting large datasets into formatted Excel workbooks with automated charts and formulas

03Building investment-grade financial models with standardized assumptions and formatting

Professional Excel & Spreadsheet Management

byhenriquescastilho

•

データサイエンスとML

Automates the creation, editing, and professional formatting of Excel workbooks and tabular data files with an emphasis on dynamic formulas and financial standards.

主な機能

01Multi-format support for .xlsx, .xlsm, .csv, and .tsv files

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

03Dynamic formula generation to ensure workbooks remain updateable

041 GitHub stars

05Comprehensive formula verification and error detection via recalc scripts

06Automated spreadsheet creation and editing using pandas and openpyxl

ユースケース

01Cleaning and restructuring malformed tabular data into professional reports

02Converting large datasets into formatted Excel workbooks with automated charts and formulas

03Building investment-grade financial models with standardized assumptions and formatting