xlsx

Clean, transform, and format Excel, CSV, and TSV files with openpyxl.

Updated Jan 19, 2026
One-click install
npx skills add https://github.com/iredrion-img/kh-rnd-wms --skill xlsx-iredrion-img
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/iredrion-img/kh-rnd-wms/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/iredrion-img/kh-rnd-wms --skill xlsx-iredrion-img

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Use this skill to automate common spreadsheet tasks, including cleaning, reformatting, and transforming data across Excel-compatible formats (.xlsx, .xlsm, .csv, .tsv), reducing manual tedium and errors.

Core Features & Use Cases

  • Clean and standardize columns and headers to produce tidy tabular data.
  • Apply formulas, format cells, and convert between tabular file formats (xlsx, csv, tsv).
  • Use Case: when you receive messy sales data in CSVs and need a polished workbook for analysis.

Quick Start

Clean and format the attached spreadsheet to produce a ready-to-use workbook.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and reformat messy Excel spreadsheets automatically?

You can clean and reformat spreadsheets automatically by standardizing column headers, restructuring tabular data, and applying consistent cell formatting across .xlsx and .xlsm files to produce tidy, ready-to-use workbooks.

What is the best way to convert CSV files into a formatted xlsx workbook?

The best way to convert CSV files into a formatted xlsx workbook is to use this skill for format automation, which transforms raw comma-separated data into polished spreadsheets with applied formulas and standardized columns.

Does openpyxl support applying formulas and formatting to xlsm files?

Yes, openpyxl supports applying formulas and formatting to xlsm files. This skill leverages openpyxl and related Python tooling to perform deterministic, locale-safe format automation on Excel-compatible files.

Can I use Python to automate data wrangling across xlsx, csv, and tsv formats?

Yes, you can use Python to automate data wrangling across xlsx, csv, and tsv formats. This skill handles format standardization and transformation, ensuring reproducible outputs for diverse tabular data workflows.

How do I standardize inconsistent column headers in sales data?

To standardize inconsistent column headers in sales data, apply this skill's data-cleaning functions to tidy tabular data, ensuring consistent naming and structure for downstream analysis and reporting.