Lusk

Joining Spreadsheet Columns

In some cases, you might want to use an existing spreadsheet to import candidates into Lusk, but your data might not fit exactly to the format that Lusk requires.

A common issue is having names separated into “First Name” and “Last Name” (Lusk requires a single column called “Name”) or telephone numbers in columns such as “Home” and “Mobile” (Lusk requires a single column called “Phone”, where multiple entries are separated by a semicolon).

Although it is possible to convert the file manually, for a high number of candidates this would be extremely tedious. Luckily all spreadsheet editing programs (Excel, Google Docs, etc…) support joining data using the “&” operator (called the concatenation operator).

If we take the scenario in which you need to join “First Name” and “Last Name” into a single “Name” column, this is how you proceed:

  • Open your file.Google Docs file

  • Add a new column into your spreadsheet, and use “Name” as its header.Add New Column

  • Write =B2 & " " & C2 into the A2 cell. This takes the value from B2, joins it (using the & ) with a space (" ") and then joins that (again, using &) with the value of cell C2. You might have to adjust the cell identifiers (B2, C2) to fit your exact spreadsheet structure.Concatenate formula

  • Drag your formula fill handle to apply it to all cells in the Name column.Fill Handle

  • Export your file to CSV. See Candidate File Import guide for more information on export options.

  • Import your CSV file. Note that Lusk will notice that you have extra columns in the file (“First Name” and “Last Name”) and warn you about them. In this particular case this is intended and so the warning can be safely ignored.

Learn more

Ta-Dah!

Now check your email to activate your account and start hiring the right people faster.

For tips and tricks to win the recruiting race, go forth and follow us on social media:

  • Facebook page
  • Medium publication
  • Twitter profile
  • LinkedIn profile

Great. Your demo request has been sent!

An email has been sent to your address. We'll be in touch with you shortly. Looking forward to meeting you!

For tips and tricks to win the recruiting race, go forth and follow us on social media:

  • Facebook page
  • Medium publication
  • Twitter profile
  • LinkedIn profile