(Answer) (Category) LON-CAPA User Help : (Category) Course Management : (Category) Enrolling Users :
How do I upload a classlist from an MS Excel spreadsheet?
To upload an Excel spreadsheet into LON-CAPA you must convert the Excel spreadsheet into a Comma Separated Value file, as follows:

  1. Open the spreadsheet in Excel.

  2. Choose File | Save As...

  3. Select "CSV (Comma delimited)(*.csv)" from the "Save as type:" drop-down menu, remembering where you saved it.

  4. Click "Save".

  5. Click "Ok", or "Yes", at any windows that may appear, to create the *.csv file.

You can then upload the CSV file generated, as described in .

Other spreadsheet programs can also export CSV files. Many of them follow the same procedure as Excel does. Consult your spreadsheet program's documentation for more information.

[Append to This Answer]
Previous: (Answer) How do I drop students?
Next: (Answer) How to set the Starting Date and Ending Date for a class.
This document is: http://help.loncapa.org/cgi-bin/fom?file=186
[Search] [Appearance] [Show This Answer As Text]
This is a Faq-O-Matic 2.719.
This FAQ administered by the LON-CAPA team at MSU. Submit a help request ticket to contact us.