From an Excel workbook, click GPT for Excel Word in the Home tab.
The sidebar appears on the right of your workbook.
Select API keys from the add-in menu.
Paste your secret key where indicated, then click Save API key.
(Optional) Enter your OpenAI organization ID and click Save. If you are part of multiple organizations, it ensures that you get billed on the correct account.
(Highly recommended) Test your OpenAI API key:
Open the model switcher dropdown, and select one of the OpenAI models that use your API key.
Type a simple formula in a cell and get a response from GPT:
=GPT("Write a tagline for a car")
Check our Troubleshooting section if you encounter any issue.
You have set up your OpenAI API key in GPT for Excel.
Learn how to use the GPT function.