← All Skill Guides

Skill Guides · Weekly archive

Keep formulas and templates intact with the xlsx skill

A spreadsheet workflow that keeps calculations editable and checks for formula errors before delivery.

Week of Added September 8, 2026Office

Anthropic’s xlsx skill is aimed at tasks where a spreadsheet is the main input or deliverable: cleaning a workbook, adding calculations, building a tracker or updating a template. Its central instruction is to preserve the workbook’s usefulness after the agent finishes, including formulas that respond when users change the inputs.

For calculations, the skill favors Excel formulas over answers computed in Python and pasted into cells. When revising a workbook, existing fonts, layout and formatting conventions take precedence over its defaults. That makes it relevant to recurring reports where a correct number in a newly reformatted sheet would still be an unwanted change.

The documented toolkit uses pandas for data work and openpyxl for workbook structure and formulas. Because writing a formula does not calculate its cached result, a separate scripts/recalc.py step uses LibreOffice to recalculate the file and report formula errors. The intended workflow is to correct those errors before delivering the workbook.

Users need the relevant Python packages and a working LibreOffice installation for that recalculation step. The skill is source-available under Anthropic’s proprietary terms, rather than a standard open-source license. It supplies a document workflow; it does not establish that a workbook’s underlying assumptions or source data are correct.

Sources