Importing a Class List from Microsoft Excel

NOTE: This feature is supported by SMART Response software for Windows operating systems only.

If you use Microsoft Excel software to maintain class lists, you can import an .xls or .xlsx file into Teacher Tools to create a class list. You may find it easier to copy the list of names in your current Excel document into a new spreadsheet.

To create a class list in a Microsoft Excel spreadsheet

  1. Open the Excel spreadsheet containing your students' names.

  2. Insert a blank row at the top of the spreadsheet if it doesn't already have one.

  3. In the first cell (A1), type ID Number.

  4. In the first cell of the second column (B1), type First Name.

  5. In the first cell of the third column (C1), type Last Name.

  6. Move the first and last names into columns B and C, directly below the headings.

  7. In column A, type a unique ID number of 1 to 15 digits for each student, and then save the spreadsheet.

To import a class list from a Microsoft Excel spreadsheet

  1. Start Teacher Tools in Gradebook view.

Teacher Tools appears.

  1. Click Add a Class in the Gradebook area on the left.

  2. Type a name for your class, add any optional details to the Class Information boxes, and then click Add.

After a short delay, the new class's window appears, and the class name appears in the Gradebook area.

  1. Click the Students tab at the top of the window.

  2. Click the Import button at the top of the window, and then select Students.

The Import dialog box appears.

  1. Select the class you want to import the student list into, and then click Next.

  2. Select Microsoft Excel from the Import from: list, and then click Next.

  3. Browse to and select the .xls or .xlsx file containing the class list, and then click Open.

After a short delay, the names and IDs from your CSV file appear in the Students page. You can now edit each student's properties, as required.