---
title: "Table Write Agent"
description: "EMILY.RPA Table Write Agent module: describe the goal in natural language and let a large language model edit a specified spreadsheet autonomously."
source: https://docs.emily.tips/en/ai-agent/table-write-agent
---

# Table Write Agent

Table Write Agent uses natural language to describe the task goal and autonomously edits information in a specified spreadsheet through a large language model (LLM). Note that larger goals make the language model more prone to misjudgment and consume more tokens — it is recommended to break tasks into smaller sub-tasks to reduce failure rates. If you're unfamiliar with how to prompt the language model to achieve task goals, use "**Ask EMILY**" to let the AI generate model-friendly goal prompts.

![](https://docs.emily.tips/img/en/ai-agent-071.png)

## Parameters

**`API KEY`** - OpenAI or Google API key. Supports the **%FILENAME%** variable, or use the prepaid dedicated key **%credit-key%**.

* For OpenAI API Key, refer to [Apply for OpenAI Key](/faq/apply-openai-key)
* For Google API Key, refer to [Apply for Gemini Key](/faq/apply-gemini-key)

**`MODEL`** - Currently supported models:

| Platform | Models                                                          | Pricing                                                 | 
| -------- | --------------------------------------------------------------- | ------------------------------------------------------- |
| OpenAI   | gtp-5, gpt-5-mini, gpt-4.1, gpt-4.1-mini                       | [OpenAI Website](https://platform.openai.com/docs/models) |
| Google    | gemini-3-pro, gemini-3-flash, gemini-2.5-pro, gemini-2.5-flash | [Gemini Website](https://ai.google.dev/gemini-api/docs/pricing) |
| Anthropic | claude-opus-4-6, claude-sonnet-4-6, claude-haiku-4-5             | [Anthropic Website](https://docs.anthropic.com/en/docs/about-claude/models) |

**`XLSX/CSV/TSV/GOOGLESHEET`** - Input file. Click "**PICK**" to select a file, or use the **%FILENAME%** variable. In addition to the listed file formats, **Google Sheets ID** is also supported.

**`SHEET`** - Enter the worksheet name. Leave empty to use the first worksheet in the file.

**`MAX ACTION`** - Set the maximum number of actions the agent can perform, ranging from 1–100.

**`GOAL`** - Describe the task in natural language. Supports the **%FILENAME%** template.

**`STATUS`** - The next spreadsheet operation determined and executed by the model.

## Example

Using the following sales detail table as an example, the task is to modify the sales dates that meet certain conditions.

![](https://docs.emily.tips/img/en/ai-agent-072.png)

Import the sales detail spreadsheet file into the working folder.

![](https://docs.emily.tips/img/en/ai-agent-073.png)

For the Table Write Agent, select the model `Google/gemini-2.5-flash`, enter the imported spreadsheet filename in the parameters, and use natural language to prompt the model: change date of the order on 2026-03-18 to 2026-03-20.

![](https://docs.emily.tips/img/en/ai-agent-074.png)

Finally, click "**TEST**" to try it out, then check whether the content of `sales.xlsx` in the working folder is correct.

![](https://docs.emily.tips/img/en/ai-agent-075.png)