excel-master

Generate and format Excel reports from DataFrames using openpyxl.

16|1|Updated Jun 5, 2026
One-click install
npx skills add https://github.com/benyichan/excel-master --skill excel-master
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-master
Source: https://github.com/benyichan/excel-master/tree/main
Command: npx skills add https://github.com/benyichan/excel-master --skill excel-master

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill solves the problem of creating or formatting Excel reports that meet strict professional standards, eliminating the need for manual, error-prone styling and ensuring consistent, high-quality output.

Core Features & Use Cases

  • Professional Formatting: Automatically applies Morgan Stanley-style formatting, including Arial 11 font, specific border styles, and professional color themes.
  • Smart Beautification: Enhances existing Excel files by applying professional styles while preserving formulas and data integrity.
  • Intelligent Inference: Automatically detects column types (percentage, date, text, money) and applies appropriate formatting, with support for manual overrides.
  • Use Case: A financial analyst needs to convert a raw CSV export into a client-ready report. They can use this skill to instantly apply the corporate color theme, freeze headers, and format currency columns with thousands separators.

Quick Start

Use the excel-master skill to beautify the report file named sales_data.xlsx using the coral color theme.

Frequently Asked Questions about excel-master

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate professional Excel report formatting from a pandas DataFrame?

You can automate Excel report formatting by using openpyxl to apply professional styles directly to a pandas DataFrame. This skill automatically infers column types and applies corporate financial themes to generate client-ready spreadsheets.

Can I beautify an existing Excel file without losing formulas and data integrity?

Yes, you can beautify existing Excel files while preserving formulas and data integrity. The skill applies professional Morgan Stanley-style formatting, including specific borders and fonts, without altering the underlying data.

Does this openpyxl automation support intelligent column type inference for financial reporting?

Yes, the openpyxl automation supports intelligent column type inference for financial reporting. It automatically detects percentage, date, text, and money columns to apply appropriate formatting, with support for manual overrides.

What is the best way to apply a Morgan Stanley-style theme to raw CSV data exports?

The best way to apply a Morgan Stanley-style theme to raw CSV exports is using this skill to apply automated styling, freeze headers, and format currency columns with thousands separators, achieving consistent high-quality output.

Do I need pandas and openpyxl installed to perform automated spreadsheet styling?

Yes, you need both pandas and openpyxl installed to perform automated spreadsheet styling. These dependencies are required for the skill to execute deterministic, non-interactive spreadsheet manipulation and formatting.

Can I use manual overrides when the automatic column type detection fails?

Yes, you can use manual overrides when automatic column type detection fails. The skill supports intelligent inference for types like percentage and money, but allows you to manually specify formats to ensure accurate financial reporting.