xlsx

Clean, format, and convert spreadsheet data using Python and openpyxl.

2|Updated Feb 17, 2026
One-click install
npx skills add https://github.com/Haseeb-Arshad/TaskHive --skill xlsx-haseeb-arshad
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Haseeb-Arshad/TaskHive/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/Haseeb-Arshad/TaskHive --skill xlsx-haseeb-arshad

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates routine spreadsheet tasks to save time and reduce errors when working with Excel-based data, including reading, cleaning, formatting, and converting between common tabular formats.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets (.xlsx, .xlsm, .csv, .tsv) and apply transformations.
  • Create new spreadsheets from scratch or by importing data from other sources, and export to alternate formats.
  • Clean and restructure messy tabular data (misplaced headers, junk rows) to produce clean, production-ready sheets.

Quick Start

Load a target spreadsheet, perform the requested edits or transformations, 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 Excel data cleaning for messy spreadsheets with misplaced headers and junk rows?

Automate Excel data cleaning by loading your spreadsheet to restructure misplaced headers and remove junk rows, producing clean, production-ready sheets. This process uses openpyxl to read, validate, and overwrite messy tabular data automatically.

How do I convert CSV or TSV files into formatted XLSX spreadsheets?

Convert CSV or TSV files into XLSX spreadsheets by importing the source data and applying format conversion steps. The process validates the input tabular structure and exports a newly formatted spreadsheet file with your requested column additions and formulas.

Does openpyxl support reading and editing XLSM files with formulas and charts?

Yes, openpyxl supports reading and editing XLSM files, allowing you to compute formulas and add charting. The automation process applies transformations to .xlsx, .xlsm, .csv, and .tsv inputs while validating results to ensure reproducible outputs.

What is the best way to add computed columns and apply formatting to existing spreadsheets?

The best way to add computed columns and apply formatting to existing spreadsheets is through automated Python scripts using openpyxl. This approach reads your input file, applies the requested transformations and formatting, and saves a new spreadsheet file.

Can I create a new spreadsheet from scratch and export it to an alternate tabular format?

Yes, you can create a new spreadsheet from scratch or import data from other sources, then export it to alternate tabular formats. The process uses validation and conversion steps to ensure reproducible results across .xlsx, .xlsm, .csv, and .tsv outputs.

Why does my spreadsheet format conversion process fail to produce reproducible results?

Spreadsheet format conversion fails to produce reproducible results when validation steps are skipped during the read/write process. Including defusedxml and lxml dependencies ensures secure parsing and consistent transformation outputs across your tabular data files.