# Split Columns

<figure><img src="https://1596277999-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaSJL6Od4KuV8hrdCZbXp%2Fuploads%2FcNw1jJrN3uelDhLb581h%2Fanimation_500_labnmtjs.gif?alt=media&#x26;token=4c79287b-a934-428b-a2f1-8ac31ad1e7b7" alt=""><figcaption><p>The Split Columns Action</p></figcaption></figure>

This Action is similar to Excel's Text-to-Columns function. It can split columns from left or right to either columns (-> wide data set) or rows (-> long data set) by a delimiter (like a comma)

{% embed url="<https://www.loom.com/share/91d1a5649c024929aed2bd11b1c13167>" %}
