# Spreadsheet Editing

Create, edit and clean xlsx, csv and tsv spreadsheets with formulas and charts.

- Repository: https://github.com/anthropics/skills (186321 stars)
- Category: Documents
- License: see repository
- Last updated: 2026-10-28
- Runs scripts: yes, review before use

## Install

Claude Code: `npx skills add anthropics/skills --skill xlsx -g -a claude-code -y`
Codex: `npx skills add anthropics/skills --skill xlsx -g -a codex -y`
Cursor: `npx skills add anthropics/skills --skill xlsx -g -a cursor -y`
Gemini CLI: `npx skills add anthropics/skills --skill xlsx -g -a gemini-cli -y`
Claude Code plugin marketplace: `/plugin marketplace add anthropics/skills`

## Description

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .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. Trigger especially when the user references a spreadsheet file by name or path, even casually (like \"the xlsx in my downloads\"), and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. 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.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# XLSX creation, editing, and analysis

| Task | Approach |
|---|---|
| **Create** or **edit** with formulas/formatting | `openpyxl`, see gotchas below |
| **Bulk data** in or out | `pandas` (`read_excel`, `to_excel`) |
| **Quick look** at a sheet | `markitdown file.xlsx`, `## SheetName` per sheet; reads `.xlsm` too. No cell coordinates, so don't plan edits from it |
| **Read** a model (formulas *and* values) | two `load_workbook` passes, see gotchas |

> `openpyxl`, `pandas`, and `markitdown` are preinstalled, do not run `pip install` first; write the script and import directly. Only if an import fails (or the `markitdown` command is missing): `pip install` the missing package.

> Script paths below are relative to this skill's directory.

## Requirements for every output

The rest: https://github.com/anthropics/skills/blob/HEAD/skills/xlsx/SKILL.md