Roster Staff and Classes (Spreadsheet upload)
Overview
Administrators can create and/or modify existing staff accounts in myLexia by importing comma-separated (.csv) or tab-separated (.tsv) spreadsheet files. Using the optional class column in the staff import will also allow you to create or modify classes.
You can use Manual imports to:
Create new staff accounts
Create classes and/or assign staff to classes
Modify existing classes
You can not use Manual imports to:
Delete existing staff accounts
Delete existing classes
Modify existing staff usernames, first names, last names, and middle initials
If you only need to create a handful of staff, see Create Individual Staff Accounts.
Applies to: Educators and administrators who have School Admin or District Admin access to myLexia
.
School administrators within a district can only run manual imports and exports if "Allow School Admins to run imports & exports" is enabled in the site settings (under Data Security). If you are a school administrator and do not see the Import or Export options in myLexia, talk to your myLexia district administrator for help.
Does not apply to: Educators with Teacher or Read-Only access in myLexia.
How do I prepare a staff file for manual import?
First, you’ll create a spreadsheet with staff information. You can start with a template from Lexia (linked below), or create your own file. If you export from your student information system (SIS), modify the column headers and content of your export to match Lexia’s template.
Your staff import should include the following fields: First Name, Last Name, Username, Password, Access, and School. To assign staff to classes, include a class name in the Class column.
Fields for Manually-Uploaded Staff Accounts
Make sure to save the import file as a comma-separated (.csv) or tab-separated (.tsv) file. If you try to import an Excel file (.xls or .xlsx), there will be an import error.
Import Type | Link to Template File (right-click and choose “download in new tab” |
Staff | https://www.lexialearningresources.com/cs/downloads/StaffImport.csv |
The import templates contain only the required columns and the optional Class column. You can add additional column headings for the optional fields, but they must follow the accepted format.
How do I upload my staff file to myLexia?
In myLexia, select Manage, and then Staff at the top of the page.
Select the Import button.
Select the Choose File button and find the import file on your computer. After you select the file, select the Continue button.
Select the radio buttons for "Import new staff" and/or “Import modified staff.”
Verify the number of staff, classes, and/or schools you will be creating and/or modifying upon importing.
Select Import.
The green Success screen displays the results of the import.
What if I receive an error?
To address any errors, select Download Error Report to view them. The last column in the spreadsheet, “Error,” explains the error.
For a description of each error code, and for more help troubleshooting manual import errors, see Troubleshooting manual import errors
Why don’t I see the Import or Export buttons?
You will only see the Import or Export buttons if you have permission to run imports and exports. If you are a school admin in a district account, it could be that the ability for school admins to run imports and exports is not enabled in your district. Please contact your district admin for assistance.
I don’t see an Import button - just an Export button!
The Import button is not available if you have any staff selected. If you see that staff are selected (that is, the boxes to the left of their names are checked off), uncheck the boxes to deselect them (or select the box with the minus sign next to the header “Staff Name” to deselect all staff). Once all staff have been deselected, the Import button should become available.
Do I have to include every staff in each import file?
You do not! Manual imports only add or modify—they don’t archive or delete staff accounts, so you can use incremental imports to update your staff rosters in myLexia.