---
title: "Convert Excel or CSV to Dynamic Data Rows"
slug: "convert-excel-or-csv-to-dynamic-data-rows"
updated: 2025-02-21T16:47:16Z
published: 2025-02-21T16:47:16Z
canonical: "documentation.decisions.com/convert-excel-or-csv-to-dynamic-data-rows"
---

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

# Convert Excel or CSV to Dynamic Data Rows

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

As an addition to the host of **CSV**/**Excel** handling steps, users are provided the option to convert a user-defined Excel File or set of CSV into a **List of Dynamic Data Rows** using a single step. This allows the ability to use the **Output** **Data** values within Decisions.

---

## Properties

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| Input File | The CSV or excel file that is used as input. | FileData |
| Worksheet Numer | Determines which worksheet that will be evaluated. | Int32 |

#### Input Data

| Property | Description |  |
| --- | --- | --- |
| Input File Type | Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect | --- |
| Ignore First Row | Ignores the first row in the Excel or CSV file, typically used as a header row. | Boolean |
| Get Worksheet From Flow | Enabling this Property allows users to dynamically set the Worksheet Number within Inputs. | Boolean |
| Worksheet Index | Determines which worksheet that will be evaluated. | Int32 |
| CSV Delimiter | Determines which delimiter is used in the CSV files. | --- |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| Results | Converted Data | List of DynamicDataRow |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2022-10-20_13h49_39.png)

Related Information

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