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. A delimited data file is one where the fields are separated by either a symbol (like a comma), tab, or other indicator. Follow these steps to import a class roster from a delimited file (e.g., Redwood) into an Excel file:

  1. Open a blank worksheet in Excel.
  2. Choose the "Data" tab.
  3. From the "Get External Data" group, choose "From Text."
  4. An "Import Text File" box will open. Navigate to the delimited file you want to import. You may need to change "Text Files" to "All Files" in the drop-down menu to find your file.
  5. Click [Import]. The Text Import Wizard will open on Step 1 of 3.
  6. Make sure that the "Delimited" radio button is selected > Click [Next >].
  7. In Text Import Wizard Step 2 box, select the delimiter used in your data (i.e., tab, comma).
  8. Click [Next >] > Click [Finish].
  9. You will be asked where to place the data. Select "Existing Worksheet" > Click [OK].
  10. 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