Short answer: Yes. Describe what you need in plain English — Claude produces the exact formula for both Excel and Google Sheets. VLOOKUPs, dynamic arrays, nested IFs, pivot table designs, Power Query M code, LAMBDA functions. It also debugs broken formulas and explains why they broke.
This is probably the single biggest time-saver for anyone who works in spreadsheets and has ever spent 20 minutes googling "how do I VLOOKUP but return multiple matches." Claude does the syntax remembering for you. This guide covers what it does well, six real UK business formulas, and where it falls down.
What Claude does well with spreadsheets
- Formula writing from plain English. "Count rows where column B is Active and column D is over 100" produces the SUMIFS/COUNTIFS in seconds.
- Complex nested logic. Tiered commission, conditional pricing, IF-inside-VLOOKUP nightmares — all handled without you having to keep 4 levels of parentheses in your head.
- Cross-platform syntax. Tell Claude "Google Sheets" or "Excel 365" and you get the right syntax variant. Same result formula, different function names.
- Debugging. Paste your broken formula plus the #REF! or wrong-output you’re getting. Claude tells you the exact problem.
- Explanation. Ask "why does this work?" and you get a walk-through. Over time this teaches you the syntax — you end up needing Claude less, not more.
- Pivot table design. Describe your data + your question. Claude tells you exactly which fields to drag into rows, columns, values, filters.
- Power Query M code. The stuff nobody wants to write by hand.
- Cleaning messy exports. Xero, QuickBooks, Sage all export slightly wrong CSVs. Claude writes the transformation.
Six real UK business formulas Claude has written (with prompts)
1. VAT reconciliation across two sheets
The bane of quarter-end for UK accountants: match VAT collected on sales to VAT declared in your ledger by period.
I have two sheets in Excel:
- Sheet "Sales": columns A (invoice date), B (customer), C (net amount), D (VAT amount), E (VAT rate)
- Sheet "VAT": columns A (period), B (customer), C (VAT collected)
Write a SUMIFS formula in Sheet "VAT" column D. It should sum VAT amounts from Sheet "Sales" where the customer matches AND the invoice date falls within the current row’s VAT period (Q1 = Jan-Mar, Q2 = Apr-Jun, etc.).
UK format: DD/MM/YYYY dates, £ currency.2. Property net yield with UK-specific costs
Standard yield calcs ignore UK realities (Section 24 mortgage restriction, letting fees, insurance). Claude accounts for these:
Google Sheet with rental properties:
- A: address
- B: purchase price
- C: monthly rent
- D: annual management fees
- E: annual maintenance
- F: annual insurance
- G: annual mortgage interest
Write formulas for column H (gross yield %) and column I (net yield % after all costs). Format both as % to 2 decimal places. Then add a conditional format rule that highlights net yield below 4% in red.3. UK recruitment tiered commission
Common in UK recruitment: 15% up to £50k billing, 20% from £50k-£100k, 25% above. Nested IFs are painful; IFS is cleaner in Excel 2019+.
Consultant annual billings in cell B2. Commission tiers:
- 15% on the first £50,000
- 20% on £50,000-£100,000
- 25% above £100,000
Cumulative (someone billing £120k gets 15% on first £50k, 20% on next £50k, 25% on remaining £20k).
Write both the legacy nested-IF version AND the modern IFS() version. Explain when to use which.4. Automatic re-order alert for stock
For UK ecommerce and retail:
Excel sheet:
- A: SKU
- B: current stock
- C: average daily sales (last 30 days)
- D: lead time in days
Write column E as "Days of stock remaining" and column F as "Re-order status" — showing OK (green) if 21+ days, LOW (amber) if 8-20 days, CRITICAL (red) if under 7. Include the conditional formatting rules.5. Dynamic FY-end date for UK companies
UK financial year varies by company. Claude works out the FY end from any date:
Cell A1 has a company’s year-end month (1-12). Cell B1 has today’s date.
Write a formula in C1 that returns the next year-end date after today. Example: if year-end month is 3 (March) and today is Jan 2027, C1 should return 31/03/2027. If year-end is 6 and today is Aug 2026, C1 should return 30/06/2027.
UK date format.6. Cleaning a Xero CSV export
Xero’s exports include quirks like currency symbols in number columns, blank rows, split date/description fields. Claude writes the Power Query to clean it in one pass:
I’ve exported a bank statement CSV from Xero. Common problems:
- Amount columns have "£" symbol prefix
- Description column has a leading date sometimes
- Blank rows separate transaction batches
- Multi-currency shows both original and GBP columns
Write Power Query M code that: removes the £ symbol, splits date-prefixed descriptions into separate columns, drops blank rows, and keeps only the GBP amount. Ready to paste into Excel Power Query editor.What Claude gets wrong (and how to catch it)
- Cell references sometimes need adjustment. Claude writes formulas with example cell references (A1, B2). Adjust for your actual sheet layout. It’ll say "adjust references as needed" — heed that.
- Excel version differences. Older Excel doesn’t have XLOOKUP or IFS. If you get a #NAME? error, tell Claude your Excel version and it’ll rewrite using legacy functions.
- Regional locale. UK Excel uses commas as list separators (`SUMIFS(A:A,B:B,"X")`) while some regions use semicolons. If Claude gives you semicolons and Excel complains, swap them.
- Large data assumptions. If Claude assumes 100 rows and you have 10,000, adjust the range. Or ask for a formula that works on the whole column dynamically.
The workflow that changes how you use spreadsheets
The genuine shift isn’t "Claude writes formulas for me." It’s "I never Google Excel syntax again." Every time you need a formula, you describe it, Claude writes it, and you paste it in. Over a few months this saves hours per week — and you gradually stop needing Claude because you’ve absorbed the patterns.
Combine this with Claude’s PDF handling and you have a workflow where messy PDFs become clean CSVs become working spreadsheets with correct formulas — all in one Claude conversation.
Getting started (5 minutes)
- Sign up for Claude (free tier is fine for formula writing)
- Pick one formula you’d normally Google — the most annoying one from your last week
- Describe it to Claude in plain English
- Paste the result into your sheet
- Once you’ve seen one work, you’ll reach for it dozens of times a week
For the full workflow (including 15+ ready-to-use UK business formula prompts), our Excel formulas use case page and the Claude Cowork course cover this in depth. Or take the free 2-min AI Readiness Quiz to see if spreadsheet automation is your biggest opportunity.