The Split Columns tool enables you to break apart a piece of text using a “marker” (delimiter) - like how you might cut a piece of paper where you see dotted lines.

The Split Columns tool can be highly customized. You can choose your delimiter, if you want to split to rows or columns, how many columns/splits you want and whether you want to split from left-to-right or right-to-left.

The Split Columns tool is very similar to the Text to Columns function in Excel

​
Configuration

The Split Columns tool consists of three required input and two optional input.

1

Select Column to Split

Select the column you want to split.

2

Input Delimiter

Input the delimiter by which you want to split.

3

Select How to Split

Select if you want to split to rows or columns.

4

Additional Settings: Maximum Columns to Create

This is an optional input. Select how many split you maximum want to create. This can be helpful if you data structure is not consistent and you want a particularly part of the content split.

5

Additional Settings: Select Split Direction

This is an optional input. Select the direction to want to split - you can choose left-to-right or right-to-left.

Defaults to left-to-right.

​
When To Use

The Split Columns tool is helpful when you have data the is aggregated into a single cell and split by a delimiter:

  • Splitting a full Name to First/Last Name
  • Separating a full address into subparts (street, street number, city, postcode, country)
  • Splitting a purchase’ product categories to rows

​
Examples