D2L - Importing Grades (UW-Madison)

UW-Madison has adopted Canvas as the single, centrally supported learning management system. Access to D2L and Moodle permanently ended on June 1, 2018.

This is a legacy document which will be permanently removed from the UW-Madison KB space as of June 29, 2018.

To successfully import grades on a Macintosh, it is necessary to follow these steps during export and import.


  1. Export your gradebook as you normally would, as described in Learn@UW - Importing and Exporting the Gradebook.
  2. After the export file has downloaded, verify that the file extension is ".csv" (you may need to change ".cs" to ".csv or to delete ".txt" from the filename).
  3. Open the file as normally in Microsoft Excel.


  1. When saving the file in Excel,choose File and then Save As....
  2. In the Format dropdown menu, select TXT or CSV (Windows).
  3. Click Save.

To ensure that the import works properly, verify that you are using a recommended browser as documented in: Learn@UW - Recommended Browsers.

Keywords:learn@uw learnuw d2l desire2learn Grades Gradebook Import Importing Export Exporting Macintosh OSX OS X   Doc ID:3475
Owner:Learn@UW Madison .Group:Learn@UW Madison
Created:2005-02-13 19:00 CDTUpdated:2017-12-01 12:21 CDT
Sites:Learn@UW Madison
Feedback:  2   3