Google sheets to Google form

 

How to Turn a Google Sheet into a Google Form Quiz

(Using Form Builder for Google Sheets)

Step 1 — Format the Google Sheet correctly

Your sheet must be set up like this:

A	B	C	D	E	F	G
Question	Option 1	Option 2	Option 3	Option 4	Correct Answer	Points

Example row:

Question	Option 1	Option 2	Option 3	Option 4	Correct Answer	Points
Leslie creates the imaginary kingdom of Terabithia. This shows she is imaginative because	she transforms the woods into a fantasy world	she enjoys walking outside	she talks with Jess in the forest	she spends time exploring the trees	1	1

Important rules:

• Each question must be in ONE row
• Answers must be in separate columns
• Correct Answer must be a NUMBER

1 = Option 1
2 = Option 2
3 = Option 3
4 = Option 4

Points can simply be:

1

for every question.

---

Step 2 — Open the Form Builder

In Google Sheets:

Extensions
→ Form Builder for Google Sheets
→ Start

---

Step 3 — Set the importer correctly

Choose:

Content selection: Range

Range example:

A1:G20

(adjust the last number to include all your questions)

Turn on:

Range includes header

---

Step 4 — Select pattern

Choose:

Quiz

---

Step 5 — Map the columns

Fill these exactly:

Question at column → A
Answer starts at column → B
Answer ends at column → E
Correct answer at column → F
Points at column → G

Leave everything else blank.

---

Step 6 — Generate the form

Click:

GET

The add-on will automatically create:

• a Google Form
• multiple choice questions
• correct answers marked
• points assigned

---

Common mistakes (the ones we just fought)

Problem: GET button not clickable

Cause:
A required column is empty.

Fix:
Make sure these are filled:

Question column
Answer start column
Answer end column
Correct answer column
Points column

---

Problem: Questions do not import

Cause:
The sheet is not structured by columns.

Fix:
Every question must be one row.

---

Problem: Correct answers wrong

Cause:
Letters used instead of numbers.

Wrong:

A
B
C

Correct:

1
2
3

---

What your finished workflow looks like

1. Write questions in Google Sheets

2. Add answer numbers

3. Run Form Builder

4. Click GET

5. Form builds automatically

Total time once set up:

about 30 seconds.