CU: Import Class Roster to Excel

CU: Import Class Roster to Excel

CU: Import Class Roster to Excel

To import a class roster, you need the roster in a delimited data file (e.g. Redwood). A delimited data file is one where the fields are separated by either a symbol (e.g. comma, semi-colon, colon), tab, or some other character. 

  1. Open a blank worksheet in Excel.
  2. Under the [Data] tab, from the "Get External Data" group, click the [From Text] icon.  
  3. In the resulting "Import Text File" dialogue box, double click the delimited file you wish to import. To locate your file, you may need to select "All Files" from the drop-down menu in the lower-right corner of the box. 
  4. Click [Import]. The Text Import Wizard will open on Step 1 of 3.
  5. Select "Delimited" > click [Next >].
  6. In Text Import Wizard Step 2 box, select the character used to seperate your delimiter fields (e.g. symbol, tab) > Click [Next >] > Click [Finish].
  7. When prompted to choose where to place the data, select "Existing Worksheet" > Click [OK].
  8. When the import is complete, save your file as an Excel worksheet.

Keywords: class list, make class list, create class list, create roster, create class roster, faculty, staff

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty