Transferring Qualtrics survey scores to LMS gradebook

Staff using the scoring feature in Qualtrics who wish to record those results in the LMS will need to manually transfer the relevant score data into the LMS.

Step 1: Export raw data report in Qualtrics

  1. In the Qualtrics survey, navigate to the Data & Analysis tab.
  2. Click on the Export & Import dropdown and select Export Data.

Screenshot of the Data & Analysis screen in a Qualtrics survey, showing the Export & Import drop-down menu expanded with “Export Data” highlighted.

  1. Select CSV and ensure the Download all fields checkbox is ticked.

Screenshot of the “Download a Data Table” pop-up in Qualtrics, with the CSV export option selected and the “Download all fields” checkbox checked.

Step 2: Export the LMS Subject’s Gradebook

  1. In the LMS subject, navigate to Grades to view the Gradebook.
  2. Click on the Export dropdown button and select Export Current Gradebook View. This CSV file will serve as the template for importing grades later.

Screenshot of the LMS Gradebook screen with the Export drop-down menu expanded and “Export Current Gradebook View” selected.

Step 3: Copy scores from Qualtrics Survey to the LMS Gradebook

  1. Ensure both CSV files are sorted consistently. Use the Score column to copy and paste marks from the Qualtrics CSV file into the corresponding assignment column in the gradebook CSV file.
    • Alternatively, use an XLOOKUP function to populate the scores from the Qualtrics survey into the relevant assignment column in the LMS gradebook, using the student ID as the common matching field.
  2. Ensure you save the LMS Gradebook CSV file once the scores have been copied over.

Screenshot of an exported Qualtrics CSV file with the Scores column highlighted.

Screenshot of an exported LMS gradebook file with the corresponding assessment column highlighted.

Step 4: Import updated Gradebook back into the LMS

  1. Navigate to Grades in the LMS subject and click on the Import button.

Screenshot of the LMS gradebook screen with the Import button highlighted.

  1. Click the Choose File button to select the gradebook CSV file that now contain the scores exported from the Qualtrics survey.
  2. Once selected, click Upload Data for the scores to uploaded into the LMS subject grades.

Screenshot of the “Upload Gradebook” screen showing the “Choose File” button for selecting a file and the “Upload Data” button highlighted.

Step 5: Confirm and save

  1. The uploaded scores from the LMS gradebook CSV file will be displayed on screen as a preview. Further manual adjustments can be made by clicking on the score in the To column for any student.
  2. If no further adjustments are needed, click Save Changes to proceed with the import.

Screenshot of the “Upload Gradebook” screen showing a preview of grade data to be uploaded, with the “Save Changes” button highlighted.

  1. Once the Gradebook file has been imported, the scores will be automatically populated within the Gradebook view.

Screenshot of the gradebook screen displaying the successfully imported grade data.

Guides and support

Guides

For more information, please refer to the following guides:

Support

Qualtrics is supported by Teaching and Learning Innovation. Any questions regarding accounts, usage and training can be submitted through our support request form.

This guide was last updated 15 May 2026.

Submit an LMS support request for further assistance or to report any errors or omissions in this guide.