Are CSV and TSV files supported?

Yes, the skill provides full support for reading, analyzing, and converting .csv and .tsv files into fully formatted .xlsx workbooks.

Can I use it to update existing spreadsheet templates?

Absolutely. The skill is programmed to study and match existing formats, ensuring that any modifications blend seamlessly with your established styles and conventions.

Does it support standard financial modeling conventions?

Yes, it follows industry standards such as blue text for hardcoded inputs, black for formulas, green for internal links, and red for external references.

How does this skill handle Excel formula errors?

The skill uses a mandatory recalculation script (recalc.py) that triggers LibreOffice to evaluate all formulas and scan for errors like #REF!, #DIV/0!, and #VALUE! before final delivery.

What libraries are used for spreadsheet processing?

It leverages pandas for high-performance data manipulation and analysis, and openpyxl for precision control over formulas, styles, and cell-level formatting.

Excel & Spreadsheet Master

Name: Excel & Spreadsheet Master
Author: samhvw8

bysamhvw8

•

Data Science & ML

Automates professional Excel spreadsheet creation, financial modeling, and data analysis with error-free formula verification.

This skill enables Claude to perform high-level spreadsheet engineering, from simple CSV conversions to complex financial modeling. It enforces strict industry standards, such as professional color-coding for inputs and formulas, and ensures zero-error integrity through automated recalculation via LibreOffice. By combining the data processing power of pandas with the formatting precision of openpyxl, it allows for the creation of dynamic, production-ready workbooks complete with pivot tables, charts, and conditional formatting while strictly preserving existing user templates.

Key Features

01Support for advanced Excel features including pivot tables, charts, and data validation

02Dual-library workflow utilizing pandas for data analysis and openpyxl for formatting

03Intelligent template preservation that respects existing styles and formatting conventions

041 GitHub stars

05Industry-standard financial modeling with automated color-coding (Blue/Black/Green/Red)

06Mandatory formula recalculation and error verification using LibreOffice integration

Use Cases

01Bulk-editing existing corporate workbooks while maintaining strict formatting consistency

02Building automated financial models with dynamic projections and zero formula errors

03Transforming raw CSV/TSV data into formatted executive dashboards with visualizations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add samhvw8/dot-claude document-skills

For use in Claude.ai and ChatGPT

Download Skill