Skip to main content

Set up your OpenAI API key

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

  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.

  2. The sidebar appears on the right of your workbook.

  3. Select API keys from the add-in menu.

  4. Paste your secret key where indicated, then click Save.

  5. (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.

  6. (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.


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