I've been meaning to write about this for a while.

Claude for Excel has been around for a bit, but Anthropic just moved it to general availability as part of a bigger finance push with 10 new agent templates, and connectors to data sources like factset and moody's.

The Excel add-in is what most of us will end up using day-to-day. so let's go through it properly.

But before that, some catchup on AI this week:

1. Minimax Hub A desktop workspace where four AI agents run simultaneously on a single creative brief. Instead of jumping between tools, you get a full production pipeline from one place.

2. Lightfield A CRM that logs itself across every call, meeting, and email gets captured and structured automatically without anyone touching a data entry field. You can also query your entire pipeline in plain English and get instant answers.

3. AgentChat A real-time messaging platform built for AI agents to communicate with each other by direct messages, group chats, and a contacts directory, all between agents. Early-stage but worth watching as multi-agent workflows become more common.

How to install it (2 minutes)

Open Excel, go to the home tab. far right > click the add-ins icon.

Search for "claude." it'll show up as the top result. click add.

Once installed, log in with your Anthropic account with a paid plan.

Then, open the sidebar with ctrl+alt+c, or click the claude icon in the ribbon. you'll get a pane on the right side of your sheet where you type prompts.

Use case 1: cleaning messy data

i took a sample sales dataset with the usual problems like inconsistent date formats, missing customer name, a duplicate row, etc.

Prompt: "Clean up this dataset, standardize the date formats, remove duplicates, and fix any obvious issues."

Before deleting the duplicate row, it asked for permission, which is fair as you’d need oversight on anything destructive / data removal.

It fixed the inconsistent date format, removed duplicates and fixed casing issues.

it also converted hardcoded totals into formulas by itself. So now if i change a quantity, the total updates automatically.

Lastly, it flagged and kept the bits that needed human oversight untouched.

Use case 2: catching formula errors

To test this, I deliberately broke a formula.

Prompt: “Validate the formulas in this sheet, identify any issues, and fix them."

And it worked.

Formula errors are easy to miss but having Claude run a pass before you send a sheet anywhere is useful.

Use case 3: building a summary + charts

I made sure to do this after the data was clean.

Prompt: "Create a summary of total sales by product and region, and add a chart to visualize the results."

It built summary tables with formulas referencing the source data, and associated charts. changes upstream flow through automatically.

Use case 4: actual analysis

Prompt: “Analyze this data and highlight the key trends, top-performing products, and any notable patterns."

It returned a written summary, which products sold most, least, regional breakdown, and built a structured metrics table on a separate summary sheet.

It’s nothing I couldn't do myself but the time it would've taken me or you vs. Claude, is the point.

A few other things worth knowing

You can set custom instructions like "always use thousand separators", etc, so you don't repeat yourself every session.

Find it under the three-dot menu → settings.

There's also a connectors feature for pulling in external data from sources like factset or moody's (enterprise-level, but worth knowing).

And a skills menu. Type / in the prompt field, with pre-built workflows for common tasks like data cleaning.

Excel always had a gatekeeping problem.

Nothing was wrong with the tool itself but the 2-hour YouTube rabbit hole you had to go down before doing anything useful, was dreadful.

That's gone now.

The way Anthropic has approached building this also allows the same context to live across any of excel, powerpoint, etc.

You don’t need to switch tools anymore.

And I think most people will underuse this. They'll clean a dataset, get impressed, and relapse to their old workflow.

Don’t make that mistake. Lean into Claude. It’s powerful, Anthropic is clearly dedicated in this direction, make the most of it.

Reply and tell me that one Excel task you always dreaded, that you were able to solve because of this.

Until next time,
Vaibhav 🤝🏻

If you read till here, you might find this interesting

#AD 1

The DTC beauty category is crowded. To break through, Jennifer Aniston’s brand LolaVie, worked with Roku Ads Manager to easily set up, test, and optimize CTV ad creatives. The campaign helped drive a big lift in sales and customer growth, helping LolaVie break through in the crowded beauty category.

Learn more

#AD 2

When you type a prompt, you summarize. When you speak one, you explain. Wispr Flow captures your full reasoning — constraints, edge cases, examples, tone — and turns it into clean, structured text you paste into ChatGPT, Claude, or any AI tool. The difference shows up immediately. More context in, fewer follow-ups out.

89% of messages sent with zero edits. Used by teams at OpenAI, Vercel, and Clay. Try Wispr Flow free — works on Mac, Windows, and iPhone.

Start flowing free