xlsx

Open, clean, transform, and export spreadsheet files in xlsx, csv, and tsv formats.

18|6|Updated Mar 22, 2026
One-click install
npx skills add https://github.com/alter123-zz/RaccoonClaw --skill xlsx-alter123-zz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/alter123-zz/RaccoonClaw/tree/main/skills/xlsx
Command: npx skills add https://github.com/alter123-zz/RaccoonClaw --skill xlsx-alter123-zz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates a broad range of spreadsheet tasks when a file is the primary input or output, including opening, reading, editing, formatting, cleaning, and converting .xlsx, .xlsm, .csv, or .tsv files. It also covers creating new spreadsheets from scratch or from other data sources, and converting between tabular formats. The deliverable must always be a spreadsheet file.

Core Features & Use Cases

  • Open and inspect spreadsheet files across formats (xlsx, xlsm, csv, tsv) and apply transformations (add columns, compute formulas, format cells, create charts).
  • Clean and restructure messy tabular data (misplaced headers, malformed rows) into proper spreadsheets.
  • Convert between common tabular formats (e.g., CSV to XLSX, TSV to XLSX) and generate ready-to-use spreadsheets for reporting.

Quick Start

Run the skill to clean a messy CSV and export a polished XLSX ready for reporting.

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 data and convert it to a formatted XLSX file?

To clean messy CSV data and convert it to XLSX, this skill reads the malformed rows, restructures misplaced headers, and writes back a polished spreadsheet file ready for reporting.

What is the best way to automate adding columns and computing formulas in a spreadsheet?

Automating spreadsheet transformations like adding columns and computing formulas is handled by applying Python-based operations that read inputs, apply the data transformations deterministically, and write a new spreadsheet file.

Does this approach support converting between TSV, CSV, and XLSX formats?

Yes, converting between common tabular formats is fully supported, allowing you to open files like CSV or TSV, apply transformations, and export a ready-to-use XLSX spreadsheet file for business analytics workflows.

Can I use openpyxl to create charts and format cells in an existing xlsm file?

Yes, you can open and inspect xlsm files to apply transformations such as formatting cells and creating charts, leveraging the openpyxl dependency to ensure deterministic results when writing the new spreadsheet file.

Why use Python-based operations for spreadsheet data transformation instead of manual editing?

Using Python-based operations for spreadsheet data transformation ensures deterministic results by programmatically reading inputs, applying consistent cleaning and formatting rules, and writing back a new spreadsheet file without manual errors.

What are the limitations when processing very large spreadsheet files with this method?

When processing very large spreadsheet files, limitations may arise from memory constraints during Python-based operations, as the process requires reading inputs, applying transformations, and writing back a new spreadsheet file deterministically.