Does this skill support existing Excel templates?

Yes, the skill is specifically designed to study and match existing formats, styles, and conventions to preserve the integrity of your professional templates.

How does it handle complex Excel formulas?

It prioritizes writing live Excel formulas over hardcoding values and uses a background recalculation engine (LibreOffice) to verify there are no #REF!, #NAME?, or #DIV/0! errors.

Can I use this for professional financial modeling?

Absolutely. It follows strict industry standards, including specific color coding (blue for inputs, black for formulas) and standardized number formatting for currencies and multiples.

Which spreadsheet file formats are supported?

The skill provides comprehensive support for .xlsx, .xlsm, .csv, and .tsv files for reading, editing, and creation tasks.

Advanced Spreadsheet & Excel Processing

Name: Advanced Spreadsheet & Excel Processing
Author: lawvable

bylawvable

•

228

•

数据科学与机器学习

Automates the creation, editing, and professional formatting of Excel workbooks and tabular data files with high-precision financial modeling standards.

This skill provides specialized capabilities for handling .xlsx, .xlsm, .csv, and .tsv files, ensuring that Claude produces production-ready spreadsheets rather than just raw data or scripts. It enforces strict financial modeling standards—such as industry-standard color coding and formula-driven calculations—while utilizing powerful libraries like pandas for analysis and openpyxl for formatting. By integrating an automated recalculation engine via LibreOffice, it guarantees error-free workbooks that maintain dynamic functionality and professional aesthetics, making it an essential tool for financial analysts, data engineers, and workflow automation.

主要功能

01228 GitHub stars

02Automated formula generation to replace hardcoded values for dynamic workbooks

03Industry-standard financial modeling color coding (Blue for inputs, Black for formulas)

04Automated workbook recalculation and verification to eliminate #REF! and #DIV/0! errors

05Seamless integration with pandas for data analysis and openpyxl for precision formatting

06Context-aware template preservation that respects existing styles and conventions

使用场景

01Cleaning and restructuring malformed tabular data into structured, formatted spreadsheets

02Converting raw datasets into executive-ready Excel reports with custom charts and styles

03Generating dynamic, professional financial models with automated error checking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

主要功能

01228 GitHub stars

02Automated formula generation to replace hardcoded values for dynamic workbooks

03Industry-standard financial modeling color coding (Blue for inputs, Black for formulas)

04Automated workbook recalculation and verification to eliminate #REF! and #DIV/0! errors

05Seamless integration with pandas for data analysis and openpyxl for precision formatting

06Context-aware template preservation that respects existing styles and conventions

使用场景

01Cleaning and restructuring malformed tabular data into structured, formatted spreadsheets

02Converting raw datasets into executive-ready Excel reports with custom charts and styles

03Generating dynamic, professional financial models with automated error checking