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

•

데이터 과학 및 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.

주요 기능

Support for advanced Excel features including pivot tables, charts, and data validation
Dual-library workflow utilizing pandas for data analysis and openpyxl for formatting
Intelligent template preservation that respects existing styles and formatting conventions
1 GitHub stars
Industry-standard financial modeling with automated color-coding (Blue/Black/Green/Red)
Mandatory formula recalculation and error verification using LibreOffice integration

사용 사례

Bulk-editing existing corporate workbooks while maintaining strict formatting consistency
Building automated financial models with dynamic projections and zero formula errors
Transforming raw CSV/TSV data into formatted executive dashboards with visualizations

소개

주요 기능

Support for advanced Excel features including pivot tables, charts, and data validation
Dual-library workflow utilizing pandas for data analysis and openpyxl for formatting
Intelligent template preservation that respects existing styles and formatting conventions
1 GitHub stars
Industry-standard financial modeling with automated color-coding (Blue/Black/Green/Red)
Mandatory formula recalculation and error verification using LibreOffice integration

사용 사례

Bulk-editing existing corporate workbooks while maintaining strict formatting consistency
Building automated financial models with dynamic projections and zero formula errors
Transforming raw CSV/TSV data into formatted executive dashboards with visualizations