Splitting Excel Columns by a Custom Delimiter

Overview

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

Example

1. From a Designer Project, select the CREATE FLOW button 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 tab, and attach a Split Excel Column step to the Start and End steps. 
3. Navigate to the Split Excel Column step's Properties tab and click Edit Input Mappings. 
4. From the Input Mapping window, set each Input to Constant mapping. Begin by mapping the desired File to the File input Then, from the File Type dropdown menu, select the corresponding Type.
5. For the Column Input, specify the number of Columns presently in the spreadsheet. Map the Delimiter character to its respective Input. 
6. 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. Then click OK. 
7. Save the Flow, then if desired close via X.