xlsx

Edit, clean, convert, and create spreadsheet files while preserving formulas.

3|Updated Apr 18, 2026
One-click install
npx skills add https://github.com/garochee33/DSH --skill xlsx-garochee33
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/garochee33/DSH/tree/main/kb/claude/skills/xlsx
Command: npx skills add https://github.com/garochee33/DSH --skill xlsx-garochee33

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the friction of creating, fixing, and analyzing spreadsheet files when the primary deliverable is an Excel or tabular document. It helps you avoid broken formulas, inconsistent formatting, and time-consuming manual cleanup in common spreadsheet workflows.

Core Features & Use Cases

  • Spreadsheet creation and editing: Build new workbooks or update existing .xlsx, .xlsm, .csv, and .tsv files while preserving structure and formatting.
  • Formula-safe analysis: Write formulas instead of hardcoded calculations, then recalculate and validate the workbook to catch spreadsheet errors.
  • Office document tooling: Unpack, edit, validate, and repack Office XML structures when working directly with spreadsheet internals.
  • Use case: A user can clean a messy CSV export, add calculated columns, validate formulas, and deliver a polished Excel file ready for sharing.

Quick Start

Use the xlsx skill to clean this spreadsheet, add the requested formulas and formatting, and return a finished Excel file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel spreadsheet and preserve existing formulas?

To edit an Excel spreadsheet and preserve formulas, use a tool that unpacks Office XML structures, applies changes, and repacks the workbook safely. This ensures formulas remain intact while you update data, formatting, or calculated columns.

Can I clean a messy CSV export and convert it into a formatted Excel file?

Yes, you can clean a CSV export and convert it into a formatted Excel file. The process reads tabular data, applies cleanup rules, adds calculated columns with formulas, validates the workbook, and outputs a polished .xlsx deliverable.

Does openpyxl support formula recalculation and XML validation for xlsx files?

Yes, openpyxl supports formula recalculation and XML validation for xlsx files. Combined with lxml and defusedxml, it provides formula-safe analysis, XML structure validation, and secure file packaging to prevent spreadsheet errors and maintain deliverable integrity.

What is the best way to add calculated columns to tabular data without hardcoding values?

The best way to add calculated columns without hardcoding values is to write formulas directly into the spreadsheet cells. This approach uses formula-safe analysis to recalculate the workbook dynamically, ensuring accurate results when source data changes.

Why do my spreadsheet formulas break when I edit an xlsx file programmatically?

Spreadsheet formulas break when editing xlsx files programmatically due to improper XML validation or incorrect file packaging. Using a formula-safe approach that validates the Office XML structure and recalculates the workbook prevents these errors.