skills.rest
thechrickenrun-cyber
thechrickenrun-cyberCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, clean, edit, and repair Excel spreadsheet workbooks and tabular files.

1|Updated May 5, 2026
Search Tags:#formulas#spreadsheet#excel#csv#data cleaning#workbook#tsv
One-click install
npx skills add https://github.com/thechrickenrun-cyber/wedding --skill xlsx-thechrickenrun-cyber
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/thechrickenrun-cyber/wedding/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/thechrickenrun-cyber/wedding --skill xlsx-thechrickenrun-cyber

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the friction of working with spreadsheet files by helping you open, clean, edit, repair, convert, and generate tabular workbooks with reliable structure and formatting.

Core Features & Use Cases

  • Spreadsheet Editing: Update existing Excel and tabular files while preserving formulas, layout, and workbook behavior.
  • Data Cleaning and Conversion: Turn messy CSV or TSV data into well-formed spreadsheets and restructure tables into usable formats.
  • Workbook Repair and Validation: Recalculate formulas, check for XML or relationship issues, and fix common spreadsheet integrity problems.
  • Use Case: A team receives a messy export from another system, and this Skill can normalize the data, add formulas, format the workbook, and return a polished .xlsx deliverable.

Quick Start

Use the xlsx skill to open the attached spreadsheet, clean or modify it as needed, and return a polished Excel file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert messy CSV or TSV data into a formatted Excel workbook?▼

To convert messy CSV or TSV data into a formatted Excel workbook, use the xlsx skill to normalize the tabular data, restructure tables, add formulas, and return a polished .xlsx file with professional formatting.

Can I edit existing Excel files while preserving formulas and workbook layout?▼

Yes, you can edit existing Excel files while preserving formulas, layout, and workbook behavior. The skill updates spreadsheet workbooks safely using XML-safe packing and unpacking to maintain spreadsheet fidelity.

How do you repair corrupted Excel files and check spreadsheet integrity?▼

To repair corrupted Excel files and check spreadsheet integrity, the skill validates XML relationships, fixes common structural issues, and recalculates formulas using LibreOffice support to restore workbook behavior.

Does this spreadsheet editing tool require openpyxl to apply formulas?▼

Yes, the spreadsheet editing tool uses openpyxl as a core dependency to apply formulas, format sheets, and manipulate workbook structures while preserving formula-based calculations and XML-safe packing.

What is the best way to restructure messy tabular data into a usable spreadsheet format?▼

The best way to restructure messy tabular data into a usable spreadsheet format is to import the CSV or TSV data, apply data cleaning rules, add formulas, and export a well-formed .xlsx workbook with validation checks.

Related Skills

Explore More Data & Analytics Skills→
ingbyringbyr
2

xlsx

Clean and transform spreadsheet data across xlsx, csv, and tsv formats.

Community
Intermediate
eduardoabreu81eduardoabreu81
6

xlsx

Create and analyze XLSX workbooks with openpyxl, validating formulas and recalculations.

Community
Advanced
Victory-HugoVictory-Hugo
1

xlsx

Create, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.

Community
Advanced
gaos6egaos6e

xlsx

Read, edit, and format Excel and tabular files into .xlsx outputs.

Community
Intermediate