---
title: "Splitting Excel Columns by a Custom Delimiter"
slug: "splitting-excel-columns-by-a-custom-delimiter"
description: "Learn how to use the Split Excel Column component in a Decisions Flow to separate delimiter-based values into multiple columns for a Data Grid or CSV file."
tags: ["delimiter", "excel", "csv"]
updated: 2026-05-14T20:00:08Z
published: 2026-05-14T20:00:08Z
canonical: "documentation.decisions.com/splitting-excel-columns-by-a-custom-delimiter"
---

> ## 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/image-1778686111006.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/image-1778686343633.png)
6. Click **Save** to save the Flow.

---

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