- Open Response and click on Manage My Data
- Select your class from the left hand column
- Click on the Gradebook tab (to the right of the Roster tab near the top)
- From the file menu, select Export Gradebook
- Export Type: Blackboard 8 (don't worry -- this works for WebCT, too!)
- Export Header: checked
- By Comma: selected
- Click Next
- Give it a file name
- Export Directory: browse for your desktop
- Click Finish
It should save a CSV file to your desktop. You can open this using Excel to edit any data (or remove any columns you don't want to import).