# XLSX

> Use when the user wants to create or edit spreadsheets, analyze CSV data, or clean up tabular data.

- Skill: `anujkumar8076/xlsx` (Agent Skill)
- Install (CLI): `npx skillmds@latest add anujkumar8076/xlsx`
- Raw SKILL.md: https://api.skillmd.com/api/skills/anujkumar8076/xlsx/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: anujkumar8076 (https://skillmd.com/u/anujkumar8076)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/anujkumar8076/xlsx

---

# Spreadsheet Skill

Work with Excel workbooks and CSV data.

## Setup

```bash
pip install openpyxl pandas
```

## Creating a workbook

Build with openpyxl: create a workbook, write header row, append data rows,
apply number formats, then save as .xlsx.

## Analyzing CSV data

Load with pandas, report shape and dtypes first, then run the analysis the
user asked for. Show intermediate results for anything non-obvious.

## Data cleanup

Normalize column names, trim whitespace, coerce types explicitly, and report
how many rows were affected by each cleanup step.

## Output format

Save as .xlsx unless the user asked for CSV. Summarize what changed.