xlsx

Create, edit, and repair spreadsheet files into validated .xlsx workbooks.

6|1|Updated Apr 7, 2026
One-click install
npx skills add https://github.com/kmshihab7878/claude-code-setup --skill xlsx-kmshihab7878
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/kmshihab7878/claude-code-setup/tree/main/skills/xlsx
Command: npx skills add https://github.com/kmshihab7878/claude-code-setup --skill xlsx-kmshihab7878

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Provides a governed, production-grade workflow for creating, editing, cleaning, and converting spreadsheet files so the primary deliverable is always a valid, recalculable Excel workbook with zero formula errors and preserved templates.

Core Features & Use Cases

  • Format-preserving edits: Modify existing .xlsx/.xlsm while exactly matching templates and style conventions.
  • Data cleaning & restructuring: Repair malformed CSV/TSV/tabular data, normalize headers, remove junk rows, and convert into structured worksheets.
  • Formula-first modeling: Add Excel formulas (not hardcoded values), build dynamic models, and enforce industry number formatting and color conventions for financial models.
  • Recalculation & validation: Recalculate formulas using the provided LibreOffice-based recalc.py and scan for common Excel errors (#REF!, #DIV/0!, #NAME?, etc.) until clean.
  • Integration patterns: Use pandas for data analysis and openpyxl for precise formatting and formula insertion; ideal for use cases like invoice rollups, financial model updates, chart generation, and format conversions.

Quick Start

Use the xlsx skill to read 'dirty.csv', clean and restructure the data into a new workbook, add dynamic formulas, run the recalculation script, and deliver 'cleaned_output.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean malformed CSV data and convert it into a formatted Excel workbook?

Yes, you can edit existing .xlsx or .xlsm files while preserving their original templates and style conventions. The workflow uses openpyxl to apply format-preserving edits, ensuring the delivered spreadsheet matches your established layout exactly.

Does openpyxl support enforcing dynamic Excel formulas instead of hardcoded values?

Yes, openpyxl supports enforcing dynamic Excel formulas instead of hardcoded values. You can insert live formulas, build dynamic models, and apply industry-standard number formatting directly within your .xlsx workflows to maintain recalculable spreadsheet logic.

How do I scan an Excel file for formula errors like #REF! and #DIV/0! before delivery?

To scan an Excel file for formula errors like #REF! and #DIV/0!, you run the provided LibreOffice-based recalc.py script. This recalculates the formulas and validates the workbook until it is completely error-free and ready for professional delivery.

What is the best way to convert TSV files into structured Excel worksheets with charts?

The best way to convert TSV files into structured Excel worksheets with charts is to read the tabular data with pandas, clean and restructure it, then use openpyxl to add columns, apply formulas, generate charts, and deliver a validated .xlsx file.

Why do my spreadsheet formulas show #NAME? errors after programmatic file manipulation?

Spreadsheet formulas show #NAME? errors after programmatic file manipulation due to unresolved formula references or syntax issues. Running a LibreOffice recalculation script enforces formula-based calculations and scans for these errors until the workbook is completely clean.