The column actions dropdown contains operations you can take to create new columns based on the current column, or just alter the current column.

Splitting columns

Any column can be split into two new columns, based on an provided delimiter. If a cell contains multiple instances of the given delimiter, you can choose to split the cell on either the first or last instance of the delimiter.

The data types of the resulting columns will be text.

Joining columns

Any two columns can be concatenated into a new column, using a provided separator.

The data type of the resulting column will be text.

Trim

All leading and trailing spaces will be removed from text entries in a column.

Single spaces between words will not be affected.

Change case

All text entries in a column can be changed to uppercase or lowercase.

Merge and edit entries

Multiple text entries can be combined and treated as a single entry.

For example, if a column contains the entries "new york", "new york city", or "nyc", you could merge the three, resulting in any occurrence of those terms being renamed to "new york".

Merged entries will automatically take the label of the most frequently occurring entry, or can be relabeled by entering a new name for the combined entries.

Revert column changes

Any "trim", "change case", or "merge entries" operations will be reverted, returning the data in the column to the original state.

Generate geographic coordinates

Rowboat+ and Desktop users have the option to geocode their location data. Any valid locations within the column will be converted into coordinate values that can be linked and viewed on a US or World coordinate map.

Rate limits apply.