xlsx

Transform and repair spreadsheet inputs into valid Excel workbooks.

2|Updated Apr 8, 2026
One-click install
npx skills add https://github.com/miptah21/skills --skill xlsx-miptah21
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/miptah21/skills/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/miptah21/skills --skill xlsx-miptah21

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the friction of working with spreadsheet files by letting you reliably open, clean, transform, and repair tabular data while ensuring Excel formulas recalculate correctly and deliver a valid spreadsheet as the final output.

Core Features & Use Cases

  • Excel-first spreadsheet workflows: create new workbooks, edit existing ones, or convert tabular formats while keeping the deliverable as an actual spreadsheet file.
  • Formula correctness and validation guardrails: enforce zero Excel formula errors and run LibreOffice-based recalculation to detect and fix issues like #REF!, #DIV/0!, #VALUE!, and #NAME?.
  • Messy data cleanup & restructuring: convert malformed tables into proper spreadsheet structure (e.g., fixing headers/rows, restructuring tabs, cleaning junk rows) with the final result saved as an XLSX.
  • Financial-model formatting discipline (when applicable): apply industry-standard color coding and number-format conventions to keep assumptions and calculations readable and consistent.

Quick Start

Use the xlsx skill to convert the attached file 'data.xlsx' into a cleaned spreadsheet with corrected headers and recalculated formulas, saving the updated result as 'output.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix Excel formula errors like #REF! and #DIV/0! when editing an XLSX file?

You can clean messy spreadsheet data and restructure malformed tables by fixing headers, correcting rows, and removing junk rows. This Skill converts disorganized tabular data into a proper spreadsheet structure and saves the cleaned result as a valid XLSX file.

Can I convert CSV or TSV files into a formatted Excel workbook with formulas?

Yes, you can convert CSV and TSV files into a formatted Excel workbook. This Skill transforms tabular formats into XLSX or XLSM outputs while preserving table structure, formatting, charts, and ensuring formulas calculate correctly without hardcoded values.

Does openpyxl work with pandas to repair and recalculate Excel formulas?

Yes, openpyxl works with pandas to repair and recalculate Excel formulas. This Skill uses openpyxl and pandas workflows to modify workbooks and applies a LibreOffice script to enforce deterministic recalculation and eliminate formula errors like #VALUE! and #NAME?.

What is the best way to apply financial-model formatting conventions to a spreadsheet?

The best way to apply financial-model formatting conventions to a spreadsheet is by using this Skill to enforce industry-standard color coding and number-format conventions. This ensures assumptions and calculations remain readable and consistent in the final XLSX output.

Why do my spreadsheet formulas show calculated values instead of recalculating dynamically?

Spreadsheet formulas show static values instead of recalculating dynamically when calculated values are hardcoded. This Skill prevents that issue by using openpyxl workflows and LibreOffice recalculation to ensure deterministic Excel formula handling in the final XLSX output.