Fields for Manually-Uploaded Student Accounts
Overview
This table lists the required and optional fields for creating or modifying student accounts through myLexia’s Manual Import function. With manual import, administrators can upload spreadsheets on an as needed basis.
For more information, see Guidelines for Manually Importing Students and Staff.
Column Heading | Column Description | Character Limit |
First Name (Required) | Student’s first name. The first name may contain letters, numbers, underscores, periods, apostrophes, dashes, and spaces. | 50 |
Last Name (Required) | Student’s last name. The last name may contain letters, numbers, underscores, periods, apostrophes, dashes, and spaces. | 50 |
Username (Required) | Each student’s username must be unique within your school or district.
| 4-255 |
Password (Required) | Student passwords can only contain letters, numbers, and underscores. Passwords are case-sensitive (i.e., a student with a password of “READ” cannot log in with “read”). | 4-50 |
Grade (US only) (Required) | The student’s grade. It must be entered as follows: PRE-K, K, 1, 2, 3, 4, 5, 6, 7, 8, 9,10,11,12, Graduate, OTHER | na |
Year (UK only) (Required) | The student’s year. It must be entered as follows: Nursery, R, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, Post 16/Adult, OTHER | na |
Class (Optional) | Assign the student to a class or classes by entering the class name(s). You can place the student in an existing class or create a new class. Please note that classes in the class column will replace the student’s current classes, rather than adding to them.
*Class names are not case-sensitive. **Class names should be separated by a comma and with no space after the comma. | 40 |
School (Required) | Assign the student to a school by entering the school name. To place the student in an existing school, make sure the school name is spelled identically to how it appears in myLexia, otherwise you will create a new school in myLexia (if you are a District Admin), or you will receive an error that you have entered an invalid school name (if you are a School Admin). | 50 |
Lexia ID (Displayed in export) | The Lexia ID column displays if you export student data from myLexia. It is not visible in myLexia, or editable—that is, you can not change a Lexia ID with an import. | None |
MI (Optional) | Student’s middle initial. Only the first letter will be accepted. | 1 |
Suffix (Optional) | Use this field to add suffixes like Jr., Sr., III. | 10 |
Date of Birth (Optional*) | Acceptable formats for US: mm/dd/yyyy Acceptable formats for UK: dd/mm/yyyy Months and days may be 1 or 2 digits; years may be 2 digits | na |
Gender** (Optional*) | You may specify: M or F for Male or Female, or X for Non-binary/Other. | na |
Race (Optional*) | Use the following values to indicate the student’s race: 0998 or 998 American Indian or Alaska Native 0999 or 999 Asian 1000 Black or African American 1001 Native Hawaiian or Other Pacific Islander 1002 White 5000 Other 5001 Multiracial | na |
HispanicLatino (Optional*) | Use Yes or Y to indicate that a student is Hispanic/Latino. Use No or N to indicate no. | na |
IDEA (Optional*) | Use Yes or Y to indicate that a student is receiving IDEA services. Use No or N to indicate no. | na |
ELL (Optional*) | Use Yes or Y to indicate that a student is designated as an English Language Learner. Use No or N to indicate no. | na |
Title1 (Optional*) | Use Yes or Y to indicate that a student is receiving Title 1 services. Use No or N to indicate no. | na |
State ID (Optional) | Indicate the student’s State ID. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student State ID information). | 50 |
SIS ID (Optional) | Indicate the student’s SIS (student information system) ID. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student SIS ID information). | 50 |
Student Number (Optional) | Indicate the student number. Note that this field only displays in myLexia if a customer setting is enabled (Settings > Security Settings > Allow student number information). | 50 |
*Student demographic data is only permitted to be imported into myLexia if the “Allow student demographics” setting is enabled.
**Both Gender and the previous column heading, Sex, are supported.