skills.rest
alanharrryy-wq
alanharrryy-wqCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Automate spreadsheet workflows to clean, format, and convert tabular data.

2|Updated Feb 18, 2026
Search Tags:#automation#data transformation#spreadsheet#excel#xlsx#csv#data cleaning
One-click install
npx skills add https://github.com/alanharrryy-wq/hitech-os --skill xlsx-alanharrryy-wq
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/alanharrryy-wq/hitech-os/tree/main/.agents/skills/D_worker/xlsx
Command: npx skills add https://github.com/alanharrryy-wq/hitech-os --skill xlsx-alanharrryy-wq

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Open, read, edit, clean, format, and convert spreadsheets across .xlsx, .xlsm, .csv, and .tsv to produce polished outputs.

Core Features & Use Cases

  • Open and modify existing spreadsheets (xlsx/xlsm/csv/tsv), apply formulas, formatting, and data cleaning.
  • Create new spreadsheets from data sources, restructure tabular data, and export to CSV/TSV or Excel formats.
  • Use case: when a user references a spreadsheet by name or path and needs it cleaned, reorganized, or converted into a deliverable spreadsheet file.

Quick Start

Create a sample spreadsheet from provided data and save as an .xlsx 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 cleaning and formatting for multiple xlsx files?▼

You can automate spreadsheet cleaning by running Python scripts that leverage openpyxl and lxml to open, edit, and apply deterministic transformations to .xlsx, .xlsm, .csv, and .tsv files, producing polished spreadsheet outputs.

Can I convert CSV or TSV data into a formatted xlsx spreadsheet?▼

Yes, you can convert CSV or TSV data into a formatted .xlsx spreadsheet by restructuring the tabular data and applying formatting through automated scripts to generate a final spreadsheet file.

Does this approach support applying formulas and data validation to existing Excel files?▼

Yes, modifying existing spreadsheets supports applying formulas, formatting, and data cleaning to .xlsx and .xlsm files, using validators and openpyxl to ensure deterministic transformations and outputs.

What is the best way to restructure tabular data and export it as a spreadsheet deliverable?▼

The best way to restructure tabular data is using automated scripts that transform the source data and export it directly to CSV, TSV, or Excel formats, ensuring a final spreadsheet file is produced.

Are there limitations when editing xlsm files with openpyxl for data transformation?▼

While openpyxl and defusedxml handle .xlsm files for data transformation and formatting, complex macro execution or advanced Excel features may have limitations compared to native Excel processing.

Related Skills

Explore More Data & Analytics Skills→
YouMingYehYouMingYeh
2

xlsx

Clean, transform, and convert spreadsheet files between xlsx, csv, and tsv formats.

Community
Intermediate
claude-office-skillsclaude-office-skills
368

data-analysis

Analyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.

Official
Intermediate
AgentTeam-TaichuAIAgentTeam-TaichuAI
630

xlsx

Process and validate XLSX workbooks offline using openpyxl.

Community
Advanced
pablomat555pablomat555
1

xlsx

Clean, transform, and format spreadsheet data into finalized .xlsx files.

Community
Intermediate