This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

Desire2Learn 9.0

Exporting and Importing Grades

You can export online course grades to a text editor such as Excel. It is a good idea to do this regularly to back up your grades. You can also import grades by adding a list of students and grades from outside the online course.

Desire2Learn's import/export feature uses a comma separated value (CSV) file format. Using a program such as Excel, you can open, work with, or create CSV files.

return to topRecommendations

Exporting grades is fairly straightforward, but importing grades into D2L can go wrong more easily. To successfully import grades, follow the recommendations in this section.

return to topExporting Grades

Exporting grades from your Desire2Learn course produces a CSV file with the students' information separated by commas. If you plan to import grades, first set up the grade items in D2L, and then export grades so you can work with a file with the correct rows and headings.

NOTE: It is a good idea to export your Grades List a couple times during the semester and at the end of the semester so that you have a backup of your Grades List.

  1. From the Course Home page, on the Navigation bar, click GRADES
    The User List screen appears.

  2. Click EXPORT GRADESExport Grades button
    The Export Grades pane appears.

  3. In the Export Options section, select the desired options
    Export Grades Pane: Export Options section

  4. In the Choose Grades to Export sections, select the grade items you want to export
    HINT: A grade item is selected when a check appears next to it.Choose Grades to Export section

  5. Click EXPORT TO CSV
    The Export Grades dialog box appears.Export Grades dialog box

  6. Click the grade link
    The File Download dialog box appears.

  7. Click OPEN
    The file opens in Excel.

  8. OPTIONAL: Make any desired changes

  9. Click FILE MENU File menu button

  10. Click SAVE AS
    The Save As dialog box appears.

  11. Navigate to and select the desired save location

  12. In the File name text box, type a name for the file
    WARNING: Keeping the default name creates problems when importing the grades into D2L.

  13. In the Save as type pull-down menu, select CSV (Comma delimited) (*.csv)
    Save as type pull-down menu
    WARNING: Saving as a different sort of CSV file creates problems when importing the grades into D2L.

  14. Click SAVE
    A confirmation dialog box appears.

  15. Click YES
    The file is saved.

  16. Close the Excel file

return to topImporting Grades

  1. After creating grade items in D2L, export the gradebook
    NOTE: Be sure to open the gradebook file, add grades in the appropriate columns, and save as a CSV file with a new name when exporting the gradebook. See Exporting Grades for full instructions.

  2. From the Course Home page, on the Navigation bar, click GRADES
    The User List pane appears.

  3. Click IMPORTImport Grades button
    The Import Grades pane appears.

  4. In the Import File text box, type the location of the CSV file
    To select the file,

    1. Click BROWSE...
      The Choose File to Upload dialog box appears.
    2. Navigate to and select the desired file
    3. Click OPEN
  5. When you have the information placed as you desire, click NEXT
    Step 2: Errors and Warnings Found appears.Import Grades pane: Step 2

  6. WARNING: If an error message appears, review the document you were importing. Make sure it is saved as a .csv file. Check that you followed the recommendations. If that does not resolve the problem, export the file again, making sure to follow the directions exactly. If you still get an error message, make sure that no categories and grade items share a name (e.g., exam). Contact the Help Desk if problems persist.
    Import Grades: Errors message

  7. Click NEXT
    Step 3: Preview Import appears.Import Grades pane: Step 3

  8. Click IMPORT
    The gradebook is imported.

Excellence. Our Measure. Our Motto. Our Goal.