Is LibreOffice required for this skill?

For full formula recalculation and verification, the skill utilizes a script that assumes LibreOffice is available to process the Excel engine's calculations automatically.

What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, .tsv, and other common spreadsheet formats for both reading and writing operations.

Can it modify existing Excel templates?

Yes, it is designed to study and match existing styles, formats, and conventions to ensure seamless updates to established corporate templates.

Does it support financial modeling standards?

Yes, it follows industry-standard color coding—such as blue for inputs and black for formulas—and strict number formatting for professional models.

How does this skill handle Excel formulas?

It uses openpyxl to inject formulas as strings and a specialized recalculation script to ensure all values are correctly computed and error-free before delivery.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: theflysurfer

bytheflysurfer

0•

Productivity & Workflow

Manages professional Excel workbooks with advanced formulas, financial modeling standards, and automated data analysis.

This skill empowers Claude to create, modify, and analyze complex Excel spreadsheets while adhering to professional financial modeling standards. It ensures spreadsheet integrity by prioritizing dynamic formulas over hardcoded values and includes a mandatory recalculation step to eliminate common errors like #REF! or #DIV/0!. Whether you are building multi-sheet financial models with industry-standard color coding, performing bulk data analysis with pandas, or updating existing corporate templates, this skill provides the precision and automation required for enterprise-grade spreadsheet management.

Key Features

01Professional financial model color-coding (Blue for inputs, Black for formulas)

02Strict number formatting for currencies, percentages, and valuation multiples

03Advanced formula integration with automated error-free recalculation

04Comprehensive data analysis and visualization using pandas and openpyxl

05Template preservation and style matching for existing workbooks

060 GitHub stars

Use Cases

01Automating the update of corporate reporting templates while preserving existing formulas and styles

02Building dynamic, multi-sheet financial projection models with standardized formatting and assumptions

03Analyzing large datasets from CSV/TSV files and exporting them into formatted, professional Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add theflysurfer/claude-skills-marketplace anthropic-office-xlsx

For use in Claude.ai and ChatGPT

Download Skill