Import Instructions and Troubleshooting
The information on this page applies only to school administrators who have ordered an online or paper In-School CLT10 or CLT. It does not pertain to CLT3-8 exams or to individually-purchased remotely-proctored CLT exams.
Ordering vs. Importing
- Ordering: Scheduling your school's test date with CLT. Orders must be placed prior to the order deadline for each test.
- Importing: Uploading your students’ information into your school administrator portal. This is what creates student registrations. Students must be imported prior to the import deadline for each test.
If you have not yet placed an order for a test date, please do not import students for that test date. See here for a full list of test dates and deadlines (for student imports, accommodations applications, etc.)
If you follow the importing instructions below, you will avoid most issues! If you do encounter any problems, please contact schoolsupport@cltexam.com. Outside of test days, our standard office hours are M-F, 9 AM - 5 PM ET.
Step 1: Log In
Log in to your CLT school administrator account. You may need to reset your password! If you have any difficulty, or if you need to add an additional administrator account for your school, please contact schoolsupport@cltexam.com.
Step 2: Download the Template File
Navigate to the Student Import tab at the top left of your screen.
Next, click the Template File button near the middle of the page. We recommend you download the file and paste all your student information into it. This will help reduce the chance of formatting errors, which can prevent uploads.
Step 3: Complete your Spreadsheet
Using the template file, fill out all rows in columns A - D, one row per student.
- Include all the students who will be taking the exam on the test date for which you are registering, even those who already have CLT accounts.
- Each row of the spreadsheet must contain the following information:
Column A: username - A unique email address/username.
Column B: password - A secure password. Please see the tab below for more detailed password criteria
Column C: firstname - The student’s full, legal first name.
Column D: lastname - The student’s full, legal last name.
Column E: gradYear - An optional graduation year for the student.
Column F: optionalStudentId - An optional school-specific ID.
.png)
Your sheet should look like this:
Once you have completed your registration spreadsheet, save it in a secure location for future reference, in order to have students’ usernames and passwords for test day. This can double as your "student roster", which you should provide to your proctors on test day to help resolve any potential login issues.
Ensure that no students can access this spreadsheet. You will need to send this information to proctors so that they may assist with login on test day.
Each student's CLT username must be unique to that student. You cannot reuse a graduated student's email address. We highly recommend that you use an actual email address at which the student can receive emails, as that makes password resets much easier.
- If the student already has a CLT account, use that username.
- If they do not, we recommend using a school or personal email. This can be a parent's email if the student does not have their own.
Watch out for re-used usernames:
Do not use an email that is already in use as a CLT username for someone else. Common examples of this would be a sibling's, proctor's, or school administrator's CLT account. Using the same username for multiple students may result in multiple students testing under the same account or issues accessing the exam on test day as registrations are sorted out.
TIP: If the email is already in use but is a Gmail account, you may use the +1 trick. There can be one account under parent.email@gmail.com and another under parent.email+1@gmail.com (or +2, +Johnny, etc.). Any emails addressed to the "+" account will be automatically rerouted to the actual account.
Passwords must be a minimum of 8 characters and contain at least 3 of the following:
- Lower-case letters (a-z)
- Upper-case letters (A-Z)
- Numbers (0-9)
- Special characters (e.g., !@#$%^&*)
Passwords may change if students reset their passwords from the login page.
To ensure account security, we strongly recommend that school administrators set a unique password for every student. We suggest using a password generator, such as Lastpass.com, if students do not have pre-existing account passwords.
NOTE: The import will not overwrite passwords for existing student accounts; such students will retain their existing passwords. For such students, just enter “N/A” in the password column of the spreadsheet.
Step 4: Import Your Spreadsheet
From the Student Import page of your administrator account, click “Choose File,” and select your spreadsheet.
1. Select your Test Mode, select your Test Type and select your Test Date.NOTE: If you are registering students for multiple test dates, be sure to import a separate spreadsheet for each test date.
.png)
2. Click “Preview File” to ensure no errors occurred.
This will show all the student information as it will appear. Be sure the first and last name are in the correct columns.
A "Process complete" message should appear along with a table showing the import status of each student.
Click the column headings in the table (such as "Priority" and "User Import Result") to sort the results and check the status messages to ensure that all your students were properly registered.
What should I do if I see the following:
This does not indicate an error, this just means that your import registered the student without changing the password. The student’s password will be the one that was set when the account was first created, or upon subsequent resets. See Troubleshooting if you have more questions.
Viewing your Registrations
To view your current registrations, click the Registrations tab on the left sidebar and select the test date. Compare that list with the spreadsheet you imported to make sure all students were registered.
If you need to register additional students for the test date, import a second spreadsheet containing the information of only those additional students.
If any error messages occur and you are unable to resolve them using the troubleshooting steps listed below, please take a screenshot and email it and your import file to schoolsupport@cltexam.com. This will help us diagnose and solve your issue as quickly as possible!
Step 5: Archive your Spreadsheet
Your spreadsheet is your permanent record of your students’ usernames and passwords. CLT does not have access to your student’s passwords. We can help you reset your password, or change a username, but the best practice is to maintain a well-organized archive of your students’ login information.
In case your import fails, you may get either a red error message or a spinning white wheel inside the blue button. See examples of both below:
.png)
Please check for the following list of common issues before reaching out to our school support team. Copy - pasting the import spreadsheet is the best way to avoid many common issues.
- File Format:
The file needs to be saved as a .csv or .xlsx file. If it is not either, the upload will not work. - Column Header Errors:
The column headers need to match the Example File exactly. There can be no capitalization or spaces between words. Watch for white space at the end of the words! - Formulas:
If you have used formulas to input information, the upload will not work. You can copy paste the content from a different sheet if you need to! - Email Format:
The email addresses must all be in valid email address format. Make sure there is an @ symbol in each address and the .com/.net is included. Correct example: teststudent@gmail.com
- Duplicate Students:
Make sure you have each student only listed one time. A duplicate student will produce an error on that registration. - Duplicate Registrations:
Students may not be registered for both the in-school and remotely-proctored test on the same test date. If a student registered for the remotely-proctored test is later registered for the in-school test, their remotely-proctored registration will be overridden. - Inadequate Passwords:
The passwords need to meet our password requirements. Please see here for the password requirements. Remember: Inputting a new password will not overwrite the current password. - Still stuck?
If you have tried all troubleshooting steps and are still unable to import, please contact our team at schoolsupport@cltexam.com.
How do I locate old/forgotten student usernames?
Please keep your old import sheets in a single location for reference, or keep a master spreadsheet of all of your students’ usernames.
To search in your admin records, first navigate to the Registrations tab at the top left of the page to view a list of all your existing CLT test-takers. You can search by first and/or last name. You can expand the list if necessary using the dropdown button at the top left of the table.
How do I reset a student password?
You can reset a student password any of the following 3 ways:
1. The student can reset it themselves by going to cltexam.com and using the forgot password feature.
2. An administrator can reset their student's password via the Registrations page on their administrator dashboard (this option only exists if the student's account was created via an upload by an admin from that school).
3. An administrator can email schoolsupport@cltexam.com and request that CLT reset a student's password.
For bulk password resets, you can send a .csv file with the student usernames and desired passwords, and CLT will update them for you. Please see the video below for more information.
What happens to old passwords when I import a student for a new test?
If a student already has an account, importing the same email will not create a new account. Instead, it will simply register that student for the test in question. It will not change the previous password, even if you include a new password in the Password field.
How do I change a student’s username/email or name?
Please email schoolsupport@cltexam.com with a request. If there are multiple students, please include a .csv or .xlsx file with First Name, Last Name, School, Old/Existing Username, and New Username. Do the same with incorrect or swapped first and last names.
Can I request a merge if a student has multiple accounts?
It depends! If a student has a personal account and a school account, the student must contact CLT to request the merge themselves. If they have multiple school accounts due to typos, those can be merged upon an administrator's request. The administrator will need to provide the email addresses for all relevant accounts and the student's name.
How can I add additional students to my test registration?
If you realize after your initial import that you need to include more students, you can add them by importing a .csv file just like you did with the initial registration. This is the process no matter the number of students being added. You do not need to include your already-uploaded students on that new spreadsheet, but it won't cause duplicates if you do include them. If you need assistance, please reach out to schoolsupport@cltexam.com.
How do I remove a student from my registration?
Click on the Registrations tab on the left sidebar and select a test date to view all students registered. To cancel a student’s registration, click on the green checkmark in the Reg Status column. Once canceled, the green checkmark will change to a red x.
If I import my students and then notice an error, what do I do?
If, after importing your students, you notice that some are missing entirely, lack complete information, have typos in their username or legal name, or the name of another student appears on the roster, please reach out to schoolsupport@cltexam.com.
Importing your roster multiple times will not update the information for your registered students.
Where can I find my student roster?
You can access your roster in your administrator dashboard. Navigate to Registrations and pick the test from the drop down at the top right. Click on Download Active Roster to download a .csv of the student data displayed on the screen.
Note: this roster does not contain student passwords. Your testing coordinator will need to maintain a record of the passwords that they created via their import file.
What is an Optional School ID?
Schools often have internal identification numbers associated with their students in their own student management systems. This field allows administrators to associate that number with the students’ CLT registrations so that they can easily look up the data using their internal school id.
When should students be imported?
Import deadlines can be found in the School Dates and Deadlines Document. Reminder emails will also be sent to your school’s point of contact.
Thanks for choosing CLT! If you have any questions after reading this page, please contact us at schoolsupport@cltexam.com.
