SMART Response

You are here: Getting started > Creating a class list > Importing a list from Excel

Importing a class list from Excel

Important 

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 SMART Response class list. You might find it easier to copy the list of names in your current Excel document into a new spreadsheet.

To create a class list in an 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. Type ID Number in the first cell (A1).

  4. Type First Name in the first cell of the second column (B1).

  5. Type Last Name in the first cell of the third column (C1).

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

  7. In column A, type a unique ID number of 1 to 15 digits for each student.

  8. Save the spreadsheet.

To import a class list from an Excel spreadsheet

  1. Start Teacher Tools. See Starting Teacher Tools.

    Teacher Tools appears.

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

  3. 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.

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

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

    The Import dialog box appears.

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

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

  8. 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 the spreadsheet appear in the Students page. You can now edit each student's properties, as required.