skills.rest
kangminlee-maker
kangminlee-makerCOMMUNITY
Explore all skills by this author →
GitHub

excel-workbook-editing

Edit and validate Excel workbooks and connected Google Sheets.

Updated Apr 1, 2026
Search Tags:#workflow#validation#audit#excel#google-sheets#workbook
One-click install
npx skills add https://github.com/kangminlee-maker/excel-workbook-editing --skill excel-workbook-editing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-workbook-editing
Source: https://github.com/kangminlee-maker/excel-workbook-editing/tree/main
Command: npx skills add https://github.com/kangminlee-maker/excel-workbook-editing --skill excel-workbook-editing

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a structured, auditable workflow to design, edit, debug, reconcile, preview, and validate Excel workbooks and connected Google Sheets, preserving both the artifact identity and the underlying calculation logic.

Core Features & Use Cases

  • Deterministic workbook edits with traceable inputs, intermediates, and outputs
  • Live readback and validation to preserve formulas, validations, protections, and sheet identities
  • Support for Excel .xlsx workbooks and connected Google Sheets (including IMPORTRANGE and Apps Script dependencies)
  • CLI- and UI-visible review packages (HTML/JSON/Markdown) for CLI workflows and human review
  • Reconciliation and carry-forward workflows to ensure stable, auditable edits in complex workbook templates

Quick Start

Identify your artifact type (Excel workbook, Google Sheet, or review package) and follow the guided workflow to edit, validate, and reconcile.

Frequently Asked Questions about excel-workbook-editing

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

FAQPage Schema
How do I automate editing Excel workbooks while preserving formulas and validations?▼

To automate Excel workbook edits while preserving formulas, validations, and protections, you need a governed workflow with deterministic edits, live readback, and traceable inputs to ensure the calculation logic remains intact.

How do I validate changes in a connected Google Sheet with IMPORTRANGE dependencies?▼

Validating changes in connected Google Sheets with IMPORTRANGE and Apps Script dependencies requires a policy gate and reconciliation workflow to ensure safe modifications, scope validation, and stable artifact identity.

Do I need a broker-enabled environment to edit .xlsx files safely?▼

Yes, editing .xlsx files safely with this workflow requires a broker-enabled environment equipped with Excel engine validation to enforce identity, scope, and safe changes before any workbook modifications are applied.

What's the best way to debug and reconcile carry-forward workflows in Excel templates?▼

The best way to debug and reconcile carry-forward workflows in Excel templates is to use a structured, auditable process that generates review packages in HTML, JSON, or Markdown for human verification and CLI workflows.

Why do my Excel workbook edits break sheet layouts and calculation logic?▼

Excel workbook edits break sheet layouts and calculation logic when modifications lack traceable inputs and live readback validation to preserve formulas, validations, protections, and underlying sheet identities.

Can I generate review packages for human verification of Google Sheets modifications?▼

Yes, you can generate CLI- and UI-visible review packages in HTML, JSON, and Markdown formats to provide human-readable audit trails and verify modifications made to Excel workbooks and connected Google Sheets.

Related Skills

Explore More Data & Analytics Skills→
ViviennaMAOViviennaMAO
26

xlsx-author

Generate .xlsx files with Python openpyxl in headless environments.

Community
Basic
ckrono-progckrono-prog

excel-generator

Generate and manipulate Excel spreadsheets with calculations, charts, and pivot tables.

Community
Advanced
MDGrey33MDGrey33
2

google-script-deploy

Deploy HTML files as stable Google Apps Script web apps.

Community
Advanced
mouseqiao85mouseqiao85
1

xlsx-author

Generate .xlsx files programmatically with Python and openpyxl.

Community
Intermediate