skills.rest
gujiachun-rainbow
gujiachun-rainbowCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Automates cleaning, formatting, and transforming spreadsheet data across .xlsx, .xlsm, .csv, and .tsv files.

8|1|Updated Apr 15, 2026
Search Tags:#formatting#excel#xlsx#conversion#data-transformation#data-cleaning
One-click install
npx skills add https://github.com/gujiachun-rainbow/RainClaw --skill xlsx-gujiachun-rainbow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/gujiachun-rainbow/RainClaw/tree/main/rainclaw/backend/builtin_skills/xlsx
Command: npx skills add https://github.com/gujiachun-rainbow/RainClaw --skill xlsx-gujiachun-rainbow

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the tedious and error-prone tasks involved in spreadsheet data cleaning, formatting, and transformation, enabling consistent outputs across formats like .xlsx, .xlsm, .csv, and .tsv.

Core Features & Use Cases

  • Open, read, edit, and clean existing spreadsheets, including messy data cleanup and column reorganization.
  • Create new spreadsheets from data sources and convert between tabular formats.
  • Apply formulas, format cells for reports, and restructure data for clean, repeatable outputs.

Quick Start

Clean and format the input spreadsheet 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?▼

Automate spreadsheet data cleaning by opening .xlsx, .xlsm, .csv, or .tsv files to restructure columns, clean messy data, and apply formulas for consistent outputs. It handles formatting and transformation automatically.

Can I convert CSV to XLSX while applying formulas and formatting?▼

Yes, you can convert CSV to XLSX while applying formulas and formatting cells for reports. The Skill creates new spreadsheets from data sources and converts between tabular formats using openpyxl.

Does openpyxl support non-destructive edits for existing .xlsm files?▼

Yes, openpyxl supports non-destructive edits for existing .xlsm files. The Skill relies on openpyxl for reading and writing to ensure original data is preserved and output validation is maintained.

What is the best way to clean and format TSV files for reporting?▼

The best way to clean TSV files is to automate data transformation and cell formatting across Excel-compatible formats. The Skill opens TSV sources, cleans the data, and saves formatted spreadsheet outputs.

How do I create a new spreadsheet from multiple data sources?▼

Create new spreadsheets from data sources by applying data cleaning, column reorganization, and formulas. The Skill processes inputs from .xlsx, .xlsm, .csv, and .tsv files to generate structured outputs.

Related Skills

Explore More Data & Analytics Skills→
UselessXuUselessXu

xlsx

Clean and convert .xlsx, .xlsm, .csv, and .tsv spreadsheets into validated outputs.

Community
Advanced
claude-office-skillsclaude-office-skills
368

data-analysis

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

Official
Intermediate
xlelibertyxleliberty

sample-text-processor

Analyze text file statistics and perform batch transformations with standard library Python modules.

Community
Basic
xiechyxiechy
3

dask

Parallelize pandas and NumPy workflows with Dask DataFrames and Arrays.

Community
Intermediate