Skip to main content
affpapa.org
RU EN
skill

spreadsheet — Claude Code skill: Excel and CSV work in Python

A skill for spreadsheet tasks: build workbooks with formulas, edit existing files, compute metrics and add charts. Useful when formulas and styling must survive the edit.

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

What spreadsheet does

The skill gives the agent a fixed routine for tabular work: pin down the file type and the goal first, then pick the tool. Editing .xlsx goes through openpyxl; analysis and .csv/.tsv files go through pandas. Layout matters? The agent renders the sheet to PNG so someone can look at it.

Formula rules are spelled out. Derived values stay as formulas, not pasted numbers, and cell references replace hardcoded constants. Error values such as #REF! and #DIV/0! get checked. Note the catch: openpyxl never evaluates formulas, so results appear only when the file opens in Excel or Sheets.

For visual review you need LibreOffice (soffice) and Poppler (pdftoppm) — without them rendering does not happen. Packages install with uv pip install openpyxl pandas, and matplotlib is listed for chart-heavy work.

What it helps with

  • build a workbook with formulas and formatting from scratch
  • edit an existing .xlsx without breaking references
  • aggregate a CSV and write the result back to a sheet
  • attach charts and tidy up number formats
  • render a sheet to catch layout problems before sending

Example prompts for the agent

  • Build report.xlsx with monthly revenue, totals as formulas, and a styled header row
  • Analyze sales.csv, sum revenue by region, and write the summary into summary.xlsx
  • Add a chart for the revenue column on the KPI sheet and check that no text overflows its cells

How to install spreadsheet

1claude-code-templates

npx claude-code-templates@latest --skill document-processing/spreadsheet

2Skills CLI (Vercel)

npx skills add davila7/claude-code-templates --skill spreadsheet -a claude-code

3Manually: put the files in place

~/.claude/skills/spreadsheet/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/spreadsheet/

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

Questions about spreadsheet

How do I install spreadsheet in Claude Code?

Run npx claude-code-templates@latest --skill document-processing/spreadsheet. Alternatively use npx skills add davila7/claude-code-templates --skill spreadsheet -a claude-code.

What does the spreadsheet skill do?

It guides the agent through creating, editing and analyzing spreadsheets: .xlsx with openpyxl, .csv and .tsv with pandas, with checks on formulas and formatting.

What has to be installed for it to work?

The openpyxl and pandas Python packages, plus matplotlib for chart-heavy work. Visual layout checks also need LibreOffice and Poppler.

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 set495

The whole set →
marp-slide Turns a rough outline into a Marp slide file and picks a fitting look along the way. Handy when you need a deck, not markup. 217installs discord-notifications Posts a Discord message when Claude stops working or a subagent finishes. Useful when you step away from the terminal and want a ping on completion. 217installs angular This skill guides Angular v20+ work with Signals, standalone components, zoneless setup, SSR, and reactive code. Use it for new apps or staged upgrades. 216installs bash-linux A Bash reference skill for macOS and Linux: command chaining, files, processes, error handling. Useful when the agent edits shell scripts or digs through logs. 215installs game-analytics-integration Plan game analytics for player activity, technical performance, and business metrics. Run the command when you need to map out an analytics system for a game project. 214installs implement-graphql-api A slash command that builds a GraphQL API: schema, resolvers, subscriptions and N+1 protection. Useful when you need a real backend, not a sketch. 212installs remove Removes a task from the orchestration system and updates every reference to it. Useful when a task is obsolete or duplicated. 209installs ascii-ui-mockup-generator This subagent sketches UI concepts as ASCII mockups, giving you several layout, form and dashboard options before any code is written. 207installs

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