xlsx

Automate spreadsheet tasks on .xlsx, .xlsm, .csv, and .tsv files.

Updated May 3, 2026
One-click install
npx skills add https://github.com/wanyusheng63-alt/vocab-learn --skill xlsx-wanyusheng63-alt
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/wanyusheng63-alt/vocab-learn/tree/main/.codebuddy/skills/xlsx
Command: npx skills add https://github.com/wanyusheng63-alt/vocab-learn --skill xlsx-wanyusheng63-alt

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill automates the repetitive, error-prone tasks involved in managing spreadsheet data, enabling you to open, edit, format, clean, and convert spreadsheets without manual scripting.

Core Features & Use Cases

  • Open, read, edit, and fix existing spreadsheets in .xlsx, .xlsm, .csv, and .tsv formats.
  • Add columns, compute formulas, apply formatting, and convert between tabular file formats.
  • Create new spreadsheets from scratch or from data sources and clean or restructure messy data to produce a well-formed output file.

Quick Start

Open the provided spreadsheet, apply the requested edits (e.g., add a column, compute a formula, adjust formatting), and output 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 adding columns and computing formulas in an existing spreadsheet?

To automate spreadsheet tasks like adding columns and computing formulas, you can use this skill to open .xlsx, .xlsm, .csv, or .tsv files and apply modifications. It leverages Python libraries like pandas and openpyxl to produce a ready-to-use output file.

What is the best way to clean messy spreadsheet data and convert between file formats?

The best way to clean messy spreadsheet data and convert formats is to apply automated transformations that restructure inputs into well-formed outputs. This skill processes .xlsx, .xlsm, .csv, and .tsv files to clean and restructure data automatically.

Does openpyxl preserve existing formulas and styles when modifying an Excel workbook?

Yes, openpyxl preserves existing formulas and styles when modifying an Excel workbook. This skill leverages openpyxl and pandas to edit .xlsx and .xlsm files while maintaining the original formulas and styles, producing a ready-to-use spreadsheet.

Can I use pandas to fix and restructure messy .csv or .tsv files?

Yes, you can use pandas to fix and restructure messy .csv or .tsv files. This skill reads tabular inputs in those formats, cleans the messy data, and outputs a well-formed spreadsheet file ready for downstream use.

How do I create a new spreadsheet from scratch or from external data sources?

To create a new spreadsheet from scratch or from data sources, this skill applies automated scripts to generate a well-formed output file. It structures the raw data into a formatted .xlsx workbook with computed formulas and applied formatting.

What are the limitations when automating spreadsheet formatting and charting with Python?

Limitations when automating spreadsheet formatting and charting with Python depend on the capabilities of openpyxl and pandas. This intermediate-level skill handles common formatting and charting operations for .xlsx and .xlsm files but may face constraints with highly complex or non-standard Excel features.