xlsx

Create, edit, analyze, convert, and validate spreadsheet files with pandas and openpyxl.

4|Updated Feb 23, 2026
One-click install
npx skills add https://github.com/npow/claude-skills --skill xlsx-npow
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/npow/claude-skills/tree/main/xlsx
Command: npx skills add https://github.com/npow/claude-skills --skill xlsx-npow

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates spreadsheet creation, editing, analysis, and conversion while reducing formula errors, formatting inconsistencies, and problems caused by manually calculated values.

Core Features & Use Cases

  • Spreadsheet Creation and Editing: Build or modify XLSX, XLSM, CSV, and TSV files with pandas and openpyxl while preserving formulas, templates, and formatting.
  • Formula Management: Use dynamic Excel formulas, recalculate them through LibreOffice, and detect errors such as #REF!, #DIV/0!, #VALUE!, and #N/A.
  • Validation and Office Processing: Unpack, edit, validate, and repack Office files while checking XML structure, relationships, content types, and tracked-change integrity.
  • Use Case: Create a financial model from source data with documented assumptions, professional formatting, dynamic projections, and verified formula results.

Quick Start

Use the xlsx skill to analyze the attached workbook, preserve its existing template, repair any formula errors, and return a validated spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula validation and detect errors like #REF! or #DIV/0!?

Excel formula validation detects calculation errors like #REF!, #DIV/0!, #VALUE!, and #N/A by recalculating workbooks via LibreOffice. It identifies broken formulas, repairs references, and returns a validated spreadsheet without altering your existing template formatting.

Can I edit XLSX files with pandas and openpyxl without losing existing formatting and formulas?

Editing XLSX files with pandas and openpyxl preserves formulas, templates, and formatting. The process modifies spreadsheet content directly while maintaining dynamic calculations and original cell styles, returning a fully formatted workbook for XLSX, XLSM, CSV, and TSV workflows.

What is the best way to build a financial model from source data in a spreadsheet?

Building a financial model in a spreadsheet involves importing source data, applying documented assumptions, and constructing dynamic projections. The process uses openpyxl for formatting and LibreOffice for mandatory formula recalculation, producing a verified, professional financial workbook.

Does LibreOffice need to be installed to recalculate spreadsheet formulas?

LibreOffice is required for mandatory formula recalculation in spreadsheets. It processes dynamic Excel formulas to ensure calculated values are accurate, working alongside openpyxl and pandas which handle file creation and data manipulation without external recalculation.

How do I validate Office document XML structure and content type integrity?

Validating Office document integrity involves unpacking files, checking XML structure, relationships, content types, and tracked-change integrity. The process edits and repacks Office files while detecting structural problems, returning a validated document with confirmed XML and relationship consistency.