Agent skill · writing content · k-dense-ai
xlsx
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the workbook file is the primary deliverable. Use for formulas, formatting, financial models, multi-sheet workbooks, and tabular cleanup exported to Excel. Also applies to .csv/.tsv when the user wants spreadsheet output. Do NOT use for Word documents, HTML reports, standalone Python scripts, database pipelines, or Google Sheets API work.
Why this skill is useful
Provides specific commands and procedures for creating and managing Excel spreadsheets that the AI wouldn't reliably generate on its own.
What it needs
Requires libreoffice, python installed locally. About 5k tokens when loaded. Last updated 2026-08-03. 32,849 stars on the source repository.
What this skill does
XLSX creation, editing, and analysis Task Approach --- --- Create or edit with formulas/formatting openpyxl — see gotchas below Bulk data in or out pandas (readexcel, toexcel) 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 loadworkbook passes — see gotchas openpyxl, pandas, and markitdown are preinstalled — do not run uv pip install first; write the script and import directly. Only if an import fails (or the markitdown command is missing): uv pip install the missing package. Script paths below are relative to this skill's directory. Requirements for every output Professional font (Arial, Times New Roman) throughout, unless the user says otherwise. Zero formula errors. Never ship while recalc.py reports errorsfound. If you think an error predates you, prove it: load the original with dataonly=True and look at that cell. An error you introduced looks exactly like one you inherited. Use formulas, never hardcoded results. Write sheet['B10'] = '=SUM(B2:B9)', not the Python-computed total. The sheet must recalculate when its inputs change. Follow the user's spec literally. Exact tab names, exact column headers, and the formula they spelled out. A redesign that computes something else fails, however elegant. Document every assumption and hardcoded number where the reader will see it — a cell comment, or an adjacent cell at a table's end. Cite a real source when one exists (Source: Company 10-K, FY2024, Page 45, Revenue Note, [SEC EDGAR URL]); when the number came from the user, say so plainly. A workbook you create for someone to fill in needs a short legend naming which cells to edit, and one example row of realistic values showing the expected format. Never add such a row to a file you were asked to edit. Editing an existing file: match its conventions exactly. They override every guideline here. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills k-dense-ai/xlsx