Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 9.16.0 |
| Location | Data > Excel & CSV |
The For Each Excel Or CSV Row Step can be used to create a Flow loop to perform the same actions for every row within an excel or CSV row within a list from the "Next" outcome. The "Done" outcome is used when all of the items in a list have been processed.
When selecting the Input File Type under the INPUT DATA section, be mindful of what type of file is being used. CSV, XLS, and XLSX files all have specific properties and limitations. For instance, XLS files only support 65,536 rows. Input Data properties will also change when changing between the file types.
Properties
Input Data
Some properties will only appear depending on the Input File Type selected.
| Property | Description | Data Type |
|---|---|---|
| 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. | --- |
| Worksheet Number | Determines which worksheet that will be evaluated. | Int32 |
| Ignore First Row | Ignores the first line of the worksheet often used as headers in Excel files. | Boolean |
| Get Worksheet From Flow | Enabling this Property allows users to dynamically set the Worksheet Number within Inputs. | Boolean |
| Ignore Empty Rows | Ignores any rows that do not contain any data. | Boolean |
| CSV Delimiter | Determines which delimiter will be added with the values for CSV files. | --- |
| CSV File Encoding Type (v9.16+) | Users can choose ASCII, UTF8, UTF32, LATIN1, and Unicode. This encoding type is necessary to correctly handle some special characters. | --- |
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Input | The CSV or Excel file that is used as input. | FileData |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Next Row | Outputs a single row of DynamicDataRow to use to manipulate data. | DynamicDataRow |
Common Errors
Wrong File Type
Under INPUT DATA, the Input File Type selection must match the file that is being used by the step. An XLSX file must use the Excel_xlsx setting. The step may function incorrectly otherwise.
Step Changes
| Description | Version | Release Date | Developer Task |
|---|---|---|---|
| Fixed a bug that prevented values from being displayed correctly if they were formatted, for instance as currency or decimals. | 8.19 | March 2024 | [DT-040248] |
| Added the CSV File Encoding Type property under Inputs. | 9.16 | October 2025 | [DT-044412] |
Forum Posts:
Using 'CSV To List Mapping' Step
Training Video:
Dynamic Excel Creation