Set up your OpenAI API key

Set up your own OpenAI API key to benefit from cost savings and from your own rate limits, or to use your OpenAI Assistants.

Prerequisites

• You have created your OpenAI API key.
• You are part of an OpenAI organization that is at least Tier 3. Check your organization settings to verify your current tier.

1. Click GPT for Excel Word in the Home tab. If you don't see it, go to Home > Add-ins > My add-ins > GPT for Excel Word.
   
   

The sidebar appears on the right of your workbook.

2. Select API keys from the add-in menu.
   
   
3. Paste your secret key where indicated, then click Save.
   
   
4. (Optional) Enter your OpenAI organization ID from the OpenAI Organization settings page, then click Save. If you are part of multiple organizations, it ensures that you get billed on the correct account.
   
   
5. (Highly recommended) Test your OpenAI API key:
   1. Open the model switcher dropdown, and select one of the OpenAI models that use your API key.
      
      
   2. Type a simple formula in a cell and get a response from GPT:
      
      

      =GPT("Write a tagline for a car")

You have set up your OpenAI API key in GPT for Excel Word.

note

When using an OpenAI API key, you need to purchase credits from OpenAI and also buy a pack in GPT for Excel Word. Learn more

What's next

Learn how to use the GPT function.