skills.rest
GCWing
GCWingCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Clean, format, and convert XLSX, CSV, and TSV spreadsheet data.

1.6k|179|Updated Feb 2, 2026
Search Tags:#spreadsheet#xlsx#data-transformation#data-cleaning#csv-to-xlsx
One-click install
npx skills add https://github.com/GCWing/BitFun --skill xlsx-gcwing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/GCWing/BitFun/tree/main/src/crates/core/builtin_skills/xlsx
Command: npx skills add https://github.com/GCWing/BitFun --skill xlsx-gcwing

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates the tedious, error-prone tasks of cleaning, formatting, and converting spreadsheet data by enabling automated editing and transformation of Excel and tabular files.

Core Features & Use Cases

  • Open, read, edit, and fix .xlsx, .xlsm, .csv, and .tsv files.
  • Create new spreadsheets from scratch or from other data sources, with formatting, formulas, and charts.
  • Convert between tabular file formats and restructure malformed data (misplaced headers, junk rows) into proper spreadsheets.
  • Trigger when a user references a spreadsheet by name or path — even casually — to produce a deliverable spreadsheet file.
  • Use Case: Clean a messy CSV of monthly sales into a polished .xlsx with calculated fields and a chart for reporting.

Quick Start

Produce a cleaned, formatted .xlsx file from input data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and format a messy CSV file into a polished spreadsheet?▼

Yes, you can convert CSV and TSV files to XLSX format. This Skill automates tabular format conversion and restructures malformed data into proper spreadsheets without manual intervention.

How do I add calculated fields and charts to an existing .xlsx file?▼

You can add calculated fields and charts to an existing .xlsx file by referencing the spreadsheet path. The Skill applies formula computations and charting to automate reporting and data transformation tasks.

Can I convert CSV to XLSX and fix misplaced headers automatically?▼

Yes, you can convert CSV to XLSX and fix misplaced headers automatically. This Skill restructures malformed tabular data, removes junk rows, and outputs a properly formatted spreadsheet file.

Does this spreadsheet cleaning tool require manual Excel setup to run?▼

No, this spreadsheet cleaning tool does not require manual Excel setup. It relies on Python-based Excel tooling to perform deterministic edits and format conversions directly on .xlsx, .csv, and .tsv files.

What is the best way to automate monthly sales data transformation for reporting?▼

The best way to automate monthly sales data transformation for reporting is using this Skill to clean messy CSV inputs, add calculated fields, and generate a formatted .xlsx file with charts.

Related Skills

Explore More Data & Analytics Skills→
YouMingYehYouMingYeh
2

xlsx

Clean, transform, and convert spreadsheet files between xlsx, csv, and tsv formats.

Community
Intermediate
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-analytics-reporter

Analyze data, build statistical models, and generate business intelligence reports.

Community
Advanced
kaustubhhiwarekaustubhhiware

xlsx

Create, edit, and analyze Excel .xlsx files with pandas and openpyxl.

Community
Advanced
matevipmatevip
839

xlsx

Create, edit, and convert xlsx, xlsm, csv, and tsv spreadsheet files.

Community
Advanced