skills.rest
datascienceworld-kan
datascienceworld-kanCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Clean, transform, and format spreadsheet data into .xlsx deliverables.

73|11|Updated May 18, 2025
Search Tags:#formatting#spreadsheet#excel#xlsx#conversion#data-cleaning
One-click install
npx skills add https://github.com/datascienceworld-kan/vinagent --skill xlsx-datascienceworld-kan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/datascienceworld-kan/vinagent/tree/main/agentskills/skills/skills/xlsx
Command: npx skills add https://github.com/datascienceworld-kan/vinagent --skill xlsx-datascienceworld-kan

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates spreadsheet data cleaning, transformation, and formatting to produce polished Excel deliverables. It enables tasks such as opening, reading, editing, fixing, and converting data across .xlsx, .xlsm, .csv, and .tsv formats, with the ability to create new spreadsheets from scratch or by combining multiple data sources, and to convert between tabular formats. The deliverable is always a spreadsheet file, and the Skill avoids triggering when the primary deliverable is a Word doc, HTML report, standalone Python script, database pipeline, or Google Sheets API integration.

Core Features & Use Cases

  • Open, read, and modify Excel workbooks including adding columns, applying formulas, formatting, and charting.
  • Create new spreadsheets from scratch or by aggregating data from multiple sources, and convert between tabular formats.
  • Real-world use: Clean a messy CSV, produce a polished .xlsx with computed columns and charts, and export to another tabular format for reporting.

Quick Start

Open a dataset and run the skill to generate a clean .xlsx output.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean a messy CSV and convert it to a formatted Excel file?▼

To clean a messy CSV and convert it to a formatted Excel file, this Skill automates data transformation and formatting to produce a polished .xlsx deliverable with computed columns and charts.

What is the best way to automate Excel formatting and add formulas to existing workbooks?▼

Automating Excel formatting and adding formulas relies on Python tooling like openpyxl to deterministically manipulate workbooks, allowing you to update columns, apply formulas, and add charts to existing .xlsx or .xlsm files.

Does openpyxl support converting between xlsx, csv, and tsv tabular formats?▼

Yes, openpyxl supports converting between tabular formats by reading existing .xlsx, .xlsm, .csv, and .tsv files, enabling you to aggregate data sources and export a final spreadsheet deliverable.

Can I create a new spreadsheet from scratch or by combining multiple data sources?▼

You can create new spreadsheets from scratch or by aggregating data from multiple sources, applying formatting and charting while ensuring the final output is a clean .xlsx file.

When should I not use automated spreadsheet formatting for my data workflow?▼

Automated spreadsheet formatting is not suitable when your primary deliverable is a Word doc, HTML report, standalone Python script, database pipeline, or Google Sheets API integration rather than a final .xlsx file.

Related Skills

Explore More Data & Analytics Skills→
XCmiaowXCmiaow

xlsx

Clean, edit, analyze, and generate Excel, CSV, and TSV spreadsheets with formula validation.

Community
Advanced
HybridAIOneHybridAIOne
126

xlsx

Create, import, and update Excel .xlsx workbooks with formulas and styling.

Official
Intermediate
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic