Moodle: 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 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

 

  1. 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

 

  1. 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

 

  1. 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

The Faculty Technology Center (FTC) provides Moodle support by email, by phone, or live through Zoom. For contact information, please see the article Faculty Technology Center: LSU Overview. To connect through Zoom and for further information on support services and training, see the LSU Online & Continuing Education Faculty Resources & Support page.

The FTC also provides just-in-time faculty training opportunities and recorded training sessions. Attending at least one training session for Moodle upgrades is highly recommended. For a comprehensive list of available workshops and recordings, please see the LSU Online & Continuing Education Technology Training page.

20358
10/16/2023 9:08:39 AM