Importing and Exporting Grades


Exporting Grades

  1. From the Navigation Bar, select Grades. Course Nav Bar with Grades selected.
  2. Select Enter Grades. Grades edit options with Enter Grades selected.
  3. Select Export. Export selected.
  4. Select the Radio Button next to the Key Field option you wish to use. NOTE: Org Defined ID will display a Banner Number.
  5. Select the Checkbox next to the Grade Values options you wish to use.
  6. Select the Checkbox(es) next to the User Details you wish to use.
  7. Select the Checkbox next to each Grade Item that you wish to export.
  8. Select Export to Excel. NOTE: This is opened a new window. Export to Excel option selected.
  9. Select the File Link to download and save the file.

Importing Grades – Preparing the File

NOTE: Grade Categories must be created within D2L. If you wish to have your grade items organized into categories, it is recommended that you create the Grade Categories prior to importing. For instructions on creating Grade Categories, please visit Creating Grade Categories and Items.

    Working from a spreadsheet file, such as Excel:
  1. Column 1: OrgDefinedID (The Student’s Banner or X Number)
  2. Column 2: Username NOTE: Files can be imported using OrgDefinedID and/or Username columns. Only one column is required.
  3. Grade Item Columns should contain the name of the item followed by:
    • For Numeric or Pass/Fail Grade Items — Points Grade (Example: Essay 1 Points Grade)
    • For Selectbox Grade Items — Grade Symbol (Example: Essay 1 Grade Symbol)
    • For Text Grade Items — Text Grade (Example: Comments Text Grade) Grade item columns.
  4. If using the Final Adjusted Grade (Not Required), the following columns should be included:
    • Adjusted Final Grade Numerator
    • Adjusted Final Grade Denominator
  5. The LAST column must be called End-of-Line Indicator and the value for each row in that column must be a hash/pound sign (#). Last column must be called End-of-Line Indicator with each row having a hash/pound sign (#).
  6. Files must be saved as .CSV or .TXT files.

NOTE: Only Numeric, Pass/Fail, Selectbox, Text grade items, and the Final Adjusted Grade can be imported. The Final Calculated Grade will automatically be updated based on the imported grade data.


Importing Grades – Uploading the File

NOTE: Only Numeric, Pass/Fail, Selectbox, Text grade items, and the Final Adjusted Grade can be imported. The Final Calculated Grade will automatically be updated based on the imported grade data.

  1. From the Navigation Bar, select Grades. Course Nav Bar with Grades selected.
  2. Select Enter Grades. Grades edit options with Enter Grades selected.
  3. Select Import. Import selected.
  4. Select Choose File (Safari and Chrome) or Browse (Firefox and IE).
  5. Navigate to the .CSV or .TXT File to be uploaded. NOTE: Only .CSV and .TXT file types are accepted.
  6. Select Open (PC) or Choose (Mac).
  7. Select the Checkbox next to “Create new grade item when an unrecognized item is referenced”.
  8. Select Continue. Checkbox next to Create new grade item when an unrecognized item is referenced selected.
  9. Review the New Grade Items to be created.
  10. Select the type of grade item to create (Numeric, Pass/Fail, Selectbox, or Text). NOTE: If you have columns in your gradebook import file that you do not want created in this step, uncheck the box for that item in the Create New Grade Item column.
  11. Select Continue. Type of grade item to create (Numeric, Pass/Fail, Selectbox, or Text) selected from menu.
  12. For each new grade item, select a Grades Category, enter the Maximum Points and select if the item Can Exceed the maximum points and if it is a Bonus (extra credit) grade item. NOTE: If you have created grade categories, select the category for each new grade item in this step.
  13. Select Continue. Select continue once you have entered in the New Grade Item properties desired.
  14. Make Note of any Errors that are reported.
      If errors are detected, you may need to:
    1. Cancel the import process and edit the import file.
    2. Correct any errors in the gradebook in D2L after the import process is completed.
    3. Select Go Back to return to the previous step and edit the individual grade item information.
  15. If no errors occurred, select Continue. No errors found, Continue selected.
  16. Review the Gradebook Data to be imported.
  17. Select Import. Import Data to be reviewed.
  18. You will automatically be taken to the Enter Grades screen in the D2L Grades area. NOTE: For instructions on manually entering/modifying grades for existing grade items, please visit Entering Grades.