---
title: "Get Worksheet Index From Name"
slug: "get-worksheet-index-from-name"
tags: ["worksheet", "index"]
updated: 2025-07-09T14:20:58Z
published: 2025-07-09T14:20:58Z
canonical: "documentation.decisions.com/get-worksheet-index-from-name"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get Worksheet Index From Name

| ## Step Details |
| --- |
| **Introduced in Version** | 5.0.0 |
| **Last Modified in Version** | 7.12.0 |
| **Location** | Data > Excel and CSV |

## Overview

The **Get Worksheet Index From Name** step returns the numerical position of a worksheet based on the given worksheet name.

---

## Properties

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| File Type | The type of file being used by the step. The step supports Excel_xls and Excel_xlsx file types only. Use **Constant** mapping to view the drop-down. | CsvFileType |
| Input | Excel file to pull the data from. | [FileData](https://documentation.decisions.com/docs/file-type-overview) |
| Worksheet Name | The Worksheet Name to return the Index of the Worksheet | String |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| Output | Returns the Index of the Sheet. **Note**: The Indexing of the worksheet starts from "Zero." | Int32 |

#### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1698236147866.png)

---

Related Forum Posts[Getting Values from an Excel File](https://community.decisions.com/discussion/25653/getting-values-from-excel-file-via-flow)

Training Video: [Dynamic Excel Creation](https://www.youtube.com/watch?v=hcIiRwi_8wo)

## Related

- [Add Work Sheet](/add-work-sheet.md)
- [Remove Worksheet By Name](/remove-worksheet-by-name.md)
- [Create New Excel File](/create-new-excel-file.md)