xlsx

Unpack, validate, repair, and repack Office Open XML XLSX workbooks.

Updated Jan 17, 2026
One-click install
npx skills add https://github.com/lDuang/mcp-skill-registry --skill xlsx-lduang
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/lDuang/mcp-skill-registry/tree/main/skill/xlsx
Command: npx skills add https://github.com/lDuang/mcp-skill-registry --skill xlsx-lduang

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines end-to-end handling of Office Open XML spreadsheet workbooks by enabling unpacking, validation, repair, and re-packing of XLSX files, ensuring data integrity and reproducible results across Excel-based workflows.

Core Features & Use Cases

  • Unpack and inspect XLSX workbooks by exposing their internal OOXML XML structures for validation and repair.
  • Validate against OOXML schemas, automatically repair common issues (e.g., whitespace preservation, IDs, content types), and repack into a compliant workbook.
  • Recalculate formulas deterministically using LibreOffice tooling, then verify and preserve formula integrity for safe distribution.
  • Use in data-cleaning pipelines to fix structural issues in large spreadsheets, convert between tabular formats, or prepare data for downstream analytics.

Quick Start

Unpack an Excel workbook, run validations and repairs, then re-pack the directory back into a valid .xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I validate and repair the internal XML structure of an XLSX file?

You validate and repair an XLSX file by unpacking the workbook to expose its OOXML XML structures, applying schema validation, fixing common issues like whitespace preservation and content types, then repacking it into a compliant workbook.

How do I recalculate Excel formulas deterministically outside of Microsoft Excel?

You can recalculate Excel formulas deterministically using integrated LibreOffice tooling, which verifies and preserves formula integrity to ensure calculation accuracy for safe workbook distribution.

Why does my Excel workbook fail OOXML schema validation after editing?

Workbooks fail OOXML schema validation due to broken internal XML structures, incorrect content types, or missing IDs; unpacking the file and applying automated repairs resolves these structural compliance issues.

Can I use openpyxl to unpack and inspect the raw XML inside an Excel workbook?

While openpyxl handles standard spreadsheet operations, this Skill specifically unpacks Office Open XML workbooks to expose and inspect raw internal OOXML XML structures for targeted validation and repair.

Does LibreOffice need to be installed to recalculate formulas in an XLSX workflow?

Yes, LibreOffice tooling is required for the optional formula recalculation feature in XLSX workflows, which verifies and preserves formula integrity to ensure accurate and deterministic calculation results.

What is the best way to fix whitespace preservation issues in Office Open XML spreadsheets?

The best way to fix whitespace preservation issues in Office Open XML spreadsheets is to unpack the XLSX file, apply automated XML structure repairs, and repack the directory back into a validated workbook.