xlsx

Automate spreadsheet editing and data cleansing across xlsx, csv, and tsv formats.

Updated May 9, 2026
One-click install
npx skills add https://github.com/HwFee/AgentProject --skill xlsx-hwfee
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/HwFee/AgentProject/tree/main/skills/xlsx
Command: npx skills add https://github.com/HwFee/AgentProject --skill xlsx-hwfee

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the tedious manual tasks involved in spreadsheet work by enabling automated open, read, edit, and cleanup operations on .xlsx, .xlsm, .csv, and .tsv files, including restructuring messy data and preparing outputs.

Core Features & Use Cases

  • Open, read, edit, format, and fix existing spreadsheets
  • Create new spreadsheets from scratch or from other data sources
  • Convert between tabular formats (xlsx, csv, tsv) and reformatted outputs, with data cleaning and header normalization
  • Example: clean a messy CSV of sales data, apply formulas, normalize headers, and export a polished XLSX report

Quick Start

Load a messy input spreadsheet and produce a cleaned, normalized XLSX output.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate data cleaning and header normalization for messy CSV files?

Automating data cleaning for messy CSV files involves opening the input, restructuring the data, normalizing headers, and exporting a polished XLSX report. This Skill handles that workflow, applying formulas and formatting across large CSV or TSV imports.

Can I convert a CSV file to XLSX format and apply spreadsheet formulas automatically?

Yes, you can convert CSV files to XLSX format and apply spreadsheet formulas automatically. This Skill performs cross-format conversions between xlsx, csv, and tsv while simultaneously applying formulas and formatting to produce clean outputs.

Does openpyxl support editing and formatting large XLSX files for finance workflows?

openpyxl supports editing and formatting large XLSX files for data-heavy finance workflows. This Skill uses openpyxl alongside defusedxml and lxml to read, modify, and validate spreadsheet content for operations and marketing data.

What is the best way to normalize spreadsheet headers and restructure messy data?

The best way to normalize spreadsheet headers and restructure messy data is through automated data cleansing. This Skill handles header normalization and formatting automatically, preparing outputs for data-heavy workflows across diverse inputs.

Why does my spreadsheet conversion produce misaligned data when importing TSV files?

Spreadsheet conversion producing misaligned data from TSV imports often stems from unstructured inputs. This Skill resolves this by restructuring messy data, validating content with lxml, and normalizing headers during the conversion process.

When should I not use Python libraries like lxml for spreadsheet data cleansing?

You should not use Python libraries like lxml for spreadsheet data cleansing when working with simple, well-structured inputs that require only basic formatting. This Skill targets repetitive editing and complex restructuring of messy data.