--- title: "CSV To List Mapping Step" slug: "csv-list-mapping-step" updated: 2025-07-09T14:02:05Z published: 2025-07-09T14:02:05Z canonical: "documentation.decisions.com/csv-list-mapping-step" --- > ## 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. # CSV To List Mapping Step | ## Step Details | | --- | | **Introduced in Version** | --- | | **Last Modified in Version** | 8.10.0 | | **Location** | Data > Excel & CSV | The CSV to List mapping component takes an Excel or CSV file and outputs a defined Decisions type. The step includes a custom mapping editor where the input fields can be mapped into the type. The step can only map in 99 data rows. --- ## Properties #### Inputs | Property | Description | Data Type | | --- | --- | --- | | File Input | The CSV or Excel file that is used as input. | FileData | #### Input Data | 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 Index | Determines which worksheet that will be evaluated. | Int32 | | Ignore First Line | If the file has a header row, this property can be toggled to ignore it. | 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. | --- | #### Outputs | Property | Description | Data Type | | --- | --- | --- | | OUTPUTS | List of the Object that the CSV was mapped to. | List of --- | #### Output Data | Property | Description | Data Type | | --- | --- | --- | | Output Type | The desired Data Structure to map the CSV values to. | --- | ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h19_00.png) ## ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h20_05.png) ## Example The following example will take a CSV file and convert the data to a list of strings to display on a Form. Before proceeding with the example, download the following CSV file; this file will be imported and mapped via the CSV To List Mapping step. [Import CSV Sheet For List Mapping - Test Data - Sheet1 (1).csv](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/Import%20CSV%20Sheet%20For%20List%20Mapping%20-%20Test%20Data%20-%20Sheet1%20(1).csv) 1. From a Designer Project, click CREATE FLOW on the **Global** **Action** **Bar**; select **Flow**, provide a **Name**, then click CREATE. 2. From the Flow Designer, attach a **Create** **Data** step from the FAVORITE STEPS category of the **Toolbox** panel, to the **Start** step. On the **Properties** panel, click SHOW EDITOR. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h20_57.png) 3. From the **Data** **Definitions** window, enter "File" under NAME and select **FileData** from the TYPE dropdown. Click the pencil icon under INPUT and **Constant** map the **CSV** file by selecting CHOOSE FILE. Click **Save** and close the Data Definition window.  ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h21_30.png) 4. From the **DATA > EXCEL & CSV** category of the Toolbox, attach a **CSV To List Mapping** step to the Create Data step. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h22_47.png) 5. From the Properties panel, click **Unknown** next to the **Input File** field and select **Select From Flow**. Select **File** and click DONE. For the **Output** Type field, select **String. For** the **Input** **File** **Type** dropdown, select **CSV**. Click **Show Item Mapping Editor**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h24_58.png) 6. From the **Mapping** **Editor**, set the mapping **ITEM** to **Merge** **Plain** **Text**, then click **Show** **Editor.** ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h26_04.png) 7. In the Text Editor, configure the message to read "First Name: [_INPUT.Field01.TextValue] Last Name: [_INPUT.Field02.TextValue] Email Address [_INPUT.Field03.TextValue]" by selecting the plus sign icon under the fields under _INPUT category from under DATA. Click SAVE and then OK. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h27_44.png) 8. Back in the Flow Designer, attach a **Show** **Form** step from the FAVORITE STEPS category to the CSV To List Mapping step. From the Show Form step's Properties, click PICK OR CREATE FORM. then CREATE a new **Form**. 9. From the **Form** **Designer**, design a **Form** using a **List** **Box** component from the DATA category of the Toolbox, and a "Done" **Button**. 10. Select the List Box on the Form to navigate to its Properties; provide a **List Items Data Name,** select **String [Text]** from the Type dropdown, then select SingleSelect from the Output Type menu. **Save** and close the Form. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h29_32.png) 11. From the Flow Designer, connect the Show Form step to the **End** step. On the Properties panel, map OUTPUTS to **List** and set **List** **Display** to **Ignore**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h30_28.png) 12. Save the Flow, then if desired close the Flow Designer. --- ## Debug 1. Click **Debug** from the top action bar. 2. Click START DEBUGGING. When the Flow runs, the Form will open and display the data from the file according to how it was mapped via the CSV To List Mapping step. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-07-01_11h30_57.png) Related Information Forum Posts: [Using 'CSV To List Mapping' Step](https://community.decisions.com/discussion/205/using-csv-to-list-mapping-step) Training Video: [Dynamic Excel Creation](https://www.youtube.com/watch?v=hcIiRwi_8wo)