XLSX Manipulation
Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
Install
npx skills add claude-office-skills/skills --skill xlsx-manipulationgit clone --depth 1 https://github.com/claude-office-skills/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/xlsx-manipulation ~/.claude/skills/xlsx-manipulationPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# XLSX Manipulation Skill
## Overview
This skill enables programmatic creation, editing, and manipulation of Microsoft Excel (.xlsx) spreadsheets using the **openpyxl** library. Create professional spreadsheets with formulas, formatting, charts, and data validation without manual editing.
## How to Use
1. Describe the spreadsheet you want to create or modify
2. Provide data, formulas, or formatting requirements
3. I'll generate openpyxl code and execute it
**Example prompts:**
- "Create a budget spreadsheet with monthly tracking"
- "Add conditional formatting to highlight values above threshold"
- "Generate a pivot-table-like summary from this data"
- "Create a dashboard with charts and KPIs"
## Domain Knowledge
### openpyxl Fundamentals
```python
from openpyxl import Workbook, load_workbook
from openpyxl.styles import Font, Fill, Border, Alignment
from openpyxl.chart import BarChart, Reference
# Create new workbook
wb = Workbook()
ws = wb.active
# Or open existing
wb = load_workbook('existing.xlsx')
ws = wb.active
```
### Workbook Structure
```
Workbook
├── worksheets (sheets/tabs)
│ ├── cells (data storage)
│ ├── rows/columns (formatting)
│ ├── merged_cells
│ └── charts
├── defined_names (named ranges)
└── styles (formatting templates)
```
### Working with Cells
#### Basic Cell OperationsDetails
- Skill name
xlsx-manipulation- Repository
- claude-office-skills/skills
- Path
xlsx-manipulation/SKILL.md- License
- MIT
- Repo updated
- 31 January 2026
FAQ
What does the XLSX Manipulation skill do?
Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
How do I install the XLSX Manipulation skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add claude-office-skills/skills --skill xlsx-manipulation. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is XLSX Manipulation popular?
It lives in claude-office-skills/skills, which has 581 GitHub stars and 105 forks.
Related skills
Academic Search
581claude-office-skills/skills
Search and analyze academic literature. Find papers, understand research methodologies, and synthesize academic findings for research projects.
Ads Copywriter
581claude-office-skills/skills
Multi-platform ad copy generation for Google Ads, Meta/Facebook, TikTok, LinkedIn with A/B testing variants
AI Agent Builder
581claude-office-skills/skills
Build AI agents with tools, memory, and multi-step reasoning - ChatGPT, Claude, Gemini integration patterns
XLSX
339Qwen-Applications/Trace2Skill
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Qwen-Agent needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
Super Slides
330Jianing1117/jianing-skills
创建美观、实用的演示材料,主输出为 HTML 互动演示稿,可选导出 PPT/PDF。用于用户要做演示、PPT、 分享稿、演讲稿、培训材料、答辩、路演、汇报、产品介绍、pitch deck 或课件。即使只说“帮我做个分享” 或“我要汇报一下”,只要需要结构化演示也应触发。
XLSX 122B
339Qwen-Applications/Trace2Skill
Use when handling spreadsheet tasks in .xlsx files with the released 122B created-from-scratch skill
Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.