> For the complete documentation index, see [llms.txt](https://docs.gpmautomate.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gpmautomate.com/automate-en/action-guide/file-and-folder/write-excel-file.md).

# Write excel file

Write excel file is an action used to write or update a specific value into a defined cell in an Excel file (`.xlsx` or `.xls`) based on the specified row and column position.

🎥 Watch the tutorial video: [Here](https://youtu.be/EH7olDLAb9c).

#### Configuration parameters:

* File Path: The absolute path to the Excel file that needs to be written (e.g., `D:\GPM\data.xlsx`).
* Sheet index: The position of the sheet where data needs to be written, starting from 0 *(The first sheet is `0`, the second sheet is `1`...)*.
* Column Name or Index: The position of the column where data needs to be written. You can fill it in two ways:
  * By letter: `A`, `B`, `C`, `D`...
  * By index number, starting from 1 *(Column A is `1`, Column B is `2`...)*.
* Row Index: The position of the row where data needs to be written, starting from 1 *(Row 1 is `1`, Row 2 is `2`...)*.
* Value: The text content (or variable containing data) that you want to write into that Excel cell.

#### Practical example: Update account status corresponding to each row of the running Profile

When you run a multi-threaded script (running multiple profiles at the same time), each profile will be assigned system variables by the GPM Automate system for identification: the variable for the input Excel file path (`$inputExcelFileLocation`) and the row number of data that the profile is handling (`$inputExcelCurrentRow`).

Suppose you want the script to automatically write the text `"Success"` into column C (Status) corresponding to the correct row of that profile in the Excel file after successfully logging in:

* Configuration:
  * File Path: Pass the system variable `$inputExcelFileLocation`.
  * Sheet index: `0` *(Write to the first sheet)*.
  * Column Name or Index: `C` *(Status column)*.
  * Row Index: Pass the system variable `$inputExcelCurrentRow` *(The system automatically understands the corresponding row for each profile, for example, profile 1 running row 2 will write to row 2, profile 2 running row 3 will write to row 3)*.
  * Value: Enter the string `"Success"` (or the variable containing your log).

Result: The script will automatically update the results synchronously and accurately into the Excel file in real-time without fear of overwriting or misaligning data between threads.

<figure><img src="/files/IMBZM6Uq9DGXMIUBRILQ" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/X8M3aluViLOk1vE8MCTb" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/b7iuE6bqMs88kM1cZDga" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.gpmautomate.com/automate-en/action-guide/file-and-folder/write-excel-file.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.