---
title: "Split Excel Column"
slug: "split-excel-columns"
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: ["excel", "csv", "delimiter"]
updated: 2025-02-21T17:18:35Z
published: 2025-02-21T17:18:35Z
canonical: "documentation.decisions.com/split-excel-columns"
---

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

# Split Excel Column

| ## Step Details |
| --- |
| **Introduced in Version** | --- |
| **Last Modified in Version** | 7.12.0 |
| **Location** | Data > Excel & CSV |

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.

---

## Properties

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| File | The CSV or Excel file to edit. | FileData |
| 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 | CSVFileType |
| Worksheet Number | Determines which worksheet that will be edited | Int32 |
| Delimiter | It determines which delimiter to split the columns at. | String |
| Column (Starts at 1) | The starting column where the values will be inserted. | Int32 |
| Number of Resulting Columns | Specify the expected number of resulting Columns after the current Columns are split. | Int32 |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| None | --- | --- |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-13_16h30_22(1).png)

Related Information

Training Video: [Dynamic Excel Creation](https://www.youtube.com/watch?v=hcIiRwi_8wo)