Claude Excel Skills: Which Ones to Install for Strategy Work

Which Claude Excel skills should you install first?

It depends on whether your bottleneck is the workbook or the thinking that goes into it. Most people searching for Claude Excel skills have the second problem and buy tools for the first.

If the job is reading, fixing or extending a workbook that already exists, start with the official Claude for Excel add-in and install nothing: Anthropic's documentation lists it as generally available on Pro, Max, Team and Enterprise plans, and it reads the open workbook directly with cell-level citations. If the job is building a named financial model from scratch, use a model-builder skill, the DCF, LBO, comps or returns-waterfall kind, which writes a real .xlsx file with live formulas. If the job is deciding what to analyse before any of that, use framing and governance skills: a MECE issue tree, an inputs-calcs-outputs design, an assumption registry. The 21 skills on this page are the third kind.

How we chose what goes in this pack

These are not the twenty-one most impressive things Claude can do with a spreadsheet. They are the ones that survived four filters, plus a fifth that removed more candidates than the other four put together.

• A written procedure had to beat an unwritten one. If Claude already does the job well from a one-line prompt, a skill file adds ceremony and nothing else. Formula explanation and error tracing were cut on exactly this test.
• Each one was tested against the add-in, not an empty chat. A skill that only wins when Claude for Excel is unavailable is a workaround rather than a skill. Where the built-in behaviour is already enough, the blocks below say so.
• The output had to be auditable. Every skill ends in something a reviewer can check line by line: a tab inventory, a formula spec, a scored grid, an assumption register. Narrative summaries of a model were cut.
• Macros and VBA were ruled out from the start. Anthropic lists macros and VBA operations, along with data tables, as unsupported in Claude for Excel, so nothing in the pack depends on them.
• What we ignored on purpose. Round numbers, model benchmark scores, prompt-library length and anything that duplicated the model-building pack. Four candidates were cut for overlap.

Key takeaways before you install anything

• Decide what you want out of the other end. A finished workbook, a written spec you build yourself, and an answer typed into the sheet you already have are three different products. Nearly every complaint about Claude Excel skills is a mismatch here.
• Check where the work actually happens. The add-in works inside the open workbook, chat skills work on files you upload and download, and Claude Code works on files on disk. Only the first sees your live formula relationships while you edit them.
• Check the gate before you plan around it. Claude for Excel is generally available on Pro, Max, Team and Enterprise, and Anthropic lists Excel 2016 and 2019 perpetual licences, iPad and Android as unsupported. Skills used in chat carry none of those platform limits.
• Prefer the route that leaves a trail. A skill that hands you a tab inventory and an assumption register can be reviewed by someone who was not in the room. A workbook that simply appeared in one turn usually cannot.
• Skip the skill where the built-in behaviour already covers it. Debugging a formula, tracing how a number was derived, and flexing an assumption while keeping dependents intact are documented add-in features. Installing a skill for those is the same work twice.

Claude Excel skills compared, route by route

Seven routes, one row each, against the five rules above. Oria is in the table because the model output almost always ends up in a pack, not because it belongs in a spreadsheet. Read the last column first. It is the one that tells you when a route is the wrong one, and on this topic picking the wrong route costs far more than picking the wrong tool inside it.

None of these routes is accurate enough to leave unsupervised, which is the part that vendor pages skip. Vals AI runs a Finance Agent benchmark of 537 questions written with Stanford researchers, a global systemically important bank and industry experts, scoring models on the work an entry-level financial analyst does. On its public leaderboard in September 2026 the leading model, Claude Opus 4.7, answers 64.37% of them correctly, with Claude Sonnet 4.6 just behind on 63.33%. That is a strong score, and it is also more than a third of the questions wrong. Anthropic's own documentation arrives at the same place from the other direction: it says Claude for Excel is not recommended for final client deliverables without human review or for audit-critical calculations without verification.

Claude Spreadsheet Skills in Chat: Who Are They For?

The second route needs no add-in and no Excel window at all. Anthropic's file-creation feature, announced in September 2025 and made generally available for paid plans on 21 October 2025, states that Claude can create and edit Excel spreadsheets, documents, PowerPoint slide decks and PDFs directly in Claude.ai and the desktop app. You upload the data, describe what you need, and download the file.

This is the route for everyone the add-in does not reach, and that list is longer than it looks: an Excel 2016 or 2019 perpetual licence, a locked-down environment where the Office Store is switched off, an iPad, an Android phone, or an organisation whose admin has simply not deployed the add-in yet. It is also the right route when you want a file produced rather than an open workbook edited, which is what most people actually mean when they ask for a Claude Excel skill that builds something.

Skills behave identically here. The same SKILL.md folder you enable in settings is the one the add-in picks up, so there is no separate chat version to maintain and no risk of two copies of a procedure drifting apart. That portability is the strongest practical argument for writing a procedure as a skill rather than keeping it in a prompt library.

The trade-off: Claude cannot see a workbook it has not been handed. Working this way means passing files back and forth, and the live formula graph in the file open on your screen is invisible until you upload that file. For interrogating a model somebody else built, the add-in wins by a distance.

The 21 Excel-Inspired Strategy Skills: Who Are They For?

This pack is for the work that happens before a formula exists and after the model is finished: framing the problem, designing the data structure, choosing the analysis, stress-testing it, and reporting it to people who will never open the workbook. The seven domains further down run in that order.

The phrase Excel-inspired is doing specific work. These skills take the disciplines that make a spreadsheet auditable, separating inputs from calculations, one formula per row, every assumption explicit and registered, tie-out checks built in, and apply them to strategy analysis, where those disciplines are usually absent. A market sizing built to that standard can be argued with, line by line. One written as prose can only be believed or not.

That matters more than it sounds. Raymond R. Panko of the Shidler College of Business at the University of Hawai'i reviewed 85 operational spreadsheets that had been through intensive inspection, most of it by commercial auditing firms, and reported in his 2015 paper for the European Spreadsheet Risks Interest Group that collectively those studies found errors in 94% of the spreadsheets studied. His explanation for why that keeps happening is blunter than the number itself: spreadsheet developers and corporations, he writes, are "highly overconfident in the accuracy of their spreadsheets". A model produced in a single conversational turn inherits that overconfidence and adds a new one on top.

The trade-off: these skills produce specs, structures and registers, not finished workbooks. The DCF Structure Builder hands you the free cash flow build, the equity bridge, the WACC formula and the two-variable sensitivity table to construct; it does not hand you the .xlsx. If the file is what you wanted, the next block is where to go.

The 25 Excel Model Builders: Who Are They For?

If the model does not exist yet and you already know which model you need, this is the wrong pack and its sibling is the right one. The 25 Claude skills for Excel modelling cover DCF, trading comps, precedent transactions, sum of the parts and the football field on the valuation side; three-statement, LBO, debt schedule, accretion and dilution and sources and uses on the deal side; the private equity returns waterfall, value creation bridge, fund model and the IRR and MOIC calculator on the returns side; and market sizing, revenue build, unit economics and pricing on the strategy side, with sensitivity tables, a scenario manager and Monte Carlo to pressure-test them.

The difference between the two packs is the artefact. Those skills write a real workbook with live formulas rather than hardcoded numbers, recalculate it, and check for formula errors before handing the file over. This pack writes the thinking that decides whether the model is the right one and whether anybody will be able to audit it in three months.

In practice the two run in sequence rather than as alternatives. Frame the question with an issue tree, design the tab structure, then build. Teams that skip the first half produce immaculate models of the wrong question, which is almost impossible to spot from the outside.

The trade-off: a model builder assumes you already know which model answers the question. That assumption is safe on a valuation and unsafe on most of what gets called strategy work, where choosing the analysis is the analysis.

Copilot in Excel: Who Is It For?

If your organisation has blocked the Office Store, routes everything through Microsoft licensing, or simply already pays for Copilot, the honest recommendation is to start there rather than fight procurement for a second sidebar. A tool that is approved and installed beats a better tool that is neither.

Microsoft's documentation describes Copilot in Excel as building and editing workbooks using Excel's own tools: adding, renaming and deleting worksheets, inserting and modifying cell values and ranges, generating data from prompts, performing calculations and applying formulas, creating charts and PivotTables with editable links to source data, and applying sorting, filtering and conditional formatting. It also retrieves data from other workbooks saved to OneDrive or SharePoint.

It has one advantage the Claude add-in does not, and it is decisive for some readers. Microsoft lists Copilot in Excel as available on Windows, Mac, the web, iPad, iPhone and Android, with full edit mode on Windows, Mac and the web and chat on mobile. Claude for Excel does not run on iPad or Android at all. If the person who reviews the model does it on a tablet on a train, that settles the question before any capability comparison begins.

The trade-off: Copilot works on the workbook rather than on the method. There is no portable equivalent of a SKILL.md folder you write once and hand to a colleague, so the procedure tends to live in whatever the last person happened to type. If what you want is a repeatable house standard for how a model gets built, that is the gap.

Claude Code and the API: Who Is It For?

The fourth Claude route is about repetition rather than analysis. If the same transformation runs across forty workbooks every month, the right artefact is a script a reviewer can read, not a chat transcript nobody can. The skill file works here unchanged, because a SKILL.md folder is plain text: the same procedure that governs a sidebar conversation can govern a batch job.

The failure mode this route prevents is silent, and there is a well-documented instance of it. In October 2020 Public Health England reported that 15,841 positive coronavirus test results between 25 September and 2 October had been left out of the daily case figures, because the lab results were being collated in the old .xls format, which stops at 65,536 rows. As The Register reported at the time, nothing raised an error: rows past the ceiling were simply dropped. A scripted pipeline with a row-count assertion would have caught it on the first run. A person eyeballing a workbook did not catch it for a week.

That is the argument for writing the procedure down rather than repeating it. Panko's own prescription points the same way: his paper argues that the biggest need, on the empirical evidence, is massively more testing than anyone currently does. A checked-in script is inspectable. A conversation is not.

The trade-off: this is engineering, not analysis. It pays back on work that recurs on a schedule and costs more than it saves on anything you will do once, which is most strategy work by definition.

If you need X, go to Y

A good share of the people who search for Claude Excel skills want something this pack does not provide. Here is where each of those needs is actually served, including the rows that lead somewhere other than us. Pointing you at the tool that fits is cheaper for everyone than watching you install 21 files and conclude that Claude Excel skills do not work.

The 21 Excel-inspired skills you get

The collection is grouped into seven analytical domains. They run in the order a real engagement does, frame the problem first and govern the model last, but every skill is also useful on its own, and each one is a standalone SKILL.md file you upload through Claude's Skills settings. Read the Use when column first: it is the fastest way to work out which three you actually want.

Categories 1 to 3 frame the problem, design the data structure, and build the core model. Categories 4 to 6 run the analysis, test the scenarios, and produce the executive output. Category 7 governs the model infrastructure.

How to choose a Claude Excel skill

Skip the directory hunt. Each of these Claude Excel skills maps to one specific analytical need, so pick the row that matches what you are trying to do and use that skill. If your need is not on this list, it probably belongs to one of the other routes above, and the routing table will be quicker than scanning here. For a wider walkthrough of working this way, see our consultant's guide to Claude.

Setup Guide

1. Step 1

   Download the pack and open Settings

   Download all 21 skills (.zip)

   Download the pack and unzip it so each skill remains in its own folder with its SKILL.md file. In Claude, open your profile menu and select Settings.

   

2. Step 2

   Open Skills and start an upload

   In Settings, select Skills under Customize. Open Add and choose Upload a skill.

   

3. Step 3

   Upload one skill file

   Open one extracted skill folder and drag its SKILL.md file into the upload window, or click the upload area to choose it. Repeat for each skill you want to add.

   

4. Step 4

   Confirm the skill was added

   Return to the Skills list and check that the skill appears. Select its name to open it.

   

5. Step 5

   Review and turn on the skill

   Review the skill's name, description, and instructions, then make sure the switch beside Share is on. A blue switch means the skill is turned on; sharing it is optional.

   

The quality bar

Every skill is designed to push Claude toward outputs that meet the same partner-grade quality bar, the standard a senior associate would hold each deliverable to before it leaves the room.

Frequently asked questions