xlsx

Open, read, edit, and convert spreadsheet files using openpyxl and pandas.

27|4|Updated Mar 6, 2026
One-click install
npx skills add https://github.com/skateddu/claude-code-python-setup --skill xlsx-skateddu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/skateddu/claude-code-python-setup/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/skateddu/claude-code-python-setup --skill xlsx-skateddu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, defusedxml, lxml, validators.

What problem does it solve?

Use this skill any time a spreadsheet file is the primary input or output. This means tasks where the user wants to open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Core Features & Use Cases

  • Open, read, edit, and fix spreadsheet files in multiple formats (.xlsx, .xlsm, .csv, .tsv)
  • Add columns, compute formulas, format cells, generate charts, and clean or restructure messy data
  • Create new spreadsheets from scratch or from other data sources and convert between tabular formats

Quick Start

Process the attached file to produce a clean, formatted spreadsheet as output.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate cleaning messy data in an xlsx spreadsheet?

To automate spreadsheet data cleaning, this skill uses openpyxl and pandas to open, read, and fix messy .xlsx, .xlsm, .csv, or .tsv files. It restructures tabular data and outputs a cleaned spreadsheet deliverable.

Can I add formulas and generate charts in an existing xlsx file?

Yes, you can add formulas and generate charts in an existing spreadsheet file. This skill edits .xlsx and .xlsm files directly to compute formulas, format cells, and create charts while preserving the original spreadsheet structure.

What is the best way to convert csv files to formatted xlsx spreadsheets?

The best way to convert csv files to xlsx spreadsheets is by using this skill to parse tabular data with pandas and write a formatted output file. It handles conversions between tabular formats like .csv, .tsv, and .xlsx.

Does this spreadsheet automation tool work with xlsm files?

Yes, this spreadsheet automation tool works with .xlsm files. It can open, read, edit, and fix .xlsm files alongside standard .xlsx, .csv, and .tsv formats using Python tooling.

When should I not use a spreadsheet workflow for my data task?

You should not use a spreadsheet workflow if your primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration. This skill is strictly for producing spreadsheet files.

Do I need Python to create new spreadsheets from other data sources?

You do not need to write Python yourself to create new spreadsheets from other data sources. This skill handles the Python execution internally via openpyxl and pandas to generate the final spreadsheet file automatically.