Learn how to get the most out of Lusk! Guides, tutorials, videos, best practices. We’ve just started, more is coming!

Lines 1Lines 2WavesDots

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:

  1. Open your file. Google Docs file

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

  3. 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

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

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

  6. 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