Desire2Learn

Import and Export Grades

You can import grades by adding a list of students and grades from outside the online course. You can also export online course grades to a text editor such as Word or to Excel.

Desire2Learn's import/export feature uses a comma separated value (CSV) file format. Using a program such as Excel, you can easily open, work with, or create CSV files. You can also import grades from TSAR into D2L. Getting the file in the correct format is critical to your success these features. Read the Import/Export screen carefully.

Import Grades

You may need to import grades involving attendance or extra credit. Imported grades can be any items that the instructor has been tracking outside of Desire2Learn.

Before importing grades, the grade items must be added to the Desire2Learn grade book. For more information refer to Working with the Gradebook. Desire2Learn's import/export feature uses a comma separated value (CSV) file format. Getting the file in the correct format is critical to your success with the import feature. Read the Import/Export screen carefully. The following illustrates the correct format for the import file.

To import grades:

1. From the Course Home page, on the Navigation bar, click GRADES.
   The Grades Area dialog box appears.

2. Click IMPORT GRADES.
   The Grades: Import Grades dialog box appears.

3.    In the Import File: text box, type the location of the import file.
      OR
      To select the file:
   1. Click BROWSE...
      The Choose file dialog box appears.
   2. Navigate to and select the desired file.
   3. Click OPEN.
      
      

4. Click PREVIEW IMPORT.
   This allows you to see how the information will be placed in the Gradebook.

5. If you are satisfied with where the information will be placed, click IMPORT.
   The grades are imported to the Gradebook.

Export Grades

Exporting grades from your Desire2Learn course produces a text file (.txt) with the students' information separated by commas. This information can then be imported to a program such as Excel.

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

1. From the Course Home page, on the Navigation bar, click GRADES.
   The Grades Area dialog box appears.

2. Click EXPORT GRADES.
   The Export Grades dialog box appears.

3. Under Export Options, select the values you would like to export.

4. Under Choose Grades to Export, select the desired items.

5. Select Export to CSV .
   

6. The Export Grades dialog box appears.
   

7. Click on the file, and click on SAVE.
   The Save As dialog box appears.
   

8. Navigate to and select the desired save location.
   

9. Click SAVE.
   The Download complete dialog box appears.
   

10. Click CLOSE.
    The grades are exported.