excel-workbook

Profile Excel workbooks and normalize headers to snake_case.

Updated Feb 21, 2026
One-click install
npx skills add https://github.com/leeyuyun/agent_skills --skill excel-workbook
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-workbook
Source: https://github.com/leeyuyun/agent_skills/tree/main/excel-workbook
Command: npx skills add https://github.com/leeyuyun/agent_skills --skill excel-workbook

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Excel workflow automation with deterministic edits, preserving formulas and structure to deliver reproducible outputs and audit-friendly results.

Core Features & Use Cases

  • Profile workbooks to understand structure, dimensions, and formula density.
  • Normalize headers to deterministic snake_case names while preserving data intent.
  • Apply structured edits (dedupe, filtering, insertion, merging) with safety rules and clear change logs.
  • Produce output ready for analysis and reporting, including chart-ready sheets and validation notes.

Quick Start

Provide an input workbook and run the profiling script to generate a profile, then apply normalization and deterministic edits as described to produce a reliable output.

Frequently Asked Questions about excel-workbook

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

FAQPage Schema
How do I automate Excel workbook profiling to understand sheet dimensions and formula density?

Excel workbook profiling automates the extraction of sheet counts, dimensions, and formula density. It scans .xlsx, .xlsm, and .csv inputs to generate a structural overview, helping you understand data distribution and formula usage before applying transformations.

What is the best way to normalize Excel headers to snake_case for data cleaning?

Normalizing Excel headers to snake_case converts inconsistent column names into deterministic, standardized formats. This process preserves data intent while ensuring reproducible outputs, making the workbook ready for structured analysis and downstream transformations.

Can I apply deterministic edits like dedupe and filtering to Excel files without losing formulas?

Yes, deterministic edits like dedupe, filtering, and merging can be applied to Excel files while preserving formulas and structure. This approach uses safety rules and explicit output contracts to deliver reproducible, auditable results without breaking existing workbook logic.

Does openpyxl support safe, rule-driven transformations on .xlsm files?

Openpyxl supports safe, rule-driven transformations on .xlsm files by enabling structured edits with clear change logs. It handles .xlsx, .xlsm, and .csv inputs, ensuring that deterministic edits produce auditable outputs while maintaining workbook integrity.

Why does Excel automation produce inconsistent outputs when preserving formulas and structure?

Excel automation produces inconsistent outputs when edits lack deterministic rules and explicit output contracts. By applying structured safety rules and header normalization, the workflow ensures reproducible, audit-friendly results, preventing structural drift and unintended formula alterations.