Excel Guides

Compiling a List of Students in a Course in Excel

Assuming you would like a list of all students in a course in an Excel spreadsheet, there are a few ways to go about this.

If the course is being offered through a school or university, the registrar's office may have a list of all students enrolled in the course that can be exported to Excel. If not, the instructor of the course may have a class roster that can be provided in Excel format.

If neither of those options are available, the following steps can be taken to compile a list of students in a course:

  1. Get the syllabus for the course from the instructor or online.
  2. On the syllabus, look for the section that lists required readings and/or assignments. For each reading and/or assignment, there will usually be an associated textbook and/or website. Go to each of these textbooks and/or websites and look for a way to contact the author and/or publisher (usually found in the "About" or "Contact" section).
  3. Once you have found a way to contact the author and/or publisher, send them an email requesting access to the online version of the textbook and/or website. In your email, explain that you are compiling a list of students in the course and need access to their contact information in order to do so.
  4. If you are able to get access to the online version of the textbook and/or website, look for a way to export the user list to Excel. If not, you will need to manually copy and paste each user's information into an Excel spreadsheet.
  5. Once you have compiled a list of all students in the course, you can then use Excel's built-in features to sort and filter the data as needed.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.