Split text to columns in Google Sheets
Splits the content of a cell in a given column into different columns in a sheet of a Google Sheets spreadsheet.
Common use cases
- Data Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | Link | Yes | https://docs.google.com/spreadsheets/d/1eQ | |
| Column name | Provide header name that needs to be split. | Text | Yes | Last Name |
| Split delimiter | The delimiter that will be used when splitting the data | Predefined Choice List | Yes | , |
| Google Sheets connected account | Google Sheets connected account | Connected Account | No | |
| Sheet name | First tab will be used by default. Sheet name is case sensitive | Text | No | Sheet1 |
| New column names | The names that will be used for the columns created when splitting text. Separate each name with commas. | Text (Long) | No | Employee ID, First Name |
Outputs (what you get)
- N/A
Outcomes
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the text was successfully split to columns in Google Sheets |
| Unsuccessful | This status is selected in the event of the following scenarios: - The Google Sheets spreadsheet link does not exist - The Google Sheets spreadsheet cannot be edited - The column name/letter is not provided - The Google Sheets spreadsheet cannot be modified |
Requirements
- The provided Link to the Sheet must have editing permissions.
- The Spreadsheet need to be shared with: googlewrkbots@wrk.com
How it works
- This Wrk Action will not add a new column, the split values will be placed in the next column.
- If only one column name is provided in the optional field New column names, this will be the new name of the original column, if the second column needs a new name, provide the name of the first and second column.
The split can only be done with one of the following delimiters:
| Name | Symbol |
|---|---|
| Comma | , |
| Space | \s |
| Semicolon | ; |
| Colon | : |
| Dash | - |
| Period | . |
| Underscore | _ |