Agent in GPT for Excel

The Agent is an AI-powered chat interface that helps you accomplish spreadsheet tasks at scale: bulk content generation, bulk translation, bulk web search, bulk data preparation and analysis, and more. Just describe what you need in plain language, and the Agent analyzes your spreadsheet data and your intent, and automatically executes the task.

You can use the Agent to perform bulk tasks such as:

• Translate to multiple languages

• Search the web

• Generate and autofill formulas

Learn more about what the Agent can and cannot do.

How to use the Agent

To use the Agent in GPT for Excel:

1. In the Home tab, click GPT for Excel Word.

   

   info

   You can also select Home > Add-ins > My Add-ins > GPT for Excel Word.

2. In the sidebar menu, select Agent.

   

3. Type your prompt and click Send.

   

Next, the Agent:

1. Analyzes your request and drafts a plan.

2. Processes the data in the current sheet according to the plan.

Examples

Find out what the Agent can do with the examples below. You can try these examples, and many more, directly from the sidebar.

Translate to multiple languages

Translate spreadsheet content to multiple languages in bulk.

Translate the descriptions in column B to the languages provided in row 1

tip

The Agent can also use a glossary to stick to your brand's language and conventions.

Translate into French, using the following glossary: "Macchiato: Macchiato (Café noisette), Espresso: Expresso, Latte: Café crème (Latte)"

Search the web

When necessary, the Agent searches the web to find the information you need. Learn more about the models used by the Agent.

Fill out this table

tip

The Agent can also scrape specific URLs, using Gemini 2.5 models with URL context.

Generate and autofill formulas

Describe what you need in natural language, and the Agent generates the appropriate Excel formula, inserts it in the starting cell, and automatically fills the formula across the range.

Calculate the revenue for each row

tip

The Agent can also fix formulas and explain them.

Fix the formula in H2

What the Agent can and cannot do

The Agent excels at data processing and analysis tasks. You can use it to:

• Process data in bulk: Translate, categorize, tag, or prep your data across multiple rows.

• Enrich your data: Search the web to fill in missing information or gather additional context.

• Generate content: Generate or rewrite text, generate lists or tables.

• Analyze and summarize: Summarize multiple cells at once.

• Work with formulas: Create, fix, or explain spreadsheet formulas using natural language.

The Agent cannot yet:

• Apply formatting (such as colors or text formatting).

• Create visual elements like charts, pivot tables, or dashboards.

• Modify spreadsheet structure (add/remove columns or rows).

• Take images or documents as input.

FAQ

What models does the Agent use?

By default, the Agent uses different models for different tasks. You can change the model used for some tasks.

Task	Default model	Model configuration
Regular tasks	gpt-4.1 without an API key	To use gpt-4.1 with an API key, contact support.
Bulk tasks	gpt-4o without an API key	Change the default model in the GPT for Work dashboard.
Web search bulk tasks	sonar without an API key	Change the web search model in the GPT for Work dashboard.