xlsx

Originally fromanthropics/skills
Installation
SKILL.md

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, no cell coordinates. Use openpyxl for .xlsm and precise edits
Read a model (formulas and values) two load_workbook passes — see gotchas

Do not assume packages are preinstalled. Reuse a suitable environment or use uv run --with openpyxl==3.1.5 python your_script.py. Install optional tabular readers only when needed; MarkItDown requires its xlsx extra. The bundled workflow was exercised with openpyxl 3.1.5 and LibreOffice 26.2.4.2; current online LibreOffice help describes 26.8.

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

Requirements for every output

Installs
1.8K
GitHub Stars
48.2K
First Seen
Jan 20, 2026