xlsx

Open, edit, and generate spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

1|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/caobingsheng/skills --skill xlsx-caobingsheng
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/caobingsheng/skills/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/caobingsheng/skills --skill xlsx-caobingsheng

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates repetitive spreadsheet tasks, eliminating manual edits and formatting to save time when working with Excel-like files.

Core Features & Use Cases

  • Open, read, edit, and fix spreadsheet files across formats (.xlsx, .xlsm, .csv, .tsv).
  • Apply formulas, formatting, charting, and data cleaning to produce a polished spreadsheet deliverable.
  • Use cases include batch conversions between tabular formats, bulk column additions, and restructuring messy data for downstream analytics.

Quick Start

Process a spreadsheet file to apply requested changes and return a finalized spreadsheet.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet formatting and data cleaning in xlsx files?

Automate spreadsheet formatting and data cleaning by opening .xlsx files with Python-based tooling like openpyxl to apply deterministic edits, formulas, and formatting, then outputting a polished spreadsheet deliverable.

Can I convert csv and tsv files into formatted xlsx spreadsheets?

Yes, you can convert csv and tsv files into formatted xlsx spreadsheets by processing the tabular inputs through automated scripts that apply structure, formulas, and charting to generate a valid spreadsheet deliverable.

What is the best way to bulk add columns and restructure messy data across multiple datasets?

The best way to bulk add columns and restructure messy data is using automated spreadsheet scripts that open multiple datasets, apply data cleaning transformations, and output finalized files for downstream analytics.

Does openpyxl support applying formulas and charting to xlsm files?

Yes, openpyxl supports opening .xlsm files to apply formulas, formatting, and charting, allowing automated scripts to perform deterministic edits and generate polished spreadsheet deliverables across supported formats.

What spreadsheet tasks can I automate without manual editing in Excel-like files?

You can automate routine spreadsheet tasks including opening, reading, editing, fixing, formatting, formula application, charting, and data cleaning across .xlsx, .xlsm, .csv, and .tsv files without manual editing.

Why does my automated spreadsheet conversion output a valid xlsx file?

Automated spreadsheet conversion outputs a valid xlsx file because the process relies on Python-based tooling like openpyxl to perform deterministic edits, ensuring the finalized deliverable maintains proper spreadsheet structure.