Step 1
Start with a blank Excel or Google Sheets file.
Step 2
Label your Column Headers as such:
First Name (cell A1)
Last Name (cell B1)
Email (cell C1)
Phone (cell D1) - Phone is optional, however, you must keep the column in your spreadsheet & left blank if phone number is not present
Start Date (cell E1) - Start date is optional, but you do not need to keep this column in your spreadsheet
Step 3
Input your data per the above organization. Your file should look like the below. Keep in mind:
Don't include extra spaces, hyphens, or parentheses in names or email addresses
Phone numbers need to be in the following format: 1XXXXXXXXXX
Example 1:
Example 2:
Example 3:
Example 4:
Be sure to segment your candidates into different tabs within your spreadsheet based on cohort. You may only have one cohort within your program, in which case candidates can remain in the same tab. However, if you have cohorts segmented by location, business unit, etc. - you must separate candidates into different tabs.
Example:
Step 4
Double check all your data meets the above criteria.
Step 5
Save and download your file as a Comma Separated Values (.csv) file. Be sure to download each tab as it's own .csv file, if applicable.
Step 6
You're ready to upload your candidate data into Abode! Head to the Program or Cohort tabs to upload your candidates!
Download This Excel Spreadsheet To Get Started:
Please Note: This is just an example of what your CSV could look like. Your CSV file may look different depending on your particular use case and program/cohort setup.