Skip to main content
affpapa.org
RU EN
skill

xlsx-official — Claude Code skill: what it does, how to install

Sets up workflows for creating, editing, and recalculating XLSX, XLSM, CSV, and TSV files. It builds financial models using dynamic formulas instead of static values.

Install into Claude Code · claude-code-templates All methods and platforms ↓ 
npx claude-code-templates@latest --skill document-processing/xlsx-official
Open on GitHub

What xlsx-official does

This skill structures operations on .xlsx, .xlsm, .csv, and .tsv files. It directs Claude Code to inspect tabular data with pandas and handle cell styling, structure, and formula injection through openpyxl. Spreadsheets must remain dynamic: calculations rely on native Excel functions like =AVERAGE() instead of static numbers evaluated in Python.

Detailed formatting rules govern financial modeling tasks. Standard conventions assign blue font to user inputs, black to calculation cells, and red to external workbook references. Assumptions belong in dedicated cells. Without LibreOffice installed on the machine, formula recalculation through scripts/recalc.py cannot run to catch errors like #REF! or #NAME?.

The workflow applies exclusively when the final deliverable is an actual spreadsheet file. It steps aside if the requested output is a database pipeline, a Word file, or an HTML report.

What it helps with

  • Fix formula calculation errors like #REF! or #DIV/0! in workbooks
  • Color-code financial models according to cell type conventions
  • Convert messy CSV or TSV exports into clean spreadsheet files
  • Inject dynamic Excel formulas via openpyxl avoiding static Python numbers

Example prompts for the agent

  • Check budget.xlsx for formula errors and recalculate the values.
  • Build a financial model in forecast.xlsx with separated assumptions and standard color codes.
  • Clean up broken rows in export.csv and export the clean table as data.xlsx.

How to install xlsx-official

1claude-code-templates

npx claude-code-templates@latest --skill document-processing/xlsx-official

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill xlsx-official -a claude-code

3Manually: put the files in place

~/.claude/skills/xlsx-official/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/xlsx-official/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about xlsx-official

How to install xlsx-official in Claude Code?

Run npx claude-code-templates@latest --skill document-processing/xlsx-official in your terminal.

What does the xlsx-official skill do?

It guides the agent to create and edit spreadsheets using real Excel formulas rather than hardcoded Python numbers. It also enforces financial modeling standards and catches formula errors.

What software is needed to verify spreadsheet formulas?

Formula recalculation with scripts/recalc.py requires LibreOffice installed on the host system. Python steps use pandas and openpyxl.

Similar skills

All skills for Office documents →
pptx official anthropics This skill helps create, read, and edit .pptx files and .potx templates. Use it when building a deck or extracting slide text. 241,433installs pdf official anthropics This skill lets an agent read, create, and edit PDF files, including forms and scanned documents. Use it when PDF work is part of the task. 216,041installs docx official anthropics This skill creates, reads, and edits Word documents and templates. Use it for reports, letters, and files that need headings, tables, or page numbers. 206,304installs xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs brand-guidelines official anthropics Applies Anthropic's official brand colors and fonts to documents, slides and other artifacts. Useful whenever something needs to match the company look. 109,043installs theme-factory official anthropics Applies preset color palettes and font pairs to slides, documents, and HTML pages. Use it when an artifact needs one consistent visual style. 94,921installs

From the same set804

The whole set →
blue-green-deployment A Claude slash command that sets up blue-green deployment: traffic switching, health validation and rollback. 206installs commit-smart This skill reads Git changes, suggests a commit type and scope, then drafts a message that explains the reason behind the work. Use it when a diff alone would leave the intent unclear. 205installs csharp-pro Get guidance on modern C# and .NET work, from async code to unit tests. Use it when building or checking an application. 205installs requirements-clarity Clarifies fuzzy feature descriptions through targeted questions before coding starts. It scores requirements on a 100-point scale and writes a finished PRD file. 204installs langsmith-tracing Exports Claude Code conversation traces to LangSmith for session tracking and analysis. Runs in the background right after Claude finishes responding. 204installs voice-ai-development Plan voice agents and apps that handle speech input and audio replies. Use it when choosing an approach for calls, transcription, or speech synthesis. 203installs graph-query This skill queries a project’s code graph to trace component links and assess the reach of a change. Use it before editing a function or model. 202installs web-security-testing A structured security assessment workflow for checking web apps against OWASP Top 10 flaws. It guides Claude Code through scanning, injection checks, and reporting. 201installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor