Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image RemovedBlackboard Learn LogoImage Added

Table of Contents


If you prefer to maintain student grades in an Excel spreadsheet on your computer, you can still upload them to your course site. Note:


You can upload multiple grade columns to the Grade Center at once.



Columns that are added to the Grade Center from an external file are text columns with zero points possible. Text columns cannot be included in Calculated Columns such as Weighted Grade, Total Points, Average Grade, and Minimum/Maximum grade. To include the added column in calculations, modify the column after uploading: change Primary Display from text to score and type points possible.


Download Grade Center Spreadsheet

  1. Click Work Offline in the upper right corner of the main Grade Center page.
  2. Select Download from the drop-down menu.
  3. Select the Full Grade Center radio button.
  4. Leave Tab as a delimiter type. Tab delimited files have the file extension .xls.
  5. Choose Yes next to Include Hidden Information if you want hidden columns and students to be included in the spreadsheet.
  6. Press the Submit button.
  7. Press the Download button and save the file on your computer.


In order to upload grades to the Grade Center in Blackboard, you can first download the Grade Center, make your modifications, and save the file. For instructions on how to download the Grade Center and correctly save the modified file, click this link: Downloading the Grade Center

Upload a Delimited File

titlePreparing the csv file

Your file should contain a header row on top to include the word username. You should also have a title for the newly created column and should not be left blank.

Excel Spreadsheet Example With HeadersImage Modified


  1. Click In Blackboard, click Work Offline in the upper right corner of the main Grade Center page.
  2. Select Upload from the drop-down menu.
  3. Press the Browse button.
  4. Select the file on your computer. Make sure you selected a delimited file with .txt extension or a file with .csv extension.
  5. Click Open.
  6. Select the Delimiter Type: Auto. Auto will attempt to automatically detect the delimiter used in the selected file.
  7. Click Submit to upload the selected file.
  8. Review the list of data from the file to be uploaded. Use the check boxes to deselect any data to be excluded from the upload. Using this method, it is possible to upload only the desired columns of data from the spreadsheet.
  9. Review the Data Preview column to ensure the correct data is being uploaded. Data that appears incorrect can denote an improperly formatted file. The Data Preview will only show a sample of the data in each column in the file.
  10. Click Submit to confirm and upload the file.