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.
Add a new column into your spreadsheet, and use “Name” as its header.
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.
Drag your formula fill handle to apply it to all cells in the Name column.
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.