Claude for Google Sheets
Claude as a spreadsheet formula.
The work that eats an afternoon — cleaning names, tagging rows, summarizing a column of comments — is one formula dragged down the page. Here's the full setup, written for people who don't write code.
The add-on is free. The Claude usage behind it is billed per use through the Anthropic API — usually cents for a few hundred cells.
What it actually is
Stop copy-pasting rows into a chat window.
Most people use Claude by pasting a chunk of a spreadsheet into a chat, reading the answer, and pasting it back. That works for ten rows. It falls apart at a thousand. Claude for Sheets skips the middle step: the instruction lives in the cell, and the answer lands in the cell.
It's a formula
=CLAUDE("instruction", A2) behaves like any other function you already use.
It fills down
Drag the corner and the same instruction runs on every row on its own.
It stays in the sheet
No exports, no second tool, no pasting answers back where they belong.
Easiest Path — 3 Steps
Don't want to read? Let Claude walk you through it.
Download the one-page setup file with every step and every formula in it, hand it to Claude, and have it coach you through the install and your first column.
- 1Download Claude_For_Sheets_Setup.md
- 2Open a new Claude conversation, attach the file, type: "walk me through these instructions one step at a time"
- 3Follow along — then paste the formula recipes straight into your own sheet
One-Time Setup
Four steps, about 10 minutes.
Nothing gets installed on your computer. Everything happens inside a Google Sheet you already have open.
Step 01
Install the Claude for Sheets add-on
Open any Google Sheet, go to Extensions → Add-ons → Get add-ons, search for "Claude for Sheets", and install it. Approve the Google permission screen. That's the whole install — no download, no software on your computer.
Extensions → Add-ons → Get add-ons → "Claude for Sheets" → InstallStep 02
Add your Anthropic API key
Sign in at console.anthropic.com, open API Keys, create one, and drop a few dollars of credit on the account. Then in your sheet: Extensions → Claude for Sheets → Enter your API key. This is pay-per-use and separate from a Claude Pro subscription.
Extensions → Claude for Sheets → Enter your API key
sk-ant-api03-xxxxxxxxxxxxxxxxxxxxxxxxStep 03
Write your first CLAUDE() formula
Claude becomes a spreadsheet function, exactly like SUM or VLOOKUP. You give it an instruction in quotes and point it at a cell. Drag it down the column and it runs on every row.
=CLAUDE("Clean up this company name. Return only the name.", A2)Step 04
Freeze the answers before you share
Formulas re-run and re-bill every time the sheet recalculates. Once a column looks right, copy it and paste it back as values-only. Your results are locked and your API bill stops growing.
Select the column → Copy → Edit → Paste special → Values onlyCopy-paste recipes
Six formulas that do real work.
Swap A2 for whichever cell holds your data, then drag the formula down the column.
Clean messy data
Names typed six different ways, addresses in ALL CAPS, trailing spaces from a CSV export.
=CLAUDE("Fix the capitalization and remove extra spaces. Return only the cleaned text.", A2)Categorize rows
Expenses, support tickets, leads, survey answers — anything you'd normally sort by hand.
=CLAUDE("Categorize this expense as Travel, Software, Meals, or Other. Return one word.", A2)Summarize long text
Turn a column of paragraph-long comments into something you can actually scan.
=CLAUDE("Summarize this customer feedback in one sentence.", A2)Score sentiment
Get a quick read on hundreds of reviews without opening a single one.
=CLAUDE("Is this review positive, negative, or neutral? Answer with one word.", A2)Pull one field out of a mess
Split a jumbled field into clean columns without writing a regex.
=CLAUDE("Extract just the city from this address. Return only the city.", A2)Draft the same email 50 times
Personalized outreach where the details change but the shape stays the same.
=CLAUDE("Write a two-sentence friendly follow-up email to this person about this order.", A2, B2)What I learned the expensive way
Five rules that keep the bill small.
- Tell it what format you want back: "Return one word" or "Return only the name" stops Claude from adding a polite sentence around the answer.
- Test on five rows before you drag the formula down 2,000. Every row is a separate API call you pay for.
- Use =CLAUDE() for short answers and =CLAUDEXL() when you need a longer paragraph back.
- Paste results as values once a column is right — otherwise the sheet re-runs (and re-bills) on every edit.
- If a batch of cells shows an error, it's usually rate limiting. Wait a minute and recalculate.
What it costs
Real numbers, not "it depends".
You're billed per API call, and every cell is a call. Short instructions with short answers are the cheap ones. These are rough ballparks from my own sheets — the exact figure moves with model pricing and how much text each row holds.
| The job | Model | Rough cost |
|---|---|---|
| Tag 500 expenses (one word back) | Haiku | about 5–10 cents |
| Clean 1,000 company names | Haiku | about 10–20 cents |
| Summarize 200 paragraph-long reviews | Sonnet | about $1–2 |
| Draft 100 personalized follow-up emails | Sonnet | about $1–3 |
| Accidentally recalculating that same sheet 5 times | — | 5× the number above |
Put $5 of credit on the account and treat it as your ceiling. Nothing here should burn through that unless you leave a big sheet recalculating all week.
Add-on vs Connectors
Which one do you actually want?
Claude can now open a Google Sheet straight from a chat using Connectors, which makes the add-on look redundant. It isn't. They solve two different problems, and picking the wrong one is why people give up on this.
Best for bulk work
Claude for Sheets (add-on)
- Runs the same instruction down thousands of rows
- Answers land in cells you can sort, filter, and chart
- Needs an Anthropic API key, billed per use
- Best when the sheet is the job
Best for questions
Claude Connectors (chat)
- Claude opens a Drive file during a normal conversation
- Great for questions like "what's odd about this sheet?"
- Covered by your Claude Pro subscription — no API key
- Falls apart when you need the same answer on 800 rows
Short version: if you're asking one question about a file, use Connectors in the desktop app. If you need the same answer on every row, use the add-on.
Worked example
Categorizing a bank export, end to end.
This is the one I run most: a year of transactions with descriptions like SQ *BLUE COPPER COFFEE, sorted into categories I can actually total up.
- 1
Export the statement
Download the CSV from your bank and open it in Google Sheets. You'll usually get a date, a description, and an amount — the description is the messy part.
A B C Date Description Amount 03/14 SQ *BLUE COPPER COFFEE 6.40 - 2
Write the category formula
Put this in D2. Naming the exact categories you want back is what keeps the column consistent — otherwise Claude invents new ones halfway down.
=CLAUDE("Categorize this transaction into exactly one of: Travel, Software, Meals, Office, Personal. Return only the category word.", B2) - 3
Test five rows, then fill down
Check rows 2–6 by eye first. If two of them are wrong, fix the category list in the instruction before you drag it down 800 rows and pay for all of them.
Select D2:D6 → check the answers → then drag D6 down the column - 4
Freeze it and pivot
Copy column D, paste special as values only, then insert a pivot table with Category as rows and Amount as the sum. That's a full spend breakdown from a raw bank export in about ten minutes.
Copy D → Paste special → Values only → Insert → Pivot table
Which Claude do I use?
Three tools, three jobs.
Claude Desktop App
Everyday chat, files, and connected apps like Gmail and Drive.
Desktop App setupClaude for Sheets
The same instruction run across hundreds of rows of a spreadsheet.
You're on this oneComputer Use
Clicking through apps and websites that have no export button.
Computer Use guideQuestions people actually ask.
- What is Claude for Sheets?
- It's a free Google Sheets add-on from Anthropic that turns Claude into a spreadsheet formula. You write =CLAUDE("your instruction", A2) and Claude answers in the cell, so you can run the same instruction down thousands of rows.
- Is Claude for Sheets free?
- The add-on itself is free. The Claude usage behind it is billed per token through the Anthropic API console, so you need a few dollars of credit. A few hundred short cells usually costs cents, not dollars.
- Do I need to know how to code?
- No. If you can write a SUM formula, you can write a CLAUDE formula. The instruction goes in plain English inside quotes and the cell reference goes after it.
- Does my Claude Pro subscription cover this?
- No. Claude Pro covers the chat app. Claude for Sheets runs on the Anthropic API, which is billed separately per use. They're two different accounts on the same login.
- Why do my cells keep recalculating?
- Google Sheets re-runs formulas whenever the sheet changes, and each re-run is a new paid API call. Once a column of results looks right, copy it and paste special as values only to freeze it.
- Can Claude for Sheets read my whole spreadsheet?
- Only the cells you hand it. Each formula sees the instruction plus the cells you reference — it has no view of the rest of the file unless you pass those cells in too.
- How much does Claude for Sheets cost to run?
- You pay per cell, not per month. Tagging 500 expenses with one-word answers runs about 5–10 cents on Haiku; summarizing 200 long reviews on Sonnet is closer to $1–2. Put $5 of credit on the account and treat that as your ceiling.
- Should I use the add-on or Claude Connectors?
- Use Connectors when you want to ask one question about a Drive file in a normal chat — it's covered by Claude Pro and needs no API key. Use the Claude for Sheets add-on when you need the same instruction answered on hundreds of rows and the results to live in cells you can sort and pivot.