---
title: "Splitting Excel Columns by a Custom Delimiter"
slug: "splitting-excel-columns-by-a-custom-delimiter"
description: "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."
tags: ["delimiter", "excel", "csv"]
updated: 2025-06-30T18:34:52Z
published: 2025-06-30T18:34:52Z
---

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

# 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.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-16_12h05_50.png)
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.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2025-06-30_14h34_00.png)
6. Click **Save**to save the Flow.

---

For more information on Flows, see [Decisions Forum](https://support.decisions.com/forum/forum3-flows.aspx).