xlsx

Automate spreadsheet preparation and data cleansing for .xlsx, .xlsm, .csv, and .tsv files.

9|2|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/Treasoni/kaoyan --skill xlsx-treasoni
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Treasoni/kaoyan/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/Treasoni/kaoyan --skill xlsx-treasoni

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml.

What problem does it solve?

Use this skill to manage spreadsheet-centric tasks: opening, reading, editing, fixing, and converting .xlsx, .xlsm, .csv, or .tsv files (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create new spreadsheets from scratch or from other data sources; and convert between tabular file formats. Trigger especially when a user references a spreadsheet file by name or path — even casually — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers) into proper spreadsheets. The deliverable must be a spreadsheet file.

Core Features & Use Cases

  • Open, read, edit, format, compute formulas, chart, and convert between .xlsx, .xlsm, .csv, and .tsv; create new spreadsheets from data sources and export to common tabular formats.
  • Clean and normalize messy data: fix malformed rows, misplaced headers, and reorganize data into a consistent spreadsheet structure.
  • Convert between tabular formats (xlsx, csv, tsv) and generate ready-to-use spreadsheet files for downstream analysis.

Quick Start

Provide a data source or sample table and the skill will output a ready-to-use spreadsheet file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean messy CSV files and fix malformed rows?

To clean messy CSV files, this skill fixes malformed rows and misplaced headers, reorganizing inconsistent tabular data into a normalized spreadsheet structure and exporting a ready-to-use file.

Can I convert CSV to XLSX while preserving formulas and formatting?

Yes, you can convert CSV to XLSX while applying formulas and formatting. The skill handles format conversions between .xlsx, .xlsm, .csv, and .tsv files through deterministic scripts.

How do I create a new spreadsheet from an existing data source?

You can create a new spreadsheet from a data source by providing a sample table or data input. The skill processes the input and outputs a ready-to-use spreadsheet file for downstream use.

Does this skill support updating formulas and adding charts to existing spreadsheets?

Yes, this skill supports updating formulas and adding charts. It automates spreadsheet preparation by opening, reading, editing, and formatting .xlsx and .xlsm files programmatically.

What is the best way to automate data transformation for tabular formats?

The best way to automate data transformation for tabular formats is using programmatic file I/O. This skill performs table transformations and format conversions with robust validation.

Do I need Python dependencies to convert TSV files to spreadsheet format?

Yes, the skill relies on Python dependencies like openpyxl, defusedxml, and lxml to parse and convert TSV files into standard spreadsheet formats with deterministic validation.