Moodle: Gradebook: How to Use the CSV Importer


The CSV Importer may be used to import grades 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.  Email address or LSU ID number (89 number) are commonly used. You must also create all categories and grade items in the course gradebook so that you can map the grade items from the .CSV or .TXT file. If edits to the imported data are needed, editing in Notepad and importing the .TXT file is highly recommended.

How to Use the CSV Importer:

1. Log in to Moodle and select the desired course.  From the Course Administration menu (gear icon), select Grades.

2. Expand the Gradebook drop down menu and select CSV file under Selective Import.

Gradebook drop down menu with CSV file selected

 

3. 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.  Then scroll down and click the Upload grades button

Import CSV screen with drag and drop window depicted

 

4. Use the Map from dropdown list to select the column in the CSV file containing the unique identifier of the student and the Map to drop down list to select the corresponding field in Moodle.

Map from and Map to drop down fields with email address specified as unique identifier

 

5. In similar fashion, use the Grade item mappings drop down menus to map columns in the CSV file containing grades to be imported to their corresponding grade items in Moodle.  The remaining fields can be left mapped to Ignore.  Click the Upload grades button when done.

Grade item mappings with Homework grade selected

 

Support & Training

Support and training for Moodle is available via the Faculty Technology Center at ftc@lsu.edu. For more information, please see the following article: Faculty Technology Center: LSU Overview

Attending at least one training session for Moodle upgrades is highly recommended. For a comprehensive list of training sessions, as well as to register for a slot, please see http://training.lsu.edu.

20358
9/30/2022 2:17:59 PM