School Staff members can upload students' and parent/guardians' information into the School Directory on SchoolStatus Connect by copying their data following a standard format using a spreadsheet.
Note: We recommend archiving all students before uploading the new roster. Please follow the instructions from this help article to archive all students.
If you are uploading on the Classroom level, please click here.
Spreadsheet Format
Please remember that all headers/column titles must be followed and copied for this process to work.
Student Columns
Required Fields: student first name and student last name
Parent/guardian Columns
Required Fields: guardian 1 email OR guardian 1 phone. Must have at least one or both.
Note: If you want to put the parents' names, they MUST have both first and last names. Otherwise, leave them all blank.
You can see the list of Language codes here and the acceptable Grade-level codes in the table below.
You can upload up to TWO parents/guardians per student at a time using the Copy from a Spreadsheet method. Add another set of columns for the second parent/guardian as shown in the sample photo below. The same conditions as the first parent/guardian columns have to be met.
You can use this sample spreadsheet as a template.
Note: Phone numbers from the Guardian 1 field are saved as a user’s mobile phone number. This means that this number is used for a user’s login method, and is their communication method for SMS and phone calls.
Phone numbers from the Guardian home 1 phone field are saved as user’s Home Phone Number, meaning they are not used for communications or login.
Copying the Data from the Spreadsheet
1. Click the context drop-down
2. Go to the School/ Classroom
3. Click the Directory tab
4. Click the add button on the upper-right
5. Choose Copy From a Spreadsheet button below
6. Copy the data from your spreadsheet
7. Right-click on the Paste Here section and click Paste
8. Review the roster data and, if everything is correct, click Import
Note: You may get errors when the values are invalid. If this happens, the invalid entry will be highlighted in red and brought to the top of the list. Correct the error from your spreadsheet and copy it again to proceed to the next step.
- Students who already exist in the School Directory will be detected. Decide whether to:
-
- Update student, add guardians - will add new parents/guardians that are not connected to the existing student
- Update student, replace guardians - will add new parents/guardians replacing parents/guardians that are not included in the new spreadsheet
- Create new student - will ignore the detected student and create a new one
- Skip the student - will skip and do nothing
9. Click Apply. Wait a couple of minutes. It may take a while depending on how many students and parent/guardian information you're uploading.
Note: If a parent/guardian's email or phone number from your spreadsheet already belongs to an existing SchoolStatus Connect user, we will find that user and connect them to the student. Please note that in some cases, their names may be different from what you copied from the spreadsheet.
Adding them all to the School Directory using this process doesn't enroll students in their classrooms. You will have to do that manually by following the instructions from this article.
If you end up with duplicate students, you can merge them by following the steps here.
All set! Your School Directory is now updated! 🙌
Click here to return to the main menu- or ask for help!