Set up your Anthropic API key
Set up an Anthropic API key within the add-in settings to use Claude models in GPT for Excel. You can register both an Anthropic key and an OpenAI key to benefit from a wider range of models.
Prerequisites
You have created and copied an Anthropic API key.
From a Microsoft Excel workbook, click GPT for Excel Word in the Home tab.
Select API keys from the add-in menu.
Paste your Anthropic API key where indicated, then click Save.
(Highly recommended) Test your Anthropic API key:
Open the model switcher dropdown, and select one of the Anthropic Claude models.
Type a simple formula in a cell and get a response from GPT:
=GPT("Write a tagline for a car")
note
Check our Troubleshooting section if you encounter any issue.
You have set up your Anthropic API key in GPT for Excel.
What's next
Learn how to use the GPT function.