Copilot in Excel, Claude and ChatGPT: What Each Can Do for a Monthly Report

Copilot, Claude and ChatGPT now work inside Excel. What each one does, who can use it, and what a monthly report needs that they don't keep.

Founder, Glow Reports. , 3 min read
  • AI
  • Excel
  • Product Comparison
Three AI assistants beside a spreadsheet, and a report built from several files
On this page
  1. How do you use Copilot in Excel?
  2. What can Claude for Excel do?
  3. What does ChatGPT for Excel do?
  4. Which one fits a one-off analysis?
  5. What does a monthly report need that a spreadsheet chat doesn't keep?
  6. Where does Glow Reports fit?
  7. Common questions

Copilot, Claude and ChatGPT all work inside Excel now. Each one reads a workbook, writes formulas and builds charts from a question in plain English. For a one-off analysis, that is often enough. A monthly report asks for more. It needs the same definitions every month, figures you can trace back to the source, and a document you can send without rewriting it. Below is what each tool does, who can use it, and where each one stops.

How do you use Copilot in Excel?

Open a workbook saved as .xlsx, select Copilot on the Home tab, and ask your question in the pane that opens. Copilot can generate formulas, create charts and PivotTables, and apply formatting. It offers three modes: edit, plan and chat.

From the keyboard, press Alt+H, then F, X to open the Copilot pane Microsoft Support.

If the button is missing, check the four requirements Microsoft lists in its Copilot in Excel FAQ:

  • A subscription that includes it: Microsoft 365 Personal or Family with an AI credits plan, Microsoft 365 Premium, a commercial Microsoft Copilot subscription, or a business plan eligible for Copilot Chat.
  • Calculation Options set to Automatic. Copilot can only edit in that mode.
  • A regular .xlsx file. Strict Open XML files are not supported.
  • A file that is not checked out in SharePoint. If your organization requires check-out, use Excel for the web.

Prompts that work well on an export of orders:

  1. "Add a column with the month of each order date."
  2. "Build a PivotTable of revenue by month and by country."
  3. "Chart revenue by month and point out the months below the average."

Check the result. Microsoft says Copilot's output "can be inaccurate or inappropriate" and asks you to review, edit and verify it. The same page advises against relying on it for decisions in sensitive areas such as finance.

What can Claude for Excel do?

Claude for Excel is Anthropic's add-in for the Pro, Max, Team and Enterprise plans. It answers questions about the open workbook with cell-level citations, traces errors to their cause, changes assumptions while keeping formulas linked, and builds a model from a description.

You install it from the Claude for Microsoft 365 listing in Microsoft's add-in store, open it from Home, Add-ins, and sign in. It runs on Excel for the web, on Windows with a Microsoft 365 subscription and on recent Mac builds. It does not run on Excel 2016 or 2019 with a perpetual licence, on iPad or on Android Anthropic's documentation.

It can sort, filter, edit PivotTables, apply conditional formatting and add validation dropdowns. Macros, VBA and Excel data tables are outside its reach. Anthropic advises against two uses without a person checking first: final client deliverables and audit-critical calculations. It also warns that a spreadsheet from an outside source can hide instructions aimed at the add-in, so use it on files you trust.

Chat history stays in your browser. It doesn't sync.

What does ChatGPT for Excel do?

ChatGPT for Excel is OpenAI's add-in for Excel and Google Sheets. It opens in a sidebar and builds, updates and explains workbooks, including files with several tabs. OpenAI's help page lists it on every plan from Free to Enterprise, with tighter usage limits on Free and Go.

To install it, go to Home, Add-ins, search for ChatGPT and sign in OpenAI Help Center. At launch, OpenAI said it explains each step, cites the cells it reads or changes and asks before it writes to a range eWeek.

Spreadsheet chats stay apart from your regular ChatGPT history and don't use ChatGPT's memory. VBA and macros may not be fully supported. OpenAI also asks you to review the output before you rely on it.

Which one fits a one-off analysis?

All three handle a one-off question well. The choice mostly comes down to the subscription your team already pays for and where your files live.

Copilot in ExcelClaude for ExcelChatGPT for Excel
Who can use itMicrosoft 365 plans that include CopilotClaude Pro, Max, Team, EnterpriseEvery ChatGPT plan, with limits on Free and Go
Where it runsExcel desktop and webExcel web, Windows, MacExcel and Google Sheets
Strong atFormulas, charts and PivotTables inside Microsoft 365Explaining a model with cell citations, tracing errorsBuilding and updating workbooks, also in Sheets
What the vendor asksVerify everything, avoid sensitive finance decisionsA person reviews client deliverables and audit-critical numbersReview the output

If your company runs on Microsoft 365, start with Copilot. If you need to understand a complex model someone else built, Claude's cell citations save time. If part of your team works in Google Sheets, ChatGPT covers both.

What does a monthly report need that a spreadsheet chat doesn't keep?

A monthly report runs the same analysis on new data, with the same definitions, and someone has to show how each figure was counted. A chat inside one workbook keeps little of that from one month to the next.

  • Definitions drift. Ask "how many active customers?" in a new conversation next month and the count can change with the wording. Claude keeps its history in one browser, and ChatGPT's spreadsheet chats don't use its memory.
  • Several files. A monthly report often combines a sales export, a billing export and a target sheet. You bring them into the workbook yourself, every month, in the same shape.
  • Checking. All three vendors tell you to verify the output. Microsoft benchmarked Excel's Agent Mode at 57.2% accuracy on SpreadsheetBench, against 71.3% for people (Futurum Group, October 2025, before general release).

Whichever add-in you use, four habits keep a monthly report honest:

  1. Keep a definitions tab in the workbook: what counts as revenue, as a customer, as an active month. Paste it into your first prompt each month.
  2. Save your prompts and reuse the exact wording.
  3. Check one total against the source export before you send anything.
  4. Keep last month's file, and compare before you trust a big swing.

Where does Glow Reports fit?

Glow Reports starts from your files instead of one open workbook. You upload one or several CSV or Excel files and ask for the report. The AI writes the SQL, builds the charts and drafts the text.

The SQL sits under each figure, so you can read how a number was counted, edit the query when the definition is wrong, and export the finished report to PDF. The report stays in your workspace with its queries, so next month you upload the new files, ask for the report again and compare its SQL with last month's. The free plan gives 300 credits once, and a report costs 100 credits.

If your team already pays for Copilot, Claude or ChatGPT, keep using it for quick questions inside a workbook. Reach for a reporting tool when the same report comes back every month and you have to defend each number. For the trade-offs with classic BI, read Power BI vs an AI reporting tool. For the cost of the manual routine, read why monthly reports in Excel eat your week.

Common questions

Is Copilot in Excel free?

No. Microsoft lists four ways to get it: Microsoft 365 Personal or Family with an AI credits plan, Microsoft 365 Premium, a commercial Microsoft Copilot subscription, or a business plan eligible for Copilot Chat.

Can I use Claude for Excel on the free Claude plan?

No. Anthropic lists the Pro, Max, Team and Enterprise plans.

Does ChatGPT for Excel work in Google Sheets?

Yes. OpenAI offers the same add-in for Excel and Google Sheets.

Do I need to know SQL to use Glow Reports?

No. The AI writes the SQL. You can read it under each figure when you want to check how a number was counted.

El Mehdi Benane
Founder, Glow Reports

I am a product engineer and the founder of Glow Reports. I spent more than 6 years building products in tech, data and cybersecurity, for large groups, startups and SMEs. In most organizations I saw data treated as a technical topic, when it drives business decisions. I built the reporting tool I was looking for, so the people who run small and mid-sized organizations can read their own numbers without a data team.

Upload your CSV or Excel exports to Glow Reports and get a report with the SQL behind each figure.

Keep reading