Excel to Google Form: Turn a Question Bank Into a Self-Grading Quiz
Here is the first thing to know about moving a spreadsheet into Google Forms: there is no native "upload Excel" button. Google Forms only imports questions from another Google Form in your Drive. Everything else — an .xlsx question bank, a Word doc, a PDF — needs a conversion step first. The good news: a spreadsheet is the cleanest source you can have, because it is already structured. This guide is the spreadsheet-native playbook — how to lay out your .xlsx, convert it, and land a self-grading Google Forms quiz with a working answer key.
.xlsx is version-controlled, reusable, and the same file can later feed Canvas, Moodle, or any other LMS. Retyping questions into the Forms editor locks your content inside one Form and invites typos. Author once, convert anywhere.
The fixed-column layout your .xlsx should use
The single biggest cause of a failed import is a freeform sheet. Converters (and Forms itself) need a predictable shape. Use one row per question with these fixed columns:
| Column | What goes in |
|---|---|
| Question | The question stem (plain text; math as plain text or LaTeX). |
| Option A – Option F | The answer choices, one per column (up to six). |
| Correct | The position of the right option(s): 1, or 1,3 for multiple correct. |
| Explanation (optional) | Feedback shown after answering. |
| Image URL (optional) | One hosted image link per question. |
Note the Correct column stores the position number, not the letter or the answer text. That single detail is what makes the answer key survive the import instead of breaking on "A vs B" mismatches.
Step-by-step: Excel → self-grading Google Form quiz
Shape the question bank
Put your items into the fixed columns above. One row per question, no merged cells, no multi-row headers.
Convert the .xlsx
Run it through a converter that reads the fixed layout and maps each row into a Form question with the correct-answer position recorded.
Import into Google Forms
Create a new Form (or import into an existing one) and bring the converted questions in. Preview to confirm every option and the answer key landed.
Turn on quiz mode
Settings → "Make this a quiz". The Correct column from your sheet becomes each question's key automatically.
Release scores
Choose immediate or manual score release from the Responses tab. Students get instant feedback; you get a graded sheet.
Handling the three tricky parts
Images
Google Forms attaches one image per question. Because a spreadsheet cell cannot embed a file, the rule is: host the image and put its URL in the Image URL column. Diagrams, graphs, and maps all work this way. Multiple images per question are not supported, so pick the one that matters.
Math
Keep math as plain text (x^2 + 1) or LaTeX. Avoid pasting rendered equation images into the question cell — they will not survive a text import. If you need true typeset math, host a screenshot via the Image URL column.
Multiple correct answers
Checkbox-style questions are fine: list every correct position in the Correct column separated by commas, e.g. 1,3. The converter sets the question to "checkboxes" and marks all listed options right.
Why a spreadsheet beats a doc or PDF here
A Word doc or PDF hides its structure — questions might be headings, list items, or buried in a table. A spreadsheet declares structure up front, so the import is deterministic: what you typed is what students see, with the answer key intact. When your source is already a question bank, working from .xlsx is the shortest, safest path to a Google Forms quiz.
More import guides at examparser.com/blog/en.
Frequently asked questions
Does Google Forms have a native Excel import button?
No. Google Forms only imports questions natively from another Google Form stored in Drive. There is no built-in "upload Excel" option. To move a spreadsheet question bank into Forms you convert the .xlsx into a Form through an external step. ExamParser reads a fixed-column .xlsx and produces a ready-to-import Google Form quiz, answer key included.
What columns should my Excel question bank use?
Use one row per question with fixed columns: Question, then one column per option (up to six), a Correct column holding the position number(s) of the right option(s), an optional Explanation column, and an optional Image URL column. Keeping the layout fixed is what lets any converter map it to a Google Form quiz reliably; freeform, merged, or pivot-style sheets will not import cleanly.
Can I include images in an Excel to Google Form quiz?
Yes, but one image per question and it must be a URL, not an embedded file. Put the hosted image link in the Image URL column; the converter attaches it to that question in the Form. Multiple or embedded images are not carried over, so host diagrams externally and reference them.
How do I make the imported Google Form self-grading?
After importing, open the Form, enable "Make this a quiz" under Settings, then assign the correct answer and point value to each question. Because your source .xlsx already carried the Correct column, the answer key maps straight across and students get instant scores. Release scores automatically or manually from the Responses tab.
Why convert from Excel instead of retyping into Forms?
A spreadsheet is version-controlled, reusable, and the same file can feed Canvas, Moodle, or other LMSes later. Retyping into the Forms editor is slow, error-prone, and locks the content inside one Form. Authoring once in .xlsx and converting keeps your question bank portable and auditable.
Ready to move your question bank into Forms?
Stop retyping. Lay out a fixed-column .xlsx, convert it, and import a self-grading Google Forms quiz with the answer key already in place — then reuse the same file on any other LMS.