Splitting Excel Columns by a Custom Delimiter

Overview

By using the Split Excel Column step, the data in an Excel spreadsheet's column, which is separated by a delimiter, can be split into more or fewer columns and then displayed in a data grid or converted into a CSV file.

Configuration

The following example demonstrates how to configure the Split Excel Column step to separate data in an Excel file that has a delimiter.

1. From a Designer Project, click CREATE FLOW from the Global Action Bar; select Flow, provide a Name, then click CREATE.
2. From the Flow Designer, expand the DATA > EXCEL & CSV category in the Toolbox panel and attach a Split Excel Column step to the Start and End steps.
   
3. On the Properties panel, set the input fields to Constant mapping. Begin by mapping the desired File to the File input field. Then, from the File Type dropdown menu, select the corresponding Type.
4. For the Column field, specify the number of columns present in the spreadsheet. Enter the specified Delimiter character.  
5. In Number of Resulting Columns, specify the expected number of resulting Columns after the current Columns are split. Then, if relevant, provide the number of the Worksheet being split in the Worksheet Number input field.
   
6. Click Save to save the Flow.