Moodle to Google Form: Move Your Question Bank Without Retyping
Moodle has a perfectly good quiz engine — but sometimes you want the same questions in Google Forms: easier sharing, no login required to respond, anonymous collection, and a one-click export to Sheets. The good news is you do not have to retype anything. Moodle can export its question bank in GIFT, Aiken, or Moodle XML, and that file can be turned into Google Form fields through a fixed-column bridge, with the questions and answer key carried over exactly.
What Moodle actually exports
Open a question bank in Moodle and choose Export. You will see formats that map cleanly onto a spreadsheet:
| Format | What it is | Best for |
|---|---|---|
| GIFT | Plain-text question format | Multiple choice, true/false, short answer — easiest to parse |
| Aiken | Plain-text multiple-choice format | Simple MCQ banks with one correct answer |
| Moodle XML | Structured XML with metadata | Full banks that include categories and hints |
All three carry the question text, the options, the correct answer, and point values — exactly what a Google Form needs.
The fixed-column bridge
Google Forms does not read GIFT, Aiken, or XML directly. It reads a structured spreadsheet with named columns. So the path is: Moodle export → parse into fixed columns (CSV/XLSX) → Form columns → import.
| Column | What goes in it |
|---|---|
| question | The question text from the Moodle export |
| option 1 … option 6 | Answer choices (leave unused blank) |
| correct answer | The correct option number (1–6) |
| points | Points for that question (optional) |
Moodle to Google Form in 5 steps
Export the question bank
In Moodle, open the question bank, choose Export, and pick GIFT, Aiken, or XML. Save the file.
Parse into fixed columns
The exported questions are read into one row per question: text, options, correct answer, and points.
Convert to Form columns
The sheet is turned into the columns Forms imports — question, options, answer key, and points.
Import into the Form
Load the file into Google Forms. Every row becomes a question with its original wording and answer key intact.
Enable grading
Turn on Settings > Quizzes and the answer key is already filled from the export, so submissions grade themselves.
Frequently asked questions
Can I export Moodle questions and use them in Google Forms?
Yes. Moodle lets you export a question bank in GIFT, Aiken, or Moodle XML format. That exported file can be parsed into a fixed-column spreadsheet and then converted into Google Form fields, keeping the questions and answer key intact.
Which Moodle export format works best?
All three work. GIFT and Aiken are plain-text and the easiest to parse; Moodle XML carries category and hint metadata. Choose whichever your Moodle version offers in the question bank export screen.
Will the answer key and points carry over?
Yes. The correct answer and point value from each Moodle question are read into the fixed columns and become the Form's answer key under Settings > Quizzes. Nothing is reinvented.
Do I have to retype every question by hand?
No. Once the Moodle export is shaped into the fixed columns Forms reads, every row becomes a question with its original options and answer key. You only review wording, not re-enter it.
Why move Moodle questions to Google Forms at all?
Google Forms is simpler to share, collects anonymous responses without a login, and exports to Sheets and CSV. Moving a question bank over is useful for quick polls, exit tickets, or sharing with people outside your Moodle course.
Move your bank without the busywork
If your questions already live in Moodle, they should not live a second life as a re-typed Google Form. Export the bank, carry it over as-is, and keep the answer key exact.
Move your questions →