skills.rest
FelipePepe
FelipePepeCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/FelipePepe/TeamHub --skill xlsx-felipepepe
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
JStaRFilmsJStaRFilms
23

xlsx

Process and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Intermediate
zhuxiningzhuxining

xlsx

Create, edit, and analyze .xlsx, .xlsm, and .csv spreadsheets with openpyxl.

Community
Advanced
mohamedhabibworkmohamedhabibwork
1

xlsx

Read, clean, and convert spreadsheet data to XLSX using openpyxl.

Community
Intermediate
Phife726Phife726

xlsx

Automate spreadsheet data processing and cleanup for XLSX, CSV, and TSV workbooks.

Community
Intermediate