xlsx

SKILL.md

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and error-free calculations.

Supports reading, creating, and modifying .xlsx, .xlsm, .csv, and .tsv files using pandas for data analysis and openpyxl for formulas and formatting

Automatically recalculates all formulas and scans for Excel errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?) using LibreOffice integration

Enforces industry-standard color coding and number formatting for financial models (blue for inputs, black for formulas, green for internal links, red for external links)

Includes comprehensive documentation requirements for hardcoded values and assumption-based formula construction to maintain dynamic, updateable spreadsheets

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