Sapling Learning > Grade Import and Export

Document created by Digital Support on Jan 25, 2017Last modified by Digital Support on Apr 23, 2018
Version 14Show Document
  • View in full screen mode

Grades can be imported into and exported out of Sapling Learning. We recommend that you export grades at least once before attempting an import, to set up the file you will use for importing.

Exporting grades

Open the gradebook

Click the Grades icon in the left navigation menu of your main course page.

Click the "Export" tab at the top of the gradebook

Select file type

Select one of the export file types at the top (OpenDocument spreadsheet, Plain text file, Excel spreadsheet, or XML file). You most likely want either a Plain text file (.txt which can be changed to .csv) or an Excel spreadsheet.

Select which grades to include

Under Grade items to be included, you will see a list of assignments, category totals, and other grade items to include in your export. For basic usage, select all fields using the Select all/none link at the bottom of the list and click Submit. You will be prompted to save the file.

Plain text to csv

If you exported a plain text file (.txt), you can import it into any program that accepts csv files, such as Excel. Tip: Change the filename to end in .csv in Windows so that Excel will recognize the file as a comma-separated list.

Importing Grades

Prepare a spreadsheet to import

  1. To import grades, begin with an exported copy of your gradebook, or the participants page, or any spreadsheet that contains a unique identifier for your students (Sapling e-mail, Sapling userID, or studentID if that info is filled in for each student in Sapling).
  2. Add a column to your spreadsheet for each activity you'd like to import grades for, and enter the score for each student in the same row as their identifier.
  3. Save the file as a comma-separated list (csv).

Open the gradebook

Click the Grades icon in the left navigation menu of your main course page.

Click the "Import" tab at the top of the gradebook

Click "Choose File" and select your csv file

Leave everything else as-is and click "Upload Grades"

Check import preview and select "Map to"

On this screen you can review the import preview to make sure the information is accurate. In the Identify user by block, choose which column from your file should match up with the unique identifier in Sapling.

Useremail may be the easiest way to map, although you can also use the Userid or Useridnumber. In the Map to drop-down, userid refers to the student's Sapling id (an arbitrary number generated by Sapling), whereas useridnumber is an optional field in Sapling that may be used to store your school's student ID for that student. If you have not already asked your Client Success Specialist or your students to include their student IDs, then you cannot use useridnumber as the identifier for grade import.



Grade item mappings

Scroll down to the Grade item mappings block, which shows you a list of all the column headers from your file. For any new gradebook column you wish to add, choose new gradeitem. For any existing gradebook column that you wish to overwrite, choose the name of that gradebook column in Sapling. For everything else, leave as ignore.

If you choose new gradeitem for a particular set of scores from your file, those scores cannot be greater than 100. If you wish for an item to have a max score above 100, you'll need to add the grade item first, set the max points to be >100, then map the scores to that existing grade item during import.

Scroll to the bottom and click "Upload grades"


Add new grade item

Here's how to make a new blank column in your gradebook without importing from a file.

Open the gradebook

Click the Grades icon in the left navigation menu of your main course page.

Click "Categories and items" at the top of the gradebook

Click "Add grade item" at the bottom of that page

Name item and enter maximum point value

Enter the item name (which will appear as the column header) and the maximum grade (the number of points each score is out of).

Scroll to the bottom of the page and click "Save changes"

For more information and a video about grade items, see the help article Grades for External Activities.