The below is from our in-house developer Lillian Hawasli. This free tool has, and continues to, save us a ton of time generating quiz banks in Moodle. I’m sorry to say that at the moment, it does not work for Canvas, although it is in the development queue (now sadly pushed back a bit).

If you have access to both a Moodle instance and Canvas, you could import from (QB)² to Moodle, then back it up and use the Moodle back up file to import into Canvas. Not elegant, and be careful that some questions types (such as missing word) don’t import into Canvas, but it is possible.

With instruction at UCLA moving online due to COVID-19, our instructors across campus (and I’m sure at other institutions) have been needing to move their quizzes and exams to Moodle as quickly as possible. We want to share a tool UCLA has been using to more quickly and efficiently create quiz questions in Moodle. We hope this will be useful to other instructors in the Moodle community.

(QB)², or the “Question Bank Quick Builder,” is a free Google Sheet Add-on created to reduce the labor for instructors creating digital course materials. The instructor can write their questions and answers in plain text, all visible and editable on a single page. (QB)² transforms this content to an XML document, which the instructor can easily import into the Moodle Question Bank.

For those of you who may already be familiar with the tool from MoodleMoot 2019, we recently deployed a newer version which introduces new key features:

Answer-specific feedback now supported for multiple choice, short answer, and true/false question types
Option to auto-generate the spreadsheet template
Updated reset spreadsheet feature
Updated user interface

You can find more detailed information on the tool and how to use it here.