---
title: "Read Value From Excel File Step"
url: "https://docs.robotiq.ai/en/article/read-value-from-excel-file-step"
language: "en"
last_updated: "2025-12-24T15:05:08.603Z"
---

# Read Value From Excel File Step

The Read Value From Excel File step gets a value from a specific cell in an Excel file. It then saves this value into a string variable. Use this step to pull data from your Excel spreadsheets for your automation processes.

## What You'll Need

-   An Excel file you've already opened using the [Open Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).

## How to Read a Value From an Excel File

Use this step to get data from a cell in an open Excel file.

### Step 1: Add the Read Value From Excel File Step

1.  Drag and drop the **Read Value From Excel File** step into your process workflow.
2.  (Optional) Give the step a **Step name** to describe what it does.

### Step 2: Set Up Input Parameters

1.  Pick the **Excel instance name** from the dropdown list. This is the name you gave the Excel connection in the [Open Excel File step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).
2.  Type in the **Sheet name** where the cell is. You can use a variable or just type the name.
3.  Type in the **Column name** (like "A", "B", "C") for the cell. You can use a variable or type the column letter.
4.  Type in the **Row index** (like "1", "2", "3") for the cell. You can use a variable or type the row number.

### Step 3: Set Up the Output Variable

1.  In the **Destination variable** field, type a name for the variable that will hold the cell's value.
2.  If the variable doesn't exist, Robotiq.ai will make a new string variable.

## Parameters Explained

**Step name** (Optional)

-   A custom name for the process step. This helps you find the step in the editor.
-   Example: `Read Product ID`
-   Use it to make your process easier to follow.

**Excel instance name** (Required)

-   The unique name of the Excel connection.
-   You set this name in the [Open Excel File step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).
-   Choose from the list of available connections.

**Sheet name** (Required)

-   The name of the worksheet in the Excel file.
-   Example: `"Sheet1"` or a variable like `excelSheetName`.
-   Use it to say which sheet to read from.

**Column name** (Required)

-   The letter for the column of the cell you want to read.
-   Example: `"A"` or a variable like `targetColumn`.
-   Use it to find the exact column.

**Row index** (Required)

-   The number for the row of the cell you want to read.
-   Example: `"5"` or a variable like `targetRow`.
-   Use it to find the exact row.

**Destination variable** (Required)

-   The name of the string variable where the cell's value will be saved.
-   Example: `productCode`
-   If the variable doesn't exist, the system creates it as a string.

## Related Articles

-   [Open Excel File Step and Close Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step) - Learn how to connect to an Excel file.
-   [Write Value To Excel File Step](https://docs.robotiq.ai/en/article/write-value-to-excel-file-step) - Learn how to write data to an Excel cell.
-   [Define Variable Step](https://docs.robotiq.ai/en/article/define-variable-step) - Learn how to make new variables.

## Need Help?

Can't find what you're looking for? Join the [Robotiq Community](https://community.robotiq.ai/home/) to get help from other users and the Robotiq team.

![](https://cdn-assets.productfruits.com/f2508208-caf8-4fe6-9df5-6a8010bb2f5f)