Google Groups: Importing a class roster into a UD Google Group

Faculty have found that Google Groups present an easy-to-use and flexible method of conducting online class discussion. Unfortunately, you cannot import a class roster into a Google Group directly from UDSIS. But you can import your roster manually. The process outlined below takes about 10 minutes.

  1. Log in to UDSIS.
  2. Click Self Service.
  3. Under Faculty Center, click My Schedule and Rosters.
  4. Click the class roster icon (far left) for the class for which you are creating a Google Group.
  5. With the class roster displayed on the screen, click the spreadsheet icon to download your class roster as an Excel spreadsheet. In the screenshot below, the red arrow points to that icon:
    Spreadsheet Icon
  6. Locate the Excel file on your computer. It is usually named ps.xls. Open the file in MS Excel.

  7. Delete the header row (row 1) from the spreadsheet.
  8. Select the column of email addresses (column D). Copy the entire column of addresses.
  9. Log in to your class Google Group and navigate to the Direct add members screen. (From the main Google Groups screen, click Manage, then click Members to find Direct add members.)
  10. Paste the addresses you copied from the Excel spreadsheet into the first textbox. Write a brief welcome message in the second textbox. Select an appropriate email subscription option. Your screen will look like the one shown below:
    Direct add screen
    Click Add, then click Done.

    If you are adding non-udel.edu addresses, a captcha challenge appears after you click Add. Don't forget to click Done.