Importing and Exporting Grades

Grades can imported into and exported out of SaplingLearning.com. 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

From the gradebook, click the Export tab at the top of the gradebook. Once there, select one of the export filetypes at the top (OpenDocument spreadsheet, Plain text file, Excel spreadsheet, or XML file; you most likely want either a Plain text file or an Excel spreadsheet). The easiest option is the Plain text file, a comma-separated list (csv). Use this option if you will later import grades. You will be given the option to choose what fields to export. For basic usage, leave all fields selected, and click Submit. You will be prompted to save the file.

You can import this file 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.

For more information, see the Moodle help doc on grade exports.

Importing Grades

To import grades, begin with an exported copy of your gradebook. If you are importing external grades, you will only need the "Email address" column from this export, but the "First name" and "Last name" columns will likely be helpful to help you match the grades to your external logs. Simply enter the name(s) of any new activities at the top of a column, and the score for each student in the same row as their email address. Save the file as a comma-separated list (csv).

Once your file is prepared, choose the Import tab at the top of the gradebook. Click Choose File on the page that loads, and select your csv file. Leave everything else as-is. Click Upload Grades.

On the preview page, verify that your data appears. In the Identify user by block, choose Email address in the first drop-down, and useremail in the second. For each field in the Grade item mappings block, change the drop-down from ignore to either new gradeitem (if the item does not yet appear in your SaplingLearning.com gradebook), or to the name of an existing item in the gradebook if you are simply updating grades.

For more information, see the Moodle help doc on grade imports.