1. Johns Hopkins Engineering
  2. Canvas
  3. Assignment & Assessment Setup

Importing Quiz Questions in Canvas using a Spreadsheet

CMTS Support
Updated

If you would like to save yourself time when creating quizzes and exams in your Canvas course site, quiz questions can be uploaded in bulk using the process outlined here. It will require using Excel to create a CSV file, and then converting that into a QTI file. Once you have that QTI file, it can be imported into Canvas. The following instructions will walk you through the process.

Instructions  

  1. Use Excel and the CSV file template when creating the quiz questions for your course.
  2. Make sure to save the file as a CSV file type. It is helpful to name the file with a unique title.
  3. Convert the CSV file into a QTI file. You can use this converter tool: https://canconvert.k-state.edu/qti/.
  4. In your Canvas course site, click on the Settings menu option. And then choose Import Course Content in the right-hand menu.
    menu options under course settings
  5. On the Import Content page, select QTI .zip file as the Content Type. Attach your converted QTI file and select the question bank where the questions should reside. We recommend that you select Create New Question Bank, and give the question bank a unique name.import page showing all options
  6. Click Import.
  7. Once the import is complete, you can navigate to Quizzes in your course menu to view the imported quiz questions. Note: It's recommended that you review each question and answer to make sure that no errors were entered during the importing process. 

Template Guidelines

When using the CSV file template, use the following guidelines when creating quiz questions.

  • Column A is the type of question: MC (multiple choice); MR (multiple response/answers); TF (true/false).
  • Column B is not used but must be present. Do not enter any content into this column.
  • Column C is the point value of the question. It can be between 0-100 and have up to two decimal places (3.33).
  • Column D is the question body.
  • Column E is the correct answer. Enter the number(s) that correspond to the correct answer choice(s) listed in Columns F–J.
    • 1 = Column F
    • 2 = Column G
    • 3 = Column H
    • 4 = Column I

    • 5 = Column J

      Other question types:

    • True/False questions: Enter 1 for True and 0 for False.
    • Multiple-answer questions: Enter multiple numbers separated by commas (e.g., 1,2 if both Columns F and G are correct).
Was this article helpful?
0 out of 0 found this helpful