xlsx Claude Code Skill
Claude Code SkillClaude CodeDocuments & Content CreationData Engineering & AnalyticsThe explanation below is AI-generated. Please verify it against the sources.
This skill is for creating, editing, reading, and converting spreadsheet files, including xlsx, xlsm, xltx, csv, and tsv formats. It relies on Python libraries such as openpyxl and pandas for building or modifying spreadsheets, markitdown for quick content previews, and a LibreOffice-based recalculation script to compute formula results and check for errors. It enforces conventions such as avoiding hardcoded formula results, documenting assumptions, and matching an existing file's formatting when editing. It also defines formatting rules for financial models, such as color-coding and number formats. It is invoked whenever the main input or output of a task is a spreadsheet file.
What you can do with xlsx
- Convert tabular data between different file formats
- Clean up messy or malformed tabular data into a properly structured spreadsheet
- Read spreadsheet content and formulas, including a quick sheet-by-sheet preview via markitdown
- Recalculate formulas with a LibreOffice-based script and check for calculation errors
- Apply financial-model formatting conventions such as color-coded cells and standardized number formats when building financial spreadsheets
Sources
History of xlsx
- Claude Code Skill Updated skill content (SKILL.md) of xlsx
- Claude Code Skill Updated the official description of xlsx