Editing a Class Roster File in Excel

  1. Open the Class Roster Excel file. For more information, see Downloading Class Rosters as Excel Documents

  2. Insert two columns to the far left of the spreadsheet.

  3. Label the columns Term and Class Number. Enter the Term and Class Number in the first row only.

  4. Delete the Notify column.

  5. To preserve the leading zeros in the ID column,

    1. Highlight the ID column and right-click on it.

    2. Select Format Cells. 

    3. On the Number tab, select Text. 

    4. Click OK. 

    5. Insert a Grade column after the ID column.

    6. Enter letter grades for each student.

    7. Delete all other columns. The remaining columns should be Term, Class Number, ID, and Grade. Any columns remaining to the right of the required four will be ignored during upload.

    8. Save the file with a name and a location you will remember. In the Save as Type field, scroll down to select CSV(Comma Delimited).

    9. If using a Mac,

      1. Navigate to File.

      2. Click Save As.

      3. Click CSV (Windows) in the format field.

  6. If you receive a message indicating the file may contain features that are not compatible with CSV, click Yes

  7. Make note of the name and location of the saved CSV file.

Related Articles