MC Logo

 Monmouth College Information Services

Home - Information Services - Get Help - How-to-Guides - WebAdvisor - Class Lists - Import a Class List into Excel

Import a Class List into Excel

  1. On a campus computer, type This PC in the search box on the task bar.

    Search box
  2. Select This PC from the search results.
  3. Under Network locations, double-click the W: drive.

    W Drive
  4. Go to Apps > MCUtil > ClassLists.
  5. Right-click on your class list, select Copy, and paste the file on your desktop.
  6. Open Excel.
  7. On the File tab, click Open.
  8. On the Open window, select All Files across from the File name field.

    All Files
  9. Select your class list .txt file.
  10. Click Next on the Text Import Wizard window.
  11. Make sure that Delimited is selected.

    Delimited Button
  12. Click Next.
  13. Uncheck Tab and select Comma.

    Comma Checkbox
  14. Click Next.
  15. Click Finish.
  16. Save the Excel file.