/ Single-Case Design Graphs

Overview › Build it with AI › Lesson 1

Lesson 1 of 5About 10 minutes

Set up Claude or ChatGPT in Excel

Both assistants install as Excel add-ins and open in a pane beside your worksheet. Pick one, install it, and sign in. Then set a few privacy habits before any client data goes near it.

You will be able to

  • Install the official Claude or ChatGPT add-in in Excel for Windows or Mac, and sign in.
  • Tell the official add-in from look-alikes by its publisher.
  • De-identify client data, check your account's model-training setting, and save a copy of the workbook before you send a prompt.
Instructions for Excel in Microsoft 365
Drawing, simplified. Both add-ins open as a pane on the right of the Excel window, where you type requests and see what they changed.

Which assistant?

Either one works with every prompt in this series. Use the one your plan or institution gives you.

Claude for ExcelChatGPT for Excel
Made byAnthropic. In Microsoft Marketplace it is the Claude for Microsoft 365 add-in, which also covers Word and PowerPoint.OpenAI. Marketplace listing ChatGPT, publisher OpenAI, LLC.
PlansPaid Claude plans: Pro, Max, Team, and Enterprise. Not available on the Free plan.All ChatGPT plans, with limited use on Free and Go. On Edu and Enterprise workspaces an administrator must turn it on.
Excel versionsMicrosoft 365 on Windows and Mac, and Excel on the web. Not Excel 2016/2019 one-time-purchase versions or iPad.Microsoft 365 on Windows and Mac, and Excel on the web.
Before it editsWarns before overwriting data and asks you to confirm risky operations. Changed cells are highlighted.Asks for permission before making changes, so you can check each step.

Checked October 17, 2026 against the official pages: Claude for Excel docs, ChatGPT for Excel help. Plans and requirements change, so check those pages if something doesn't match.

Install and sign in

Claude for Excel

  1. Open the add-ins store from Excel. WindowsIn Excel, go to Home›Add-ins. MacIn Excel, go to Home›Add-ins, or choose Tools›Add-ins in the menu bar. Search for Claude.
  2. Add the official add-in. Choose Claude for Microsoft 365 (or Claude by Anthropic for Excel) published by Anthropic, and click Add. You can also install it from its Microsoft Marketplace page with Get it now.
  3. Open it and sign in. Open Claude from its button on the ribbon, or from the Add-ins menu where you found it. In the pane that opens, sign in with your Claude account.

ChatGPT for Excel

  1. Open the add-ins store from Excel. WindowsGo to Home›Add-insMacGo to Home›Add-ins and search for ChatGPT.
  2. Add the official add-in. Choose the one published by OpenAI, LLC and click Add. Several similar-looking "GPT for Excel" add-ins come from other companies. Avoid those for client work.
  3. Open it and sign in. Click ChatGPT on the ribbon and sign in with the ChatGPT account that has your plan.

Have Microsoft 365 Copilot through your university? Copilot in Excel can also create and edit charts, and some licenses let you choose a Claude or GPT model. The prompts in this series work there too. Check with your IT office about which Copilot features your license includes.

Protect client data

Single-case data usually come from real clients or research participants. Treat the AI pane like an email to an outside company.