That family budget, that trip-expense tracker, that sign-up sheet. They all sit somewhere gathering dust, because getting one answer out means digging through formulas you do not remember writing. All four tools can now sit inside or next to a spreadsheet and just answer a plain question about it. Here is one way to do that in each, plus an honest note on what it takes to get access.
Claude: ask Claude for Excel about your workbook
Claude for Excel is an add-in that sits inside Excel and answers questions about the workbook you already have open, pointing to the exact cells it used.
- In Excel, find the Microsoft Marketplace listing for “Claude for Microsoft 365” and click Get it now to install the add-in.
- Open your spreadsheet on web, Windows, Mac, or iPad, and open the Claude sidebar from the ribbon.
- Sign in with your Claude account, then ask a plain question about the sheet, for example “which month did we go over budget, and by how much.”
- Check the cells Claude points to before you trust the answer.
When to reach for it: when you already keep a working spreadsheet and want an answer without hunting through your own formulas. As of mid-2026 this needs a Claude Pro, Max, Team, or Enterprise plan, not the free tier.
Source: Claude Help Center
ChatGPT: upload a spreadsheet and ask ChatGPT to dig in
ChatGPT can take a spreadsheet or CSV you upload and run real analysis on it, totals, trends, and charts, not just a summary.
- Open ChatGPT and start a new chat.
- Click the attachment icon and upload your spreadsheet or CSV export, a bank statement, a trip budget, whatever you are tracking.
- Ask for what you want, for example “chart our spending by category” or “what did we average on groceries each week.”
- Follow up to go deeper, like “now show it without the one-time purchases.”
When to reach for it: when your numbers live in a messy export rather than a workbook you maintain, and you want it turned into something readable. As of mid-2026, file uploads and data analysis need a ChatGPT Plus plan or higher.
Source: OpenAI Help Center
Copilot: chat with Copilot inside Excel
Copilot in Excel sits in the same window as your spreadsheet and can answer questions, build a chart, or clean up the data without you writing a formula. This is Microsoft 365 Copilot, not the free consumer version.
- Open your workbook in Excel and select the Copilot icon in the lower right corner.
- Choose Chat mode for answers without changes, or Edit mode to let Copilot update the sheet directly.
- Ask a real question, for example “which category are we overspending in this month” or “build a pivot table of spending by person.”
- Review the plan Copilot proposes before it runs, and watch it work in real time.
When to reach for it: when the sheet already lives in Excel and you want Copilot to build something, a chart, a pivot table, a formula, not just talk about it. Requires a Microsoft 365 subscription that includes Copilot.
Source: Microsoft Support
Gemini: have Gemini build the spreadsheet for you
Instead of opening a blank sheet, you can describe what you need and have Gemini in Sheets build it, formulas and all.
- Open Google Sheets. The Build side panel opens automatically on the right, or open it from the toolbar.
- Type what you want, for example “build a trip expense tracker for four people with columns for who paid, category, and amount owed.”
- Answer any follow-up questions Gemini asks, then review the plan and template outline.
- Let it generate the sheet, and ask a follow-up like “add a tab that totals what each person owes” to keep building on it.
When to reach for it: when you are starting from nothing and would rather describe the tracker than build it cell by cell. As of mid-2026 this needs Gemini Alpha, Google AI Pro or Ultra, or the Workspace Experiments program, not the Gemini access most people have by default.
Source: Google Docs Editors Help
One thing to keep in mind
An AI reading your spreadsheet can still misread a formula or miscount a range, especially on a sheet with a lot of manual patching over the years. Spot-check anything that touches real money, like a total or a balance, against the sheet itself before you act on it.
Want this in your inbox each week? Subscribe to Darice on AI.