---
title: "Replace Value in Column"
slug: "replace-value-in-column-1"
updated: 2025-02-21T17:14:01Z
published: 2025-02-21T17:14:01Z
canonical: "documentation.decisions.com/replace-value-in-column-1"
---

> ## 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 Value in Column

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

The **Replace Value in Column** step enables you to replace a specific value within a cell, based on the input column of the given Excel file**.** This step requires you to define the **Old Value** and the **New Value**. It will then iterate through the values in the selected column and replace any instances of the Old Value with the New Value.

> [!WARNING]
> Important Considerations:
> 
> - This step does not generate any output. Instead, it modifies the value within the same file that is being used within the Flow.
> - The values given under the "Old Value" field must be the entire cell value. It will not replace any partial values within the defined 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 |
| Column | The column number of the value to replace. The starting value is one. | Int32 |
| Old Value | The old value needs to be replaced. | String |
| New Value | The new value to place in the cell. | String |

> [!NOTE]
> Converter Flows:
> 
> The **Old Value** and the **New Value** only accept strings. Users can use [Converter Flows](https://documentation.decisions.com/docs/using-converter-flows) to convert them to Number, Text, and Date formats.

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

Related Information

- [Add New Excel Row](https://support.decisions.com/forum/topic26498-add-new-excel-row.aspx)
- [Building and Using Converter Flows](https://documentation.decisions.com/docs/using-converter-flows)

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