Why does it use formulas instead of hardcoding values?

Using Excel formulas ensures the spreadsheet remains dynamic and updateable by the end-user, allowing the workbook to recalculate correctly when source data changes.

Can this skill handle existing Excel templates?

Yes, it is specifically designed to study and match existing styles, formats, and conventions when modifying files, ensuring that template integrity is preserved.

How does it handle formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script that scans all cells for Excel errors after modifications, ensuring every deliverable is error-free.

Does it support financial modeling standards?

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

Excel & Spreadsheet Master

Name: Excel & Spreadsheet Master
Author: inami-hsi

byinami-hsi

0•

Data Science & ML

Manages comprehensive spreadsheet operations including professional formatting, financial modeling, and automated formula validation.

The xlsx skill provides Claude with advanced capabilities to handle complex spreadsheet tasks beyond basic data entry. It enables the creation of professional-grade Excel workbooks featuring dynamic formulas, industry-standard financial modeling conventions, and precise formatting. Whether you need to clean messy tabular data, build interactive financial models with specific color-coding (blue for inputs, black for formulas), or update existing templates while preserving their original style, this skill ensures a high-quality deliverable. It includes a specialized recalculation engine to guarantee zero formula errors before delivery, making it an essential tool for analysts and developers working with .xlsx, .csv, and .xlsm files.

Key Features

01Professional financial modeling with industry-standard color-coding and number formatting

020 GitHub stars

03Template preservation logic that matches existing styles, fonts, and conventions

04Sophisticated data cleaning for restructuring malformed or messy tabular files

05Automated formula recalculation and error detection using LibreOffice integration

06Dynamic formula generation that prioritizes live calculations over hardcoded values

Use Cases

01Transforming inconsistent CSV exports into structured, formatted, and charted Excel reports

02Automating the update of complex monthly reporting templates while maintaining formatting integrity

03Building dynamic three-statement financial models with scenario assumptions and automated totals

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add inami-hsi/claude-skills xlsx

For use in Claude.ai and ChatGPT