XML to Google Form: Turn Structured Question Files Into a Quiz
Many question banks still ship as XML — a QTI export, a legacy exam file, or a custom interchange format from an old system. Google Forms cannot read XML directly. What you need is a fixed-column spreadsheet built by parsing your XML nodes into named columns, then converted into Form fields — with the question text, options, and answer key carried over exactly as written and no AI inventing questions. This guide covers the deterministic path from XML to a Google Form.
Why XML is not directly importable
XML is a tree of tags, not a spreadsheet. Google Forms consumes a structured spreadsheet with named columns. So the bridge is: XML → node parsing → fixed columns (CSV/XLSX) → Form columns → import. Parsing is what turns your elements (for example <question>, <choice>, <answer>) into the columns Forms reliably recognizes.
The fixed-column layout Forms understand
One row is one question. This layout reshapes each XML item into the fields Forms import.
| Column | What goes in it |
|---|---|
| question | The question text from your XML |
| option 1 … option 6 | Answer choices (leave unused blank) |
| correct answer | The correct option number (1–6) |
| points | Points for that question (optional) |
| image | One public image URL for the question (optional) |
Once your XML is shaped into this sheet and converted into Form columns, every row becomes a question with its original options and answer key intact.
XML to Google Form in 5 steps
Open the XML
Load the question XML — a QTI export, a legacy exam file, or a custom format. Keep the question, choice, and answer elements as they are.
Parse the nodes
Each item element is read: the prompt, its choices, and the marked correct answer. The text is taken as-is.
Arrange into fixed columns
One row per question: question text, options (option 1–6), correct answer, and points.
Convert to Form columns
The sheet is turned into the columns Forms reads — question, options, answer key, and points.
Import and grade
Load the file into the Form, then enable Settings > Quizzes with the answer key filled. Submissions grade themselves.
Missing nodes stay blank, not invented
If a question in your XML has no points or no image node, that column is left empty rather than filled with a guess. The conversion is deterministic — only the text already in your file travels into the Form.
Frequently asked questions
Can I really turn an XML question file into a Google Form?
Yes. An XML file of questions is parsed node-by-node into a fixed-column spreadsheet (question, options, answer key, points), which is then converted into Form fields. The text in your XML is carried over exactly — nothing is invented.
Does the parser rewrite or guess the questions?
No. The conversion is deterministic: each XML node is mapped to a column. If a node is absent, the column is left blank rather than fabricated. No AI generates new questions or changes the answer key.
What XML shapes work?
Most question XML works: an item or question element with child nodes for the prompt, choices, and the correct answer. Both QTI-like and custom XML are parsed by mapping element names to the fixed columns.
How is this different from an AI quiz maker?
AI quiz makers take a prompt and generate questions. Here the source is your XML file, and only the text in it is converted. No AI is used to create content.
Put your question bank online
Stop hand-retyping a legacy export, and stop letting an AI rewrite your exam. If the questions are already in your XML, send them as-is — from XML to Google Form, with the answer key intact.
Try ExamParser →