To download the grade book from Blackboard to Excel: Go to Control Panel > Grade Center > Work Offline (top, right) > Download. Then, Full Grade Center > tab delimiter type > yes (to hidden column/users) and click Submit. On the Download Grades screen, the instructions to right click and Save As will result in an error message. Instead, left click on the Download button and then you can save the file to your computer. > Save File As (to save as an Excel file to your computer).
Here is a link to Blackboard’s video tutorial on Downloading and Uploading Grades, Bb9 Grade Downloading Uploading Grades.