Importing Grades

  1. For best results, we suggest you first go to the GoucherLearn gradebook for the course and  Export the gradebook to use as a template to be imported back with new data. This will ensure you have the correct unique identifiers to match data to the correct students. See Exporting grades.
  2. Open the exported file and add your grade data.
    • If importing grades for an existing Grade item in GoucherLearn, values must fit within the Grade range or Scale established in the activity settings.
    • To create new Grade items in the GoucherLearn gradebook, add new columns to the spreadsheet document. Remember to label the column header.
      Note: Grades added in this manner will, by default, have a maximum value of 100 points and cannot exceed that value.
    • To import letter grades into GoucherLearn, you must first create the Letter Grade column in the course grade book.
    • Written feedback can be imported into the Comments associated with a grade item.
  3. Save the file for import. GoucherLearn will accept Comma Separated  Values (*.csv) or Tab Delimited Text (.txt). To change the file, go to “Save As…” and choose these two from the “Format” dropdown menu.
    Important: If your spreadsheet includes values or headers containing commas, quotes, or apostrophes (for example, when importing feedback comments) save as a Tab Delimited Text file (.txt).

Import the File to the GoucherLearn Gradebook

Regardless of which file format you decide to use (.csv or .txt), the following steps are the same.

  1. Open your course grade book in GoucherLearn and click the Import Tab. The Import:CSV file page will open.
    • Note: By default, GoucherLearn will import a Comma Separated Values (.csv) or Tab Delimited Text (.txt) file (you can change the file format by looking below the Import tab and clicking XML file).
  2. In the Import file area, drag and drop a file from your desktop or click Choose a file….  The File picker will open. Use the File picker to select a file from your computer.  Once your file is uploaded, the file name will be displayed.
  3. On the Import CSV page, for Separator:
    • If uploading a Comma Separated Values (.csv) file, leave the option set toComma.
    • If uploading a Tab Delimited Text (.txt) file, change the option to Tab.
      Grade import file type - Choose comma or tab delimted  (click to enlarge)

    Leave other settings at defaults.

  4. Click Upload grades. If the upload is successful, the Import preview screen will open.
  5. In the Import preview area, review the sample grid and verify the upload data.
    Note: Data should appear in columns with headers above each column. If data is not displayed in a table with columns and rows, this indicates a problem with GoucherLearn reading the file. Make sure the file is saved in the correct format and then repeat the upload.
  6. The Identify user by section is where you match the unique identifiers in your spreadsheet to students in GoucherLearn.
    • To match users by Student ID, set both the Map from and Map to drop-down menus to ID number (default).
    • To match users by email address, set both the Map from and Map to drop-down menus to Email address.
  7. The Grade item mappings section is where you match columns in your spreadsheet to grade items in GoucherLearn. The column headings from your imported file will be listed at left, with a drop-down menu (to the right) listing existing grade items in the course gradebook.
    • To import a column to an existing Grade item, select the Grade item namefrom the Grade item mapping drop-down.
      Note: This will overwrite existing data in the GoucherLearn gradebook for each student in your spreadsheet.
    • To add a new Grade item, select new grade item (at top of drop-down list).
      Note: Each New grade item created in this manner will have a default maximum value of 100 points.
    • To skip a column, and not import its data, leave the drop down menu set toignore.
    • To import written feedback for a Grade item, map the spreadsheet column to the Comments for a grade item, not to the Grade item itself, nor as a New grade item.
      Note: Comments are grouped at the bottom of the Grade item mappings drop-down menus.
  8. Click Upload grades at the bottom of the screen.  The upload will begin. If the upload is successful, you will see a “Success” message.
  9. Click Continue to return to the Grader report view of your gradebook. Make sure the new data is properly inserted in the appropriate columns.

Errors and Troubleshooting for Grade Import

If the import fails there are several possible error messages and remedies:

  •  user mapping error, could not find user with username “Name”
    You did not properly set Step 6, (Identify user by).  Upload and import the file again making sure to match by Email address, or ID Number.
  •  user mapping error, could not find user with email address “, or user mapping error, could not find user with ID number “12345678”
    Your file contains incorrect email addresses or student IDs. The import process will be canceled and no values imported. Return to your spreadsheet and fix the problem data, then upload and import again.
  •  user mapping error, could not find user with email address “”, or user mapping error, could not find user with ID number “”
    The file contains empty cells, or duplicate students.
    Return to your spreadsheet, carefully select only the cells containing data, and copy and paste into a new spreadsheet. Another possible solution for a .csv file is to open the file in a text editor and remove the extra commas at the end of lines, or bottom of the page. Save the corrected file, then upload and import again.