Select a model or an OpenAI Assistant in GPT for Excel

Select the most adapted model or OpenAI Assistant in terms of accuracy, speed and cost, and set it as default for all GPT executions from Microsoft Excel.

You can refer to the following material for guidance:

• List of supported models for GPT for Excel with or without your own API keys

• Average response time for each model

• Guide to use OpenAI Assistants as models

Prerequisites

You have created a Microsoft workbook and clicked GPT for Excel Word in the Home tab.

1. In the GPT for Excel sidebar, expand the model switcher.

   

2. Select a model.

   If you require a model or an OpenAI Assistant that is only accessible with a key, set up an API key first.

   

The model you selected is now the default for all GPT function executions. New executions will use this model.

Existing formulas will not automatically update to the new model if the cache is enabled. To re-execute them with a different model, you can either disable the cache, select the formulas and regenerate their results, or change a parameter in the formulas and press Enter.

note

The GPT_MATCH and GPT_VISION functions use specific models, not the default one. Learn more.

What's next

Run bulk tools and execute GPT functions in GPT for Excel.