# Claude in Excel and Google Sheets: Marketing Workflows

> How marketers use Claude inside Excel and Google Sheets: the add-ins, what each plan includes, formula and cleanup prompts, and checks for reports.

Source: https://mentionx.ai/learn/claude/claude-excel-google-sheets  
Author: Dipuck Jones, founder of MentionX  
Updated: 30 October 2026  
Level: Practitioner

**Claude now works inside your spreadsheets. Claude for Excel is an add-in for paid plans that answers questions with cell-level citations, fixes errors and builds models while keeping formulas intact. Claude for Google Workspace, in beta on paid plans, adds a sidebar to Sheets, Docs and Slides that writes formulas, builds pivot tables and charts, and cleans data in place.** For marketers, that means faster budget trackers, cleaner campaign data and reports built where your team already works.

> **Key takeaways**
>
> - Claude for Excel needs a paid plan; the Google Workspace add-on is in beta on paid plans.
> - Ask about inherited workbooks first; cell-level citations make audits fast.
> - Keep raw data tabs untouched and clean into a new tab with a change list.
> - Ask for native formulas and charts so reports keep updating without Claude.

*Checked 3 November 2026 (CET) against Anthropic help and docs pages. "Our view" marks MentionX opinion. Ledgerline is a fictional company used for illustration.*

## What are the two spreadsheet options?

There are two add-ins, one for each ecosystem.

**Claude for Excel.** Anthropic's documentation describes it as an add-in that lets you ask questions about open workbooks, adjust assumptions while preserving formula relationships, debug errors, and build or populate models without leaving Excel ([Claude docs](https://claude.com/docs/office-agents/excel)). It answers with cell-level citations, works across multi-tab workbooks and applies your enabled Skills automatically. It runs on Excel on the web, Windows (Microsoft 365) and Mac, and you install it from Microsoft AppSource as "Claude for Microsoft 365".

**Claude for Google Workspace.** Anthropic says it adds a Claude sidebar to Google Docs, Sheets and Slides, reads the file you have open and edits it directly, with every change visible in version history ([Anthropic](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides)). It's in beta on all paid plans. In Sheets, Anthropic's launch post says Claude can write formulas, build pivot tables and native charts, add tabs, and pull a range into Python for joins or cleaning before writing results back ([Anthropic](https://claude.com/resources/articles/claude-now-works-in-google-docs-sheets-and-slides)).

Neither add-in is on the Free plan. On Free, you can still upload a spreadsheet to a chat and ask Claude to analyse it or create a new Excel file, using code execution, as covered in lesson 10.

One known issue at the time of writing: Anthropic's Excel documentation warns that after the September and October 2026 Microsoft 365 updates on Windows, some users are missing chat history and uploaded Skills in the add-in, and Anthropic is working with Microsoft on a fix. Keep your important prompts somewhere else as well.

*Our view:* the add-ins change the habit more than the capability. Claude could already analyse a spreadsheet you uploaded; now it works on the live file, so the result is a sheet your team keeps using, not a one-off answer in a chat.

## What can you ask about an existing workbook?

Start with questions. Marketing spreadsheets are often inherited, with formulas nobody fully understands. Claude's cell-level citations make it a good guide.

```
Explain how this budget tracker works.
- What does each tab do?
- How is "Remaining budget" on the Summary tab calculated?
  Cite the cells.
- Are there any formulas that look wrong, inconsistent across
  rows, or hard-coded where they should reference a cell?
```

Ask Claude to point to the cells rather than describe them in general terms. Then click through to check. This is also a quick way to audit a template before using it for a new year or a new client.

## How do you write and fix formulas?

Describe the result you want in plain language, along with the sheet layout. Claude writes the formula, and in the add-ins it can place it in the right cells.

```
In the Campaigns tab, column F is spend and column H is
conversions. Add a column I "Cost per conversion" that shows
spend divided by conversions, shows a dash when conversions
are zero, and is formatted as currency. Fill it for all rows
with data.
```

For errors, select the cell and ask "Why does this show #REF! and how should I fix it?" Claude traces the cause, which is often a deleted column or a range that didn't extend when rows were added. Ask it to explain the fix before applying it, especially in shared files.

Useful formula tasks for marketers:

- Lookups between a campaign list and a cost export (XLOOKUP or INDEX/MATCH)
- Pacing formulas comparing spend to date with the monthly budget
- Week numbers and month labels from daily dates
- Extracting UTM values from URLs with text functions or REGEXEXTRACT in Sheets
- Conditional formatting rules that flag overspend or low conversion rates

## How do you clean messy campaign data?

Data cleaning is where the add-ins save the most time. Exports from different platforms rarely match: campaign names differ, dates use different formats, and currencies get mixed.

```
This sheet combines exports from Google Ads, Meta and LinkedIn.
Clean it into a new tab "Clean":
- One date format (YYYY-MM-DD)
- Platform column from the source tab name
- Campaign names lowercased, with our prefix rules [describe]
- Spend converted to EUR using the rates in the Rates tab
- Remove duplicate rows and blank rows
Don't change the original tabs. List every change you made.
```

The rule not to change the original tabs is important. Always keep raw data untouched, so you can check the clean version against it. Google's version history helps too, since the Workspace add-in records each change.

## How do you build a marketing report in a sheet?

Once the data is clean, ask for the summary you need. In Sheets, Claude can create pivot tables and native charts, which your team can then update without Claude.

```
Using the Clean tab, create a "Monthly summary" tab:
- Pivot by month and platform: spend, clicks, conversions,
  cost per conversion
- A line chart of conversions by platform by month
- A note at the top with the date range and data sources
Use native formulas and charts so the tab updates when we
add new data.
```

Asking for native formulas and charts rather than pasted values is the key to a report that keeps working. Check the totals against your platforms the first time.

## How do you use it for planning and budgets?

Spreadsheets are where marketing plans live, and Claude is useful for scenario thinking. In Excel, Anthropic highlights adjusting assumptions while keeping formula relationships intact, which is exactly what budget scenarios need.

```
In the Plan tab, budget is in C5:C16 by month and the expected
cost per lead is in D5:D16. Add three scenarios as new columns:
cost per lead 15% higher, flat, and 10% lower. Show leads per
month and total leads for each. Don't overwrite existing values.
Explain which assumptions drive the biggest difference.
```

Treat the output as a model, not a forecast. The numbers are only as good as your assumptions, and Claude has no way of knowing next quarter's auction prices.

## How do Google Workspace connectors differ from the add-on?

They work in opposite directions. Anthropic explains that the Google Workspace connectors let Claude search and reference your Drive, Gmail and Calendar while you chat in Claude, while the add-on brings Claude into the file you're already working in ([Anthropic](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides)). Anthropic also released Docs, Sheets and Slides connectors in beta that let Claude create and edit Google files directly from a Claude chat.

In practice: use the add-on when you're working in a specific sheet. Use the connectors when you want Claude to find information across your Drive, or to create a new sheet as part of a bigger task in chat.

## What should you check before sharing a spreadsheet?

Three things. First, check the totals against your source platforms. Second, click a few formulas to make sure they reference the right ranges, especially after Claude added rows or tabs. Third, check that the sheet doesn't contain anything that shouldn't be shared, such as hidden tabs with raw data or personal information. Claude can help: "List all tabs, including hidden ones, and anything in them that looks like personal or confidential data."

## From MentionX data: tracking AI visibility in a sheet

**Method.** Read-only aggregate queries over MentionX scans from 22 August to 29 October 2026 (UTC): 2,217 engine runs (2,154 completed) across 18 anonymised projects and six engines.

Many teams track AI visibility in a spreadsheet before they adopt a tool. MentionX's aggregates show how answers vary by prompt intent across the engines we track:

| Intent | Brand mentioned | Share of voice |
| --- | --- | --- |
| Brand-specific | 100% | 64.3 |
| Comparison | 91.9% | 44.6 |
| Recommendation | 29.2% | 26.8 |
| Best-of | 26.6% | 22.7 |
| Problem | 5.7% | 7.7 |

*Our view:* a simple sheet with prompt, engine, date, whether you're mentioned and which sources were cited is a perfectly good start. Claude in Sheets can then summarise trends each month.

**Limits.** A convenience sample of mostly B2B software projects, run through engine APIs, which can behave differently from the consumer apps. Perplexity, Copilot and DeepSeek figures come from a single day (26 October 2026), so treat them as a snapshot, not a trend.

## Worked example: Ledgerline's paid media tracker

*Ledgerline is a fictional accounts-payable tool. Figures are illustrative.*

Ledgerline's paid media manager combines Google Ads, Meta and LinkedIn exports in one Google Sheet. Using the Workspace add-on, she asks Claude to build a clean tab. The change list shows 41 duplicate rows from overlapping exports and three campaign names that didn't follow the naming rules.

She then asks for a monthly summary with native pivots and a pacing column comparing spend to budget. Claude flags that LinkedIn is pacing ahead of budget in the second week.

The tab updates automatically when she pastes next week's exports, and the head of marketing now reads it every Monday. Ledgerline is fictional and the details are illustrative.

> **Pro move:** Ask for a formula explanation column. When Claude adds complex formulas, ask for a note in a header comment explaining each one in plain English. The next person to inherit the sheet will thank you.

## What should you try before the next lesson?

If you're on a paid plan, install the add-in for the spreadsheet tool your team uses and ask Claude to explain your most complicated marketing sheet. If you're on Free, upload a copy of that sheet to a chat and ask the same question.

Next: [connectors and MCP for marketers](https://mentionx.ai/learn/claude/claude-mcp-connectors-marketers). Or return to the [Claude for Marketers track](https://mentionx.ai/learn/claude/claude-for-marketers).

## How do Skills help in spreadsheets?

Anthropic's Excel documentation says the add-in applies your enabled Skills automatically while you work. That's a good reason to turn your team's spreadsheet conventions into a Skill, as described in lesson 4. A "marketing data standards" Skill might cover your campaign naming rules, the currency you report in, how you define a qualified lead, which date format to use and how to label sources on charts.

With that Skill enabled, you don't have to repeat the rules in every request, and different people get consistent results. When a rule changes, update the Skill once rather than reminding everyone. Keep a copy of your Skills outside the add-in too, given the known issue with missing Skills after recent Windows updates.

## How do you work safely in shared spreadsheets?

Shared marketing sheets often feed other people's reports, so a well-meant change can break something downstream. A few habits reduce the risk:

- **Work on a copy first** for big changes, then apply the agreed version to the shared file.
- **Ask Claude to list dependencies** before changing a tab: "Which other tabs or formulas reference this range?"
- **Prefer new columns and tabs** over editing existing ones, and tell colleagues what you've added.
- **Use version history.** In Google Sheets, the add-in's edits show up there, so you can restore an earlier version if something goes wrong.

These are ordinary spreadsheet habits, but they matter more when changes can happen quickly. Claude can make twenty edits in the time it takes you to make one, which is great until one of them is wrong.

## What about very large datasets?

Spreadsheets slow down with very large data, whatever tool you use. If an export has hundreds of thousands of rows, such as raw keyword or event data, it's often better to upload it to a chat and let Claude analyse it with code, then bring only the summary into your spreadsheet. If your data already sits in a warehouse, the Dashboards beta on paid plans, mentioned in lesson 10, may be a better fit than a spreadsheet altogether. Match the tool to the size of the job, and keep spreadsheets for the summaries, plans and trackers that people need to read and edit.

## Which marketing sheets are worth upgrading first?

Start with the sheet your team opens most and trusts least. For many teams, that's the budget pacing tracker, the campaign naming log or the monthly report that someone rebuilds by hand. Ask Claude to explain it, fix its weakest formulas and add a short notes tab describing how it works. One reliable, well-documented sheet does more for a team than a dozen clever new ones, and it's a low-risk way to learn how the add-ins behave on real work.

## What should you know about chat history in the Excel add-in?

Anthropic's Excel documentation says chat history in the add-in is stored locally in your browser storage, isn't synced across devices and can be cleared from settings. Clearing it removes only the local copy, not the messages Anthropic keeps ([Claude docs](https://claude.com/docs/office-agents/excel)). So if you move between a work laptop and a desktop, don't expect your add-in conversations to follow you. Keep important prompts and instructions in a document or a skill rather than relying on history.

The same page currently carries a warning that after the September and October 2026 Microsoft 365 updates on Windows, some users are missing chat history and uploaded skills in the add-in, and that Anthropic is working with Microsoft on it. Anthropic links to steps for users and IT teams in its data storage documentation. If your team relies on skills in Excel, keep a copy of each skill's files somewhere you control.

## What goes wrong in spreadsheet work?

| Problem | Fix |
| --- | --- |
| Formula works on sample rows, fails on full data | Ask Claude to test against blanks, text in number columns and dates in different formats |
| Totals don't match the platform | Check for duplicated rows and filtered-out data before blaming the formula |
| Claude changed cells you didn't expect | Work on a copy first and ask Claude to list every range it will change before it changes them |
| Dates read as text | Ask Claude to detect and convert date formats explicitly, showing examples of before and after |
| Shared sheet broken for colleagues | Avoid changing column order or named ranges other people's formulas rely on |

## Common questions

**Is Claude for Excel free?** No. Claude for Excel needs a paid plan; Anthropic's Excel documentation lists Pro, Max, Team and Enterprise, and its pricing page also includes Claude for Microsoft 365 on Ultra. Free users can upload spreadsheets to a chat instead.

**Can Claude edit Google Sheets directly?** Yes, with Claude for Google Workspace, which is in beta on paid plans. It adds a sidebar and edits the open file, with changes in version history.

**Will Claude break my formulas?** Anthropic says the Excel add-in adjusts assumptions while keeping formula relationships intact. Still, check key formulas and keep raw data tabs untouched.

## Sources

- Claude docs, [Use Claude for Excel](https://claude.com/docs/office-agents/excel)
- Anthropic Help Center, [Use Claude in Google Docs, Sheets and Slides](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides)
- Anthropic, [Claude now works with Google Docs, Sheets, and Slides](https://claude.com/resources/articles/claude-now-works-in-google-docs-sheets-and-slides)
- Anthropic Help Center, [Use Google Workspace connectors](https://support.claude.com/en/articles/10166901-use-google-workspace-connectors)
- Anthropic Help Center, [Create and edit files with Claude](https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude)
All accessed 3 Nov 2026.

## Frequently asked questions

### Is Claude for Excel free?

No. Claude for Excel needs a paid plan; Anthropic's Excel documentation lists Pro, Max, Team and Enterprise, and its pricing page also includes Claude for Microsoft 365 on Ultra. Free users can upload spreadsheets to a chat instead.

### Can Claude edit Google Sheets directly?

Yes, with Claude for Google Workspace, which is in beta on paid plans. It adds a sidebar and edits the open file, with changes in version history.

### Will Claude break my formulas?

Anthropic says the Excel add-in adjusts assumptions while keeping formula relationships intact. Still, check key formulas and keep raw data tabs untouched.

---

Written and reviewed by Dipuck Jones for MentionX Learn. The HTML version of this page: https://mentionx.ai/learn/claude/claude-excel-google-sheets