xlsx

Automate spreadsheet tasks across XLSX, CSV, and TSV files.

Updated Apr 21, 2026
One-click install
npx skills add https://github.com/HuuBar/skill-routing-experiment --skill xlsx-huubar
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/HuuBar/skill-routing-experiment/tree/main/unified_skills/anthropics/xlsx
Command: npx skills add https://github.com/HuuBar/skill-routing-experiment --skill xlsx-huubar

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml.

What problem does it solve?

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Core Features & Use Cases

  • Open, read, edit, and fix common spreadsheet formats including XLSX, XLSM, CSV, and TSV
  • Apply transformations: add columns, compute formulas, format cells, and adjust charts
  • Convert between tabular formats and consolidate messy data into clean spreadsheets
  • Use Case: Normalize a messy CSV into a clean XLSX with consistent headers, then export to CSV or XLSX for reporting

Quick Start

Open a spreadsheet, apply a simple transformation (such as adding a column or computing a formula), and save the result as a new spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet data cleaning and formatting for XLSX and CSV files?

Convert CSV to XLSX by reading the source tabular data, applying necessary data cleaning transformations like normalizing headers, and saving the result as a new spreadsheet file in the desired format.

Does this approach work with TSV and XLSM files for data transformation workflows?

This approach works with TSV and XLSM files, supporting data transformation workflows by opening, reading, and editing these formats to consolidate messy data into clean spreadsheets for analytics.

What is the best way to add columns and compute formulas in an existing spreadsheet?

The best way to add columns and compute formulas in an existing spreadsheet is to open the file, apply the necessary transformations programmatically, and save the updated result as a new spreadsheet file.

Can I use openpyxl to generate charts and format cells in XLSX files?

Yes, you can use openpyxl to generate charts and format cells in XLSX files, applying deterministic changes to adjust charts and format cells for reporting and data integration scenarios.

When should I not use a spreadsheet automation skill for tabular data tasks?

Do not use a spreadsheet automation skill when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.