...

If you have a unique grading system, have class assignments in external sites, or just prefer a different grade editing environment, you may wish to download your Grade Center and work on it in Excel.  These instructions will give you the information that you need to do so.

Downloading your Gradebook

In the course, use the control panel to access the full Gradebook.

...

On the sidebar that comes up, you will be able to download either the full grade center or a specific column. You can also select to download the Grade History, which provides the history of changes made to individual grades.  You will also be able to select the file type of the download;  select a .csv file for the file type, as there are problems importing the tab delimited format into newer versions of Excel.  When you have chosen all your settings, click 'Download' to download the file to your computer. 

Editing your Gradebook

Once you’ve downloaded your Gradebook, it’s time to edit it. 

...

When you’re done with your edits, save the file.  In the Save as Type: dropdown, choose CSV or Comma Separated Values. You may get a couple of popups asking if you’re sure; choose yes.

Uploading your Edited File

Once you’ve saved your edited file, you can upload it to Scholar.  Return to your Grade Center and choose Upload.

...