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.

Prerequisites
  1. From an Excel workbook, click GPT for Excel Word in the Home tab.

    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 API key.

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

  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")
note

Check our Troubleshooting section if you encounter any issue.

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

What's next