xlsx

Automate Excel workbook processing, editing, cleaning, and converting spreadsheet data.

Updated Jan 25, 2026

Search Tags:#automation #formulas #excel #xlsx #data-transformation #data-cleaning

Ready to run

npx skills add https://github.com/FelipePepe/TeamHub --skill xlsx-felipepepe

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/FelipePepe/TeamHub/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/FelipePepe/TeamHub --skill xlsx-felipepepe

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Automates the end-to-end processing of spreadsheet workbooks, reducing manual Excel tasks by opening, editing, cleaning, and converting XLSX, CSV, and TSV data into finished spreadsheets.

Core Features & Use Cases

Open, read, edit, and format existing spreadsheets; create new workbooks from data sources; convert between XLSX, CSV, and TSV formats; apply formulas, perform data cleaning, and generate charts.
Use Case: clean a messy CSV, transform it into a polished XLSX with computed columns and charts for reporting.
Use Case: convert a CSV inventory to XLSX with formatted headers and computed totals.

Quick Start

Provide the path to your spreadsheet and specify the transformation you want, and I will output a polished XLSX.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel workbook processing to clean and format messy data?▼

Automating Excel workbook processing involves using scripts to open, edit, clean, and convert XLSX, CSV, and TSV files, reducing manual tasks by recalc formulas, validating outputs, and preserving existing templates.

Can I convert CSV to XLSX and add formulas and charts automatically?▼

Yes, converting CSV to XLSX automatically applies formulas, performs data cleaning, and generates charts, outputting a final spreadsheet along with dependency and component metadata.

Does openpyxl support recalc formulas and preserving existing templates in xlsx files?▼

Yes, the automation uses openpyxl with scripts like recalc.py to recalc formulas, validate outputs, and preserve existing templates, ensuring existing XLSX structures remain intact during transformation.

What is the best way to transform a CSV file into a polished XLSX for reporting?▼

The best way to transform a CSV into a polished XLSX for reporting is to automate the end-to-end processing, which cleans messy data, applies computed columns, and generates charts for reporting.

How do I update formulas and format headers in existing spreadsheets without breaking templates?▼

To update formulas and format headers without breaking templates, use deterministic Python tooling that opens and edits the file, validates outputs, and preserves existing templates during the transformation.