Does it support financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and professional number formatting for currency, percentages, and multiples.

Which libraries does it use for spreadsheet tasks?

It leverages pandas for data-heavy manipulation and openpyxl for tasks requiring specific formatting, sheet management, and formula preservation.

Can it verify if formulas are broken?

Yes, it uses a specialized recalculation script to check for #REF!, #DIV/0!, and other common Excel errors before delivering the final file.

How does this skill handle Excel formulas?

It generates native Excel formulas instead of hardcoding values, ensuring your spreadsheets remain dynamic and updateable when values change.

Can I use it to update existing templates?

Yes, the skill is designed to study and exactly match your existing formatting, styles, and conventions when modifying established files.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: Brmbobo

byBrmbobo

0•

データサイエンスとML

Automates the creation, editing, and analysis of Excel spreadsheets with advanced formula support and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV processing to sophisticated financial modeling in .xlsx format. It enforces industry-standard formatting, ensures zero formula errors through automated recalculation with LibreOffice, and utilizes both pandas for data analysis and openpyxl for preserving dynamic formulas. Whether building projection models from scratch or updating existing templates, this skill maintains data integrity and professional styling while providing detailed error reporting.

主な機能

01Automated formula recalculation via LibreOffice integration

02Advanced data analysis and visualization using pandas

03Preservation of existing spreadsheet templates and styles

04Professional financial modeling standards and color coding

05Dynamic formula generation with zero-error verification

060 GitHub stars

ユースケース

01Building automated financial projection models with standardized formatting

02Performing deep data analysis on large datasets and exporting to Excel

03Updating existing business templates while maintaining complex cell formulas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast xlsx

For use in Claude.ai and ChatGPT

Download Skill