🧠 How to Use Claude With Excel

Here's how you've been using AI for spreadsheets wrong:

1. You have a messy data export. 400 rows. Dates in 3 different formats.

2. You copy it. You paste it into ChatGPT.

3. ChatGPT tells you to use a formula. You don't know the formula.

4. You ask it to write the formula. It writes one that breaks.

5. You spend 45 minutes debugging something that should've taken 5.

6. You give up. You do it manually. Again.

7. "AI can't actually do spreadsheets."

That was true. Until now.

Claude in Excel isn't a chatbot you talk to about spreadsheets.

It lives inside your spreadsheet. It reads your actual data. It touches your actual cells. It sees your formulas, your structure, your errors — and fixes them in real time.

Microsoft built Copilot for Excel and spent years getting it wrong. Anthropic built Claude for Excel and got it right on the first try. The difference is obvious the second you try it.

This guide will show you exactly how, whether you've never written a formula in your life, or you've been living in Excel for 10 years.

Claude in Excel is an add-in. It sits in a sidebar inside Microsoft Excel.

It's not a file upload tool. It's not a screenshot analyzer. It has direct access to your spreadsheet — every cell, every formula, every tab.

That's the thing that makes it different. And it's the thing most people don't understand yet.

How to install it:

1. Open Microsoft Excel (desktop app, not web).

2. Go to the Microsoft AppSource listing for Claude.

3. Click "Get it now" → install the Claude add-in.

4. In Excel: go to Home → Add-ins (Windows) or Tools → Add-ins (Mac).

5. Sign in with your Claude account.

Note: you need Claude Pro ($20/month or $17/month annual) to use it. The add-in itself installs free — but it won't run without a paid plan. It's worth it.

Shortcut to open the sidebar: Ctrl + Alt + C (Windows) or Cmd + Option + C (Mac).

Here's what you can do with it.

1. Clean messy data without touching a single cell yourself.
You got a data export. It always looks the same:

• Dates in four different formats.

• Names with random capitalization.

• Phone numbers with and without country codes.

• Blank rows are scattered throughout.

This is what makes people hate spreadsheets. It takes forever, and it's completely mindless.

Ask Claude:

"Clean this dataset. Standardize all dates to DD/MM/YYYY. Fix inconsistent capitalization in the Name column. Remove all blank rows. Flag any duplicates in column B."

Claude highlights every cell that changes. You see exactly what it did. Nothing happens without you seeing it.

2. Analyze your data without writing a single formula.

This is the one that will genuinely shock you.

You have data. You need insights. Normally, that means building pivot tables, writing SUMIFS, and calculating averages across filtered ranges. It's slow. Most people just eyeball it instead.

Now you just ask:

"What are the top 5 performing categories by revenue in 2025? Compare them to 2024 and tell me what's changed."


"Identify any anomalies in this dataset. What stands out?"


"Which rows have the highest engagement rate? Is there a pattern?"

Real example: I used this on my own Instagram analytics data. I had a spreadsheet of 90 days of post performance — reach, likes, saves, shares, profile visits — data I'd originally scraped and extracted using Claude. Instead of building pivot tables, I just asked Claude to tell me which content format was driving the most profile visits, and whether posting time had any correlation with reach.

It came back with a breakdown in 30 seconds. The kind of analysis that would've taken me an hour.

3. Read, explain, and fix formulas you've never seen before.

Someone sends you a spreadsheet. 6 tabs. 80 formulas. One of them is broken and you have no idea why.

Before: you'd spend 30 minutes reverse-engineering it.

Now you click on the cell and ask:

"Explain what this formula does in plain English."

"Why is this cell showing #REF? Trace the issue."

"This SUMIF isn't returning the right number. What's wrong with it?"

"Find every error in this workbook and explain what's causing each one."

This alone is worth the price of Claude Pro for anyone who works with inherited spreadsheets.

4. Build a financial model from a blank sheet.

You don't need to know how to structure a financial model. You don't need to know which formulas to use. You just need to know what you want.

Ask Claude:

"Build a 12-month revenue forecast. I'll give you my historical monthly revenue for the last 2 years. Apply a growth trend and create a best case, base case, and downside scenario."


"Create a SaaS metrics model. I need ARR, MRR, churn rate, and LTV calculations. Add a revenue bridge showing new vs expansion vs churned revenue."


"Build a unit economics model for a DTC brand. Include CAC, LTV, payback period, and gross margin. Make it easy to update the assumptions."

Claude builds the structure, writes the formulas, labels everything clearly, and color-codes assumptions vs outputs. What used to take a finance team half a day now takes 10 minutes and one conversation.

5. Turn a PDF into a real, editable Excel file.

Someone sends you a report as a PDF. The data you need is locked inside a table on page 4. Normally, you'd retype it manually or pay for a converter that never formats it correctly.

Now you can simply upload the PDF directly to Claude in the Excel sidebar.

"Extract the financial table from page 4 of this PDF into my spreadsheet. Match the column structure I already have."


"Pull the line items from this invoice into my template. Fill in the quantity, unit price, and total columns."


"Convert the data in this market research report into a structured table I can analyze."

Claude reads the PDF and pulls the data directly into your cells. Formatted. Editable. Immediate.

Everything above is Claude in Excel—the add-in in Microsoft Excel.

But if you have spreadsheets you update regularly — weekly reports, monthly dashboards, recurring analysis — there's a more powerful setup worth knowing about.

It's called Claude Cowork. It's a desktop app (separate from Excel) that works with files on your computer, including Excel files.

The difference: instead of working inside one spreadsheet reactively, Cowork works autonomously on tasks. You point it at a folder, give it a task, and it executes — reading files, creating new ones, updating existing ones — while you work on something else.

How it helps with Excel specifically:

You create a folder on your computer. Drop in your recurring spreadsheets, your templates, and any reference files. Then you give Cowork a standing task:

"Every Monday, open last week's sales report in this folder, extract the key metrics, and create a summary spreadsheet with trends vs the previous 4 weeks. Save it to the OUTPUTS folder."


"When I drop a new CSV export into this folder, clean it, remove duplicates, standardize the date format, and create an analysis tab with the top 10 insights. Ask me questions first if anything is unclear."

This is the difference between using AI reactively (you ask, it answers) and using it proactively (it runs the workflow while you do something else).

Quick setup for Cowork:

1. Download the Claude desktop app from claude.com/download.

2. Open it. Click the Cowork tab at the top.

3. Click "Add Folder" and select a dedicated folder for your Excel work.

4. Select Opus 4.6 + Extended Thinking for the most capable output.

5. Start your first task.

The first time you walk away and come back to a finished, formatted Excel file — with analysis already done — is the moment this clicks.

Here's what Claude in Excel doesn't support right now:

• No VBA or macros. If your workflow depends on Excel macros, Claude can't build or run them. It works with formulas and data — not automation code inside Excel.

• No Power Query or Power Pivot. If you're connecting to external data sources or building complex data models inside Excel's native tools, Claude isn't in that layer yet.

• Large datasets slow it down. If your spreadsheet has 50,000+ rows, Claude will work through it, but it takes longer and can hit context limits. For very large datasets, chunk your data first and work section by section.

• It's not a replacement for review. Anthropic is explicit about this: don't use it for audit-critical calculations or final client deliverables without verifying the output yourself. It's very good. It's not infallible.

These are real limitations. They'll shrink over time. But you should know them now.

Skip the guide, and do this:

1. Install Claude inside Excel from the Microsoft AppSource listing. Two minutes. Free to try.

2. Open any spreadsheet you already use. Ask Claude to clean it, explain a formula, or pull insights from your data.

3. If you have recurring spreadsheets — weekly reports, monthly dashboards — set up Claude Cowork. Point it at a folder. Let it run the work while you do something else.

4. Remember what it can't do yet: no VBA, no macros, no Power Query. Review anything before it goes to a client.

5. The professionals building this into their workflow now will look untouchable to everyone who waits.

You've done the reading. The only thing left is to open Excel.

Until next time,
Kushank @PracticalyAI