xlsx

Open, edit, format, clean, and convert spreadsheets between Excel and CSV formats.

Updated Apr 1, 2026
One-click install
npx skills add https://github.com/RugkeyPro/agent-skills --skill xlsx-rugkeypro
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/RugkeyPro/agent-skills/tree/main/xlsx
Command: npx skills add https://github.com/RugkeyPro/agent-skills --skill xlsx-rugkeypro

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the common, repetitive tasks involved in managing spreadsheet files by enabling operations like open, read, edit, format, compute formulas, clean messy data, and convert between .xlsx, .xlsm, .csv, and .tsv formats.

Core Features & Use Cases

  • Open, read, and edit spreadsheet data; apply formatting and basic data cleaning to fix malformed rows or headers.
  • Compute formulas, reorganize data, and convert between tabular formats (Excel to CSV/TSV and back) for data portability.
  • Use case: you receive a messy CSV of sales data, clean headers, perform simple aggregations, and export a clean Excel workbook.

Quick Start

Open a spreadsheet file, apply formatting and cleaning rules, and export the result in the desired format.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a CSV file to Excel format while cleaning messy headers?

To convert CSV to Excel while cleaning messy headers, you can open the file, apply formatting rules to fix malformed rows, and export the result as a clean .xlsx workbook for analytics and reporting.

Can I apply formulas and reorganize data directly in an .xlsx spreadsheet?

Yes, you can compute formulas and reorganize data directly in an .xlsx spreadsheet by applying operations that preserve data integrity while modifying the structure for your specific reporting requirements.

What's the best way to automate converting Excel to TSV format?

The best way to automate converting Excel to TSV format is by opening the .xlsx file and exporting the tabular data to .tsv format, ensuring data portability and preserving structural integrity.

Does openpyxl support applying formatting and fixing malformed rows in spreadsheet data?

Yes, openpyxl supports applying formatting and fixing malformed rows in spreadsheet data, allowing you to clean messy headers, perform simple aggregations, and export a properly formatted Excel workbook.

How do I clean messy sales data in a CSV and export it as a formatted Excel workbook?

To clean messy sales data in a CSV and export it as a formatted Excel workbook, open the file, apply data cleaning rules to fix headers and malformed rows, perform aggregations, and export to .xlsx.

Why does spreadsheet data conversion between .xlsx and .csv require data cleaning?

Spreadsheet data conversion between .xlsx and .csv requires data cleaning because format transitions can introduce malformed rows or misaligned headers, making it necessary to fix data integrity issues before exporting.