Audience: Administrators with school and district subscriptions
⚠️ If you are experiencing specific issues with uploading your CSV, please note that the Data Errors and Warnings that appear once you’ve uploaded your CSV include a detailed report of what the issue is.
Note: Data Errors will prevent data from uploading. Data Warnings will allow data to upload. Please ensure you are comfortable with the changes that Data Warnings will permit before you complete your import.
Some common issues can be grouped into a few categories, as listed below.
-
Most of the fields in our Template are required. If any of this data is missing, you will receive an error. The required fields are:
- Teacher Email, Teacher First Name, Teacher Last Name, Class Name, Grade Level, Sign In Mode, Student Name, and Student ID.
- The CSV headers must remain unchanged and must not be edited. Please ensure you do not alter the header in any way (they are case-sensitive!).
- Please ensure you are following the formatting guidelines listed in the document. Note that if you enter the Grade Level in a format other than K, 1, 2, etc., it will upload as the Grade Level ‘Other’. This will also happen if you enter multiple different Grade Levels for one Class.
- Please note that if the Sign-In Mode for a class is set to Google, you must include an email address for each student in the class. If the Sign-In Mode is set to Email, you must include both an email address and password for each student in the class.
-
Unique Student IDs must be used when uploading a CSV roster spreadsheet. If you have multiple students listed with the same Student ID on the template and their names or email addresses do not match, you will receive an error message.
- Please note that there is no issue with uploading a CSV where the same student is being enrolled in multiple classes as long as the same information is listed for the student each time (student name, email address, and Student ID).
- Ensure that you are not reusing Student IDs or email addresses that are already attached to other students on the School Dashboard. Reusing Student IDs or email addresses will result in changes being made to your existing student accounts. If you haven’t already completed the end of year steps prior to rostering the new classes, please refer to the directions HERE.
- Teachers not associated with the school where you are uploading your CSV. Please note that you should add teachers to the Dashboard before uploading your CSV Roster.
- Typos happen! Please make sure to review the classes once you have uploaded the CSV and when prompted to review changes. Any typos in Teacher Name, Class Name or Student ID/Email may result in duplicated classes or accounts being created.
- Uploading to the wrong tool will also result in an error. Please ensure that you are uploading the Google Sheets Template or the Microsoft Excel Template to the ‘Add NEW classes’ option within the Import & Edit Class Rosters tool.
- If you need to edit any EXISTING classes in the case of midyear roster changes, please refer to our Bulk Edit tool.
Issue: import errors occur when trying to create classes, resulting in the creation of empty or partially created classes or student accounts.
Error: The class is created with no students or teachers connected to it.
Cause: Weak passwords or password requirements not followed.
Resolution: Review password requirements, reset the dashboard, and delete the empty classes.
For more information on CSV Rostering:
-
How to import class rosters
- Rostering with CSV FAQs
- Transitioning from Clever/Classlink to CSV Rostering
- How to use the CSV Bulk Edit tool (for updating existing classes midyear)