Instructions for Filling out the Custom Profile Field Template

1. Download the "Customer", "Student" or "Employee" Custom Field Values Template and open it in a spreadsheet program such as Excel.
2. The first row contains headings to identify each column. Do not modify this row otherwise the upload will not work.
3. The second row displays the valid values for fields that have options specified.
   
   NOTE: The "First Name", "Last Name" and "Email" columns must match corresponding fields on corresponding profile in order to update the custom field values.
4. The Columns available in the file are as follows:
   • First Name - Enter the Customer, Student or Employee's First name.
   • Last Name - Enter the Customer, Student or Employee's Last name.
   • Email - Enter the Customer, Student or Employee's email address.
   • Custom Profile Fields - The remaining columns on the Excel file will consist of all the custom profile fields you've created, based on the user type (i.e. the Customer custom profile field template will display the customer custom profile fields, the Student custom profile field template will display the student custom profile fields, etc).
5. Complete a couple rows and try uploading the file to make sure that your formatting is correct.
6. Once you've confirmed that you are filling out the template correctly, you can add the rest of your records and upload the file.

NOTE: Some spreadsheet programs will automatically change the format of columns, such as changing email addresses to a hyperlink or integers into decimals. To ensure the email column is in "text" format, follow these steps:

1. Select the column.
2. Right click the selected cells.
3. Click the "Format Cells" option.
4. Select "Text" as the content type.