How does this skill handle Excel formulas?

It prioritizes standard, legible formulas and performs a recalculation check to ensure no errors like #REF! or #DIV/0! exist before providing the file.

Which spreadsheet formats are supported by this skill?

The skill supports .xlsx, .xlsm, .csv, and .tsv files for reading, editing, and creating new workbooks.

Does it support professional financial formatting?

Yes, it includes specific rules for investment banking and finance, such as blue-text for inputs, black for formulas, and specialized number formats for multiples and currencies.

Can it create charts and visualizations?

Yes, the skill can generate in-sheet charts, apply conditional formatting, and use visual elements like borders and fills to create professional dashboards.

Will it break my existing spreadsheet formatting?

No, the skill is designed to render and examine existing styles before making changes, ensuring that all modifications match the original document's aesthetic.

Spreadsheet Automation & Financial Modeling

Name: Spreadsheet Automation & Financial Modeling
Author: lawvable

bylawvable

•

Data Science & ML

Automates the creation, analysis, and professional formatting of complex spreadsheets and financial models with visual validation.

This skill provides a comprehensive toolkit for advanced spreadsheet manipulation within Claude Code. It enables the creation of presentation-ready workbooks, sophisticated data analysis, and the preservation of complex formula structures in .xlsx, .csv, and .tsv formats. Beyond simple data entry, it enforces industry-standard formatting—including specific conventions for investment banking and financial modeling—and utilizes visual quality control to ensure every sheet is professionally styled and mathematically accurate before delivery.

Key Features

01Robust tabular data analysis including aggregation, filtering, and metric computation

02Seamless modification of existing workbooks while preserving legacy formulas and styles

03Professional financial modeling with standard color-coding and layout conventions

0438 GitHub stars

05Visual quality control using rendered images to verify formatting and style

06Advanced formula management with automatic recalculation and error validation

Use Cases

01Building investment banking-grade DCF or LBO models with automated formatting

02Updating complex legacy spreadsheets without breaking existing cell references or styles

03Converting raw datasets into structured Excel reports with in-sheet charts and pivot tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawvable/awesome-legal-skills xlsx-processing-openai

For use in Claude.ai and ChatGPT

Download Skill