---
title: "Replace Row"
slug: "replace-row"
updated: 2025-07-09T14:31:57Z
published: 2025-07-09T14:31:57Z
canonical: "documentation.decisions.com/replace-row"
---

> ## 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.

# Replace Row

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

The **Replace Row** step can be utilized when the first column of a spreadsheet is designated for row numbers or row identifiers. This step allows users to replace the content of the first cell in a specific row with new text or values.

Note:

- This step will only replace the value from the first cell of the row and will not alter any changes to the rest of the cells.
- No matter what the formatting is set to the cell, this Step will override the value with a string within that cell.

---

## Properties

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| File | The Excel or CSV file where the data is pulled from. | FileData |
| File Type | The type of file being used by the step. The step currently supports CSV, Excel_xls, or Excel_xlsx. Use Constant mapping to view the drop-down. | CSVFileType |
| Worksheet Number | The Worksheet Number to pull the data from. The values start at zero. | Int32 |
| Row Number | The Row number of the cell to replace the value of. The starting value is zero. | Int32 |
| New Row | The new value to be placed in the first cell of the row. | String |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| ReplaceRow1_Output | Updated File Data | File Data |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1699455561867.png)Based on the step configured from the above image, the following table demonstrates the Input and Output.

| Before (Input) | After (Output) |
| --- | --- |
| ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1699455700828.png) | ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1699455757019.png) |

---

Related Information

Forum Posts: [Add New Excel Row](https://community.decisions.com/discussion/26498/add-new-excel-row)

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