skills.rest
Tugoukezhang
TugoukezhangCOMMUNITY
Explore all skills by this author →
GitHub

Excel / XLSX

Create, inspect, and edit Excel workbooks and XLSX files.

8|1|Updated Apr 13, 2026
Search Tags:#formulas#excel#xlsx#data-integrity#workbooks#template-preservation#date-handling
One-click install
npx skills add https://github.com/Tugoukezhang/workbuddy-skills --skill excel-xlsx-tugoukezhang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Excel / XLSX
Source: https://github.com/Tugoukezhang/workbuddy-skills/tree/main/skills/excel-xlsx
Command: npx skills add https://github.com/Tugoukezhang/workbuddy-skills --skill excel-xlsx-tugoukezhang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Excel workbooks often require reliable formulas, correct date handling, and template preservation across platforms, making manual edits prone to errors and time-consuming.

Core Features & Use Cases

  • Create, inspect, and edit Microsoft Excel workbooks and XLSX files with accurate formulas, dates, types, formatting, and recalculation.
  • Preserve workbook structure and cross-platform compatibility during edits, ensuring template consistency and data integrity.
  • Use Case: When preparing a financial model or data dashboard in Excel that must stay reliable after edits.

Quick Start

Run a task to generate or modify an Excel workbook with a defined template and verify formulas and formatting.

Frequently Asked Questions about Excel / XLSX

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

FAQPage Schema
How do I edit Excel workbooks while preserving formulas and template structure?▼

To edit Excel workbooks while preserving formulas and template structure, use openpyxl for workbook-level changes. This ensures live formulas, proper date handling, and template consistency are maintained across platforms without data integrity loss.

When should I use pandas vs openpyxl for Excel file processing?▼

Use pandas for data analysis tasks and openpyxl for workbook-level changes in Excel file processing. This deterministic workflow ensures proper formula recalculation, date handling, and template preservation when modifying XLSX files.

How do I handle date formatting correctly when creating XLSX files?▼

Correct date handling in XLSX files requires applying openpyxl for workbook-level changes to maintain proper date types and formatting. This ensures dates remain accurate and compatible across different platforms during recalculation.

Can I modify CSV and TSV files without breaking cross-platform compatibility?▼

Yes, you can modify CSV and TSV files as plain data exchange without breaking cross-platform compatibility. For XLSX files requiring formulas and styles, apply openpyxl to preserve template consistency and data integrity across platforms.

What is the best way to automate generating Excel workbooks from a defined template?▼

The best way to automate generating Excel workbooks from a defined template is using openpyxl for workbook-level changes. This preserves template structure, applies accurate formulas, and ensures reliable formatting and recalculation after edits.

Related Skills

Explore More Data & Analytics Skills→
GayanKavindaGayanKavinda

xlsx

Create, edit, and repair spreadsheet files from raw tabular data.

Community
Advanced
KILWA73KILWA73

xlsx

Read, clean, transform, and export XLSX, CSV, and TSV files.

Community
Intermediate
jscraikjscraik
8

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.

Community
Advanced
eddie-292eddie-292
52

xlsx

Create, edit, clean, convert, and validate xlsx, xlsm, csv, and tsv workbooks.

Community
Advanced