Skip to main content

Select the Agent models in Excel

GPT for Excel supports a range of models that you can use with the Agent.

Set the default model for the Agent

You can set the default model used by the Agent in GPT for Excel. The Agent uses the model to generate lists and process columns in bulk.

note

You cannot currently select models available through OpenAI-compatible API endpoints.

  1. Sign in to the GPT for Work dashboard with your Microsoft account.

  2. In the sidebar, select Models.

  3. In Default model, select the model you want to set as the default.

    Set the default model

The Agent now uses the selected model to generate lists and process columns in bulk.

Set the web search model for the Agent

You can set the web search model used by the Agent in GPT for Excel. The Agent uses the model to generate lists and process columns in bulk when carrying out web searches.

note

You cannot currently select models available through OpenAI-compatible API endpoints.

note

This also sets the model used by the GPT_WEB function.

  1. Sign in to the GPT for Work dashboard with your Microsoft account.

  2. In the sidebar, select Models.

  3. In Web search model, select the model you want to set as the web search model.

    Set the web search model

The Agent now uses the selected model to generate lists and process columns in bulk when carrying out web searches.

What's next

Learn more about models: