# Can Claude Make a Spreadsheet? Three Ways, Tested

Yes, three ways: Claude Sheets, or Claude inside Google Sheets or Excel. What a test tracker got right, where each stops, and which one a small firm needs.

By Gabe Pérez. Published 2026-11-12.
Original: https://gabezen.com/blog/can-claude-make-a-spreadsheet/

Yes, and since November 10 there are three ways to do it. [Claude Sheets](https://support.claude.com/en/articles/18324300-get-started-with-claude-sheets) builds a spreadsheet inside Claude. [Claude for Google Workspace](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides) puts Claude in a sidebar in Google Sheets, and [Claude for Excel](https://support.claude.com/en/articles/12650343-use-claude-for-excel) does the same in Excel. If your firm's trackers already live in Google Sheets or Excel, bring Claude to them and leave them where they are. Claude Sheets is for a new, light sheet you build with Claude, and Anthropic's own help page draws the line in the same place.

On launch day someone on Reddit asked the obvious question: Claude already works with Google Sheets, so why would anyone move to Claude Sheets? I didn't see an answer in the thread. This is my answer, from a test sheet I had Claude build and Anthropic's docs as of November 12, 2026.

## What happened when I asked for a tracker

In a new chat, I asked Claude for a client-matter tracker for a 10-person law firm: matter, client, owner, a status drop-down, hours, rate, amount billed, unbilled amount and due date. I asked for formulas wherever a value could be worked out from other cells, 15 rows of made-up data, and a second tab totaling hours and unbilled work by owner.

About 90 seconds later the sheet was open next to the chat, private to me. Status was a color-coded drop-down, and Claude had extended it over 10 blank rows below the data so new matters would get it too, which I hadn't asked for.

The numbers were formulas, not values Claude worked out and typed in. Unbilled amount is `=E2*F2-G2`, hours times rate minus what's been billed, and the owner tab adds them up with `SUMIFS`. I checked a few by hand. A matter with 30 hours at $450 and $8,100 billed leaves $5,400, and one owner's three matters came to 63.5 hours and $9,225, which is what the owner tab showed.

That matters more than the speed. The fair worry about an AI spreadsheet is a total nobody can trace. Anthropic's help page says ["Formulas stay in the cells, so you can see and check how each number was calculated,"](https://support.claude.com/en/articles/18324300-get-started-with-claude-sheets) and in my test that held.

Then came the catch, and Claude raised it before I found it. The owner names on the totals tab are typed in. Hire an associate, add their matters to the tracker, and they're missing from the totals until someone adds their name on that tab and copies the formulas down. A sheet like this is right on the day it's built and quietly wrong a month later. When you ask for a summary tab, ask Claude what happens when someone new joins.

Editing was the part I liked most. I asked for two changes in one message: new hours on one matter, and a Days until due column worked out with a formula. One reply made both, with a notice that Claude had updated 17 cells and an Undo button next to it. Claude also made a call I hadn't asked for. It left Days until due blank for closed matters, since a countdown on finished work is noise, and it told me so. I'd want the same from a person.

## Where Claude Sheets stops

It's a beta, and [the help page](https://support.claude.com/en/articles/18324300-get-started-with-claude-sheets) is plain about the limits:

- **Size.** A sheet holds up to 100,000 cells. That's plenty for a matter list and tight for a raw export from your practice software.
- **Missing features.** No pivot tables, find and replace, multi-column sort, protected ranges or PDF export yet, and no macros, VBA or Power Query at all.
- **No live data.** A sheet can't pull from your connected apps, so it won't keep itself in step with your billing system.
- **Phones.** Basic read-only access on mobile.
- **Regulated data.** HIPAA, CMEK and ZDR aren't supported yet. If you handle patient records, keep them out.
- **Usage.** Building and editing sheets counts toward your plan's usage limits like any other chat.

On Team plans Sheets is on by default. On Enterprise an Owner has to turn it on. When you need more than this, [you can export to .xlsx or CSV](https://support.claude.com/en/articles/18324300-get-started-with-claude-sheets) and carry on in Excel or Google Sheets.

## Claude inside Google Sheets

Claude for Google Workspace is a sidebar in Google Docs, Sheets and Slides, in beta on paid Claude plans. It reads the file you have open and edits it in place. Anthropic is specific about its reach: ["Apart from content from any connectors you turn on, it cannot see other files in your Drive, your email, or your calendar."](https://support.claude.com/en/articles/16951679-use-claude-in-google-docs-sheets-and-slides) By default it shows you each edit and waits for you to allow it. Google records its changes under your name in version history, so you can roll them back like your own. It can't share the file or give anyone access, and it always asks before it removes someone's.

Two things trip people up. Your Google account has to be allowed to install Marketplace apps, and many companies block that until an admin allows Claude. And it works only on real Google Sheets files, so an Excel file you opened in Google Sheets has to be saved as a Google Sheet first. This is a different thing from the Google Drive connector, which lets Claude find files while you chat at claude.ai. If that's what you're after, [opening a Drive link in Claude](https://gabezen.com/blog/can-claude-open-google-drive-links/) covers it.

## Claude inside Excel

Claude for Excel is an add-in, out of beta, for Pro, Max, Team and Enterprise plans. It runs in Excel on the web, in Excel for Windows with a Microsoft 365 subscription, and in recent versions of Excel for Mac. It [doesn't run on Excel 2016 or 2019](https://support.claude.com/en/articles/12650343-use-claude-for-excel) bought outright. When you change an assumption, it keeps the formulas connected so the cells that depend on it recalculate.

I didn't test this one, because there's no Excel on the machine I tested on. Two warnings from Anthropic's own page are worth reading anyway. It's not recommended for "Final client deliverables without human review" or "Audit-critical calculations without verification." And it says to use it only with trusted spreadsheets, because a file from outside can carry hidden instructions that steer Claude into extracting or changing data. If your firm receives spreadsheets from clients, that second warning matters more than it looks.

## Which one a small firm should use

| Your situation | Use |
|---|---|
| The tracker already lives in Google Sheets | Claude for Google Workspace |
| It lives in Excel | Claude for Excel |
| You're starting a new, simple tracker with Claude | Claude Sheets |
| It needs pivot tables, macros or live data | Excel or Google Sheets, not Claude Sheets yet |
| It holds patient records | Not Claude Sheets yet |

For most small teams that means bringing Claude to the spreadsheet they already use. The sheet your team already has open, shares and trusts is worth more than a nicer one nobody looks at. Claude Sheets earns its place for something new and small: a hiring budget, a one-off client list, a tracker for a single project. Build it in Claude, and export it the day it outgrows the beta.

Before client numbers go into any of the three, read [whether Anthropic trains on your data](https://gabezen.com/blog/does-claude-team-train-on-your-data/) and [what to check before putting client data into Claude](https://gabezen.com/blog/can-i-put-client-data-into-claude/).

If you'd rather have the tracker running than learn the tools, send me your last proposal, customer reply or weekly update through [Hand Off One Job](https://gabezen.com/hand-off-one-job/), and within 48 hours I'll send back a free setup that writes the next one.

Sources for the facts on this page, checked November 12, 2026: [Get started with Claude Sheets](https://support.claude.com/en/articles/18324300-get-started-with-claude-sheets).

---

More posts: https://gabezen.com/blog/
The whole site in one file: https://gabezen.com/llms.txt