> For the complete documentation index, see [llms.txt](https://docs.roboteasy.tech/studio-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roboteasy.tech/studio-en/studio/objetos/excel/varrer-dados-excel.md).

# Loop Through Excel Data

Object to loop through all the data of an Excel file.

## Settings 

{% hint style="info" %}
This object depends on the use of the "**New Excel"** or "**Open Excel**" object to work.
{% endhint %}

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MVH9MuDODQiHIAveK64%2F-MVHlbYdM3jDTM6837iJ%2Fimage.png?alt=media\&token=685692cc-20c8-4b5c-bce2-05fa3c486485)

| Field                  | Descritivo                                                                                          |
| ---------------------- | --------------------------------------------------------------------------------------------------- |
| Title                  | Object title                                                                                        |
| Object Identifier Name | Singular object name for searching data in the Excel file                                           |
| Select Main Object     | Option to select an Excel spreadsheet                                                               |
| Reading Conditions     | Option to select the reading conditions                                                             |
| Row Counter            | Option to count the number of rows in the Excel file                                                |
| Starting Counter Value | Indicador da linha para início do cálculo - The initial row index from which the counter will start |

## Example

In order to loop through data in an Excel file you need to follow a few steps:

1 - Select the **"Open Excel"** object from the "**Excel**" menu and drag it to your working area.

* First you must define a unique name for the object in the "**Object Identifier Name**" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the **"Loop Through Excel Data**" object from the **"Excel"** menu, enter a name for the object, select the main object, the reading conditions and finally enter the initial value to start the count.