---
title: "Get Excel Row and Column Count Step"
url: "https://docs.robotiq.ai/en/article/get-excel-row-and-column-count-step"
language: "en"
last_updated: "2025-12-24T15:07:38.274Z"
---

# Get Excel Row and Column Count Step

The Get Excel Row and Column Count step tells you how many rows and columns are in a specific Excel sheet. You can use this step to change your automation based on how big your Excel data is.

## What You'll Need

-   An open Excel file connection, made with the [Open Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).

## How to Use Get Excel Row and Column Count

Add this step to your process to count the rows and columns in an Excel sheet.

### Step 1: Add the Get Excel Row and Column Count Step

1.  Drag and drop the **Get Excel Row and Column Count** step into your workflow.
2.  (Optional) Give it a **Step name** to label it in your process.

### Step 2: Configure Input Parameters

1.  **Excel instance name**: Type the name of your Excel connection. This is the same name you used in the [Open Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).
2.  **Sheet name**: Type the name of the Excel sheet you want to count. You can also use a variable that holds the sheet name.
3.  **Has custom columns**: Choose `T` if your Excel sheet has header columns. Choose `F` if it does not (this is the default).

### Step 3: Define Output Variables

1.  **Column count**: Type the name of a new or existing integer variable. The step will put the total number of columns in this variable.
2.  **Row count**: Type the name of a new or existing integer variable. The step will put the total number of rows in this variable.

## Parameters Explained

**Step name** (Optional)

-   A custom name for this step in your process.

**Excel instance name** (Required)

-   The unique name of the Excel connection. This must match the name from your [Open Excel File Step](https://docs.robotiq.ai/en/article/open-excel-file-step-and-close-excel-file-step).
-   Example: `myExcelConnection`

**Sheet name** (Required)

-   The name of the Excel sheet to count.
-   Example: `"Sheet1"` or a variable like `mySheetName`

**Has custom columns** (Required)

-   `T` (True): Your sheet has a header row.
-   `F` (False): Your sheet does not have a header row. This is the default setting.

**Column count** (Required)

-   The name of an integer variable to store the total number of columns found.
-   Example: `totalColumns`

**Row count** (Required)

-   The name of an integer variable to store the total number of rows found.
-   Example: `totalRows`

## 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)
-   [Excel Rows Loop Step](https://docs.robotiq.ai/en/article/excel-rows-loop-step)

## 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/f8640de6-ff35-4058-a711-fd26c391eac9)