Skip navigation, view page content
Carmen Login | Carmen Info | Request Help

Grades: Import into Grades from CSV

The import format for grades is .csv (comma separated values).

Only Numeric, Pass/Fail, Selectbox, and Text grade items, and the Final Adjusted Grade can be imported.  Attempting to import other types of grade items will result in errors.

1. Prepare a .csv grades file for import.

Export your gradebook to .csv to obtain an example/template of the .csv format -- even if your gradebook is empty, the correct column headers will be created. (See Export to CSV from Grades for details.)

When importing grades, you can have columns for Points grade (or the equivalent information for Pass/Fail, Selectbox or Text items), Weighted grade, and/or Grade Scheme. Only the data in the Points or equivalent column will actually be imported. 

2. Access the Gradebook, click on Enter Grades Enter Grades in the Menu, and click Import Grades Import Grades in the toolbar.

3. Click Browse and select your .csv file.

The headings for new grade items in your spreadsheet must be properly formatted.  Refer to headings from your exported template to determine the necessary information and format.

4. Click Import to begin processing the file. A status message labeled Errors and Warnings Found appears:

Importing large classes (e.g. 200 users and 50 items) may take some time.

5. When the import is complete, review your Student List to confirm the changes have been applied.