Skip to main content

Using Custom GPTs in GPT for Excel

While Custom GPTs are limited to use within ChatGPT, they can easily be replicated as OpenAI Assistants and used in other applications like GPT for Excel. The only difference is that OpenAI Assistants cannot search the web, unlike some Custom GPTs. This guide demonstrates how to turn Custom GPTs into OpenAI Assistants and use them in GPT for Excel to create content within Microsoft Excel.

Turn a Custom GPT into an OpenAI Assistant​

To use a Custom GPT's configuration in GPT for Excel, you'll need to recreate it as an OpenAI Assistant. Here's how to do it:

  1. Edit your Custom GPT in ChatGPT.

    Configure button for Custom GPT

  2. Copy the instructions from your Custom GPT.

    Custom GPT instructions

  3. Go to the OpenAI platform and create a new assistant.

    Click Create

  4. Configure your assistant:

    • Give your assistant the same Name as your Custom GPT.
    • Paste the instructions into the Instructions field.
    • Choose the same Model as your Custom GPT, typically gpt-4o.
    Paste your GPT settings in the assistant

  5. If your Custom GPT uses specific files, upload them to the assistant with the Files button in the File search section. Learn more.

    Upload files

  6. Enable Code interpreter if you used it in your Custom GPT.

Now you have an OpenAI Assistant that replicates your Custom GPT, ready to be used in GPT for Excel.

Use an OpenAI Assistant in GPT for Excel​

Once you've created your assistant, you can use it in GPT for Excel:

  1. Open the GPT for Excel add-on, and set up your OpenAI API key.

  2. Select the assistant in the model switcher in GPT for Excel.

    3. OpenAI Assistant selected in the model switcher

Your OpenAI Assistant will now be used to execute bulk tools and GPT functions in GPT for Excel, using the same instructions and knowledge as your original Custom GPT.

On this page