Can it clean messy data files?

Yes, it is designed to trigger when users need to restructure malformed rows, fix misplaced headers, or remove junk data from tabular files to create proper spreadsheets.

What file formats are supported?

It primarily supports .xlsx, .xlsm, .csv, and .tsv files for both input and output operations.

How does it handle Excel formula errors?

The skill utilizes a mandatory recalculation script powered by LibreOffice to identify and help resolve errors like #REF!, #DIV/0!, and #VALUE! before delivery.

Does this skill support professional financial modeling standards?

Yes, it follows industry conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, percentages, and multiples.

Does it work with existing Excel templates?

The skill is instructed to study and match existing formats, styles, and conventions of a file to ensure updates are seamless and consistent with original templates.

Excel & Spreadsheet Master

Name: Excel & Spreadsheet Master
Author: kenmuse

bykenmuse

0•

数据科学与机器学习

Manipulates, formats, and validates professional-grade Excel and tabular data files using industry-standard conventions.

This skill transforms Claude into a comprehensive spreadsheet engineer capable of creating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files with high precision. It enforces rigorous professional standards for financial modeling, including specific color-coding for inputs and formulas, error-free calculation verification via LibreOffice, and automated formatting. Whether you need to clean messy data, build dynamic models with complex formulas, or convert between tabular formats, this skill ensures production-ready deliverables that adhere to established corporate templates and best practices.

主要功能

01Mandatory formula recalculation and error validation using LibreOffice integration.

02Support for complex Excel formulas, cross-sheet references, and professional styling.

03Intelligent data cleaning and restructuring of malformed tabular data files.

040 GitHub stars

05Industry-standard financial modeling formatting (blue-text inputs, black-text formulas).

06Automated spreadsheet creation and editing using pandas and openpyxl.

使用场景

01Building dynamic financial models with automated assumptions placement and zero formula errors.

02Modifying existing corporate templates while preserving original styles, fonts, and conventions.

03Cleaning and converting messy CSV or TSV data into structured, formatted Excel reports.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add kenmuse/anthropic-copilot-plugins xlsx

For use in Claude.ai and ChatGPT

主要功能

01Mandatory formula recalculation and error validation using LibreOffice integration.

02Support for complex Excel formulas, cross-sheet references, and professional styling.

03Intelligent data cleaning and restructuring of malformed tabular data files.

040 GitHub stars

05Industry-standard financial modeling formatting (blue-text inputs, black-text formulas).

06Automated spreadsheet creation and editing using pandas and openpyxl.

使用场景

01Building dynamic financial models with automated assumptions placement and zero formula errors.

02Modifying existing corporate templates while preserving original styles, fonts, and conventions.

03Cleaning and converting messy CSV or TSV data into structured, formatted Excel reports.