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:
- Get the syllabus for the course from the instructor or online.
- 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).
- 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.
- 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.
- 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.