How do I add and update classes (spreadsheet method)?

You can create new classes and rearrange existing classes at the same time by uploading a spreadsheet. These instructions can also be used to change student login details.

 

If you only have a few new students you need to add or move, you may instead want to update your classes manually. For instructions on updating your classes manually, click here.

 

Note: It is important to ensure that the names in your spreadsheet exactly match the names already in the system for any existing students. Otherwise, the system will take these as separate user accounts and create a duplicate account for the student.

You can generate a spreadsheet of the students already on Sumdog by going into the Student Logins box on your dashboard and clicking 'Export Spreadsheet'.  Click here for full instructions.

Prepare your spreadsheet for upload

  1. The spreadsheet must include at least four columns:
    1. Column A: Student's first name
    2. Column B: Student's last name
    3. Column C: Student's grade/year level
    4. Column D: Name of the class the student should be placed in

      Here is an example of a spreadsheet with the minimum amount of information required: 

      Screenshot 2023-07-05 114807
  2. In addition to the information above, you can include additional columns to modify your students' login details or to create custom usernames and passwords. Follow the same structure as for columns A-D, but add the optional columns:
    1. Column E: Student's username
    2. Column F: Student's password

Important tips:

  • Do not include any headings in the spreadsheet. Ensure that the first row of the spreadsheet contains student data you wish to upload.
  • Make sure the names on the spreadsheet match the names on Sumdog. The system will only match a student listed on the spreadsheet to their existing Sumdog account if the names match exactly. 

How to create, rearrange, and/or edit classes using your spreadsheet

  1. Go into Settings from your dashboard
  2. Click 'manage' in the Manage Students box
  3. Click 'upload student data' near the top right of the page

    upload student data button

  4. You can either paste the date ('paste students') or upload a spreadsheet ('import students'). If you select 'paste students', you will need to paste the data from the spreadsheet into the box. The remaining steps will be same as if you were uploading the spreadsheet. If you select 'import students', you will need to select a file to upload from your computer. 

    spreadsheet options

  5. After pasting or selecting your spreadsheet, you need to confirm what you would like to do with the data. To create or rearrange classes, choose the second option. To change student login details and create or rearrange classes, choose the third option. Click 'next'
  6. If there are students in your school who have never signed in and whose accounts were created over six months ago, the next page will ask if you wish to remove those accounts. If you are uncertain, click 'No, do not delete any students'. Click 'next'
  7. On this page, you will be asked to confirm the data in each column. Click on the dropdown menu at the top of each column to confirm which date type is shown in each field. Click 'next'
  8. Optional: If there is more than one student with the same name in the spreadsheet or system, you need to confirm which account in the system the student belongs to (if any).
    1. Example: Two students have been uploaded with the same name from a spreadsheet. The system asks which existing account belongs to the student.
      If both students are new, select ‘new student’ from the dropdown menu for both of them. If one of the students has an existing account, select the matching account from the dropdown list.
  9. Click ‘next
  10. You will now be shown a preview of the upload so you can see which accounts will be created and which accounts will be changed. If everything looks correct, click 'save students'
  11. The final page will show you a summary of how many accounts have been created and how many existing students were moved to a new class. Click 'done'.

Tip: If your spreadsheet has a large number of students/classes, we recommend uploading only a few classes at a time