Split a name into columns step

This step takes a column of full names and splits each into its parts: title, first name, last name and other names, each in its own column. It is useful when scraping LinkedIn Sales Navigator and you want to address people by first name in a message; see the LinkedIn template.

You can use this step to:

  • Extract first names to personalise messages or email campaigns
  • Split names for CRM data
  • Extract first and last names from LinkedIn
  • Split names held in a Google Sheet or CSV

The Split a name into columns step with its DATA Insert Data dropdown, the Column box, and the Title, First Name, Last Name and Other Names field checkboxes, outputting the split-name-data token

How to configure the Split a name into columns step


DATA

Click Insert Data and select the data holding the names.

Column

Enter the column the names are in, as a number starting from 1 or a capital letter starting from A. Enter one value only; only the first column given is used.

Fields

Tick the parts to split each name into: Title, First Name, Last Name and Other Names. The output has one column per ticked part, in that order, as the [split-name-data] token.