Moodle 3: Gradebook: How to Use the CSV Importer


This article has not been updated recently and may contain dated material.

The CSV Importer may be used to import grades (and feedback if applicable) from sources outside the current gradebook. To work correctly, the CSV file should have column headings and contain a unique identifier that can correspond to one of the unique identifier options in Moodle as explained below.

How to Use the CSV Importer:

1. Log in to Moodle, and click on the desired course.

2. In the Administration block to the left of the screen, click on Grades.

Grades option on the Administration block


3. Click on the drop-down menu at the top of the screen, and select the CSV File option under the Selective Import header.

CSV file dropdown menu


4. Click on the Choose a file button next to the File field box to select the CSV you wish to upload. You can also drag and drop the file directly within the field provided.

5. Edit the remaining settings and click the Upload Grades button.

Import CSV Screen


6. In the “Identify user by” section, choose an item from the “Map from” dropdown as a unique identifier for each student. These items are pulled from the column headings in the uploaded CSV file. Any field may be chosen from this list as long as the data corresponds to the unique identifier field chosen from the “Map to” dropdown shown below. Choose the corresponding option in the “Map to” dropdown. The available options are:

  • User ID = Moodle generated ID. This can be used when the file being uploaded was originally generated from Moodle
  • Username = PAWS ID
  • LSU ID = 89 number
  • Email Address = LSU email address
  • Ignore


identify user in moodle


7. Map the desired graded items with those in the file you have just imported using the drop-down menus and leave the rest as Ignore.


8. Click the Upload grades button to finish importing the grades.

upload completion button in moodle CVS file
 

 

 

 

18489
4/20/2018 8:37:59 AM