XLSX Manipulation

Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl

581 stars 105 forksDocuments & Office Files

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add claude-office-skills/skills --skill xlsx-manipulation
Manual install
git 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-manipulation

Personal 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 Operations
Read the full skill on GitHub

Details

Skill name
xlsx-manipulation
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

581

claude-office-skills/skills

Search and analyze academic literature. Find papers, understand research methodologies, and synthesize academic findings for research projects.

Research & Science105

Ads Copywriter

581

claude-office-skills/skills

Multi-platform ad copy generation for Google Ads, Meta/Facebook, TikTok, LinkedIn with A/B testing variants

Marketing, Sales & Business105

AI Agent Builder

581

claude-office-skills/skills

Build AI agents with tools, memory, and multi-step reasoning - ChatGPT, Claude, Gemini integration patterns

AI, LLMs & Agents105

XLSX

339

Qwen-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

Documents & Office Files25

Super Slides

330

Jianing1117/jianing-skills

创建美观、实用的演示材料,主输出为 HTML 互动演示稿,可选导出 PPT/PDF。用于用户要做演示、PPT、 分享稿、演讲稿、培训材料、答辩、路演、汇报、产品介绍、pitch deck 或课件。即使只说“帮我做个分享” 或“我要汇报一下”,只要需要结构化演示也应触发。

Documents & Office Files42

XLSX 122B

339

Qwen-Applications/Trace2Skill

Use when handling spreadsheet tasks in .xlsx files with the released 122B created-from-scratch skill

Documents & Office Files25

Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.