skills.rest
kumewata
kumewataCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

An expert system for the diagnosis and treatment of diseases.

Updated Jan 16, 2026
Search Tags:#validation#excel#xlsx#xml#formula#data-cleaning#openxml
One-click install
npx skills add https://github.com/kumewata/dotfiles --skill xlsx-kumewata
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kumewata/dotfiles/tree/main/config/agents/skills/xlsx
Command: npx skills add https://github.com/kumewata/dotfiles --skill xlsx-kumewata

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill validates and repairs Excel/OpenXML spreadsheet files to ensure structural integrity and clean data, reducing manual debugging time.

Core Features & Use Cases

  • OOXML validation: Detects and fixes issues in .xlsx/.xlsm packages, including XML cleanliness, whitespace preservation, and ID consistency.
  • Data cleaning and formatting: Assists with reformatting, column edits, and cleanup of messy tabular data, including conversion between formats like CSV/TSV.
  • Formula correctness: Recalculates formulas using LibreOffice-based tooling to avoid stale or incorrect results.

Quick Start

Provide the path to your spreadsheet and let the tool validate, repair, and report results.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I validate an xlsx file for structural integrity?▼

To validate an xlsx file, you can check its OOXML packaging for XML cleanliness, whitespace preservation, and ID consistency. This process detects structural issues within the spreadsheet package to ensure data correctness.

What is the best way to repair broken Excel formulas in a spreadsheet?▼

The best way to repair Excel formulas is by recalculating them using LibreOffice-based tooling. This approach enforces formula correctness and prevents stale or incorrect calculation results in your spreadsheets.

Can I clean and convert messy CSV or TSV data into an xlsx format?▼

Yes, you can clean and reformat messy tabular data, including converting between formats like CSV and TSV. This workflow assists with column edits and cleanup to produce consistent spreadsheet outputs.

Does openpyxl support OOXML content-type checks and unique-ID verification?▼

Yes, openpyxl is used alongside lxml and defusedxml to perform OOXML content-type checks and unique-ID verification. These libraries enforce structural correctness and consistency within the spreadsheet packages.

Why does my xlsx file have inconsistent IDs and whitespace issues after data cleaning?▼

Inconsistent IDs and whitespace issues in an xlsx file occur when XML text nodes are improperly handled during edits. Validating the OOXML package detects these flaws, allowing you to repair whitespace preservation and ID consistency.

Related Skills

Explore More Data & Analytics Skills→
metaid-developersmetaid-developers

xlsx

Automate Excel workbook processing, validation, and CSV conversion with openpyxl.

Official
Advanced
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
Buntyarora97Buntyarora97

excel-generator

Create Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic