Skip to main content
All CollectionsAdministratorsStudent Account Management
Importing Students from CSV as Administrators
Importing Students from CSV as Administrators

Import and populate school rosters from a CSV file

Jeremy Brown avatar
Written by Jeremy Brown
Updated today

The following instructions will apply to CSV files used to manage users in all four of our products:

  • Gizmos

  • Frax

  • Reflex

  • Science4Us

To import students, you will need a comma-delimited (CSV) file. You can find a sample CSV file when you log into your Administrator account. Many student information systems and spreadsheet applications can export data in this format.

Preparing Your CSV File for Import

The first row of the file should contain the column names; the subsequent rows contain the student information that match the column names.

  • Required column names: FirstName, LastName, StudentID, and GradeLevel

  • Optional column names: MiddleName, Language, Password, Gender, LimitedEnglishProficiency, Ethnicity, EconomicallyDisadvantaged, and SpecialEdStatus

All student IDs must be unique. We recommend using the district-provided student ID to promote consistency across all schools and classes within a district.

For the LimitedEnglishProficiency, EconomicallyDisadvantaged, and SpecialEdStatus columns, the required data is: Yes or No.

Ethnicity is indicated by a code number: 11 (Hispanic/Latino), 12 (American Indian/Alaska Native), 13 (Asian), 14 (Black/African American), 15 (Native Hawaiian, Other Pacific Islander), 16 (White), 17 (Two or more races), and is optional.

You can download a sample CSV file to get you started by following the first three importing your CSV file steps below, then downloading the Sample CSV File. Open the file, delete the sample student data and replace it with your own data. Once complete, save the file as a CSV file. Please see the image below on where to find this template and formatting instructions.
​

Once your file is ready, log in to your account:

Creating Student Accounts Using a CSV File:

1. Select the school from the drop down menu at the top of the page, if needed.
2. After creating your .CSV file, select Manage Users.

3. In the Students tab, select Import Students at the bottom left of the page.
4. Drag and drop or click to select the completed .CSV file.
5. Review the changes and, if correct, select Import.
6. The students will then appear in a list from which teachers can choose to add to classes.
​

*Please note, If you are viewing your CSV in Excel and your studentIDs include leading zeros, Excel may remove them.

*Please note, student names cannot exceed 30 characters in their first or last name. Doing so will result in an import fail.

*Please delete unused columns, while there are only 4 required columns, blank columns can cause errors.
​
​Suggested Articles:

Did this answer your question?