Google Sheets

This guide explains how to prepare your Google Sheet so Form Builder can correctly convert it into a Google Form.

Each row = one form element (question, section, title, etc.)
Each column = a property of that element

• Questions → Main question/title/section name

• Desc → Description (optional)

• Image → Image URL (optional)

• Type → Question type (e.g., MULTIPLE_CHOICE, TEXT, etc.)

• Required → TRUE / FALSE

• Options (option start → option end) → Answer choices

• Other → TRUE to enable “Other” option

• Points → Marks for quiz

• Correct Answer → Correct answer(s)

• Feedback / URL → Explanation or links

• If Type is empty → defaults to Short Answer

• You can explicitly set:

  • TEXT → Short Answer

  • PARAGRAPH → Long Answer

  • MULTIPLE_CHOICE

  • CHECKBOX

  • DROPDOWN

  • CHECKBOX_GRID / MULTIPLE CHOICE GRID

  • DATE, TIME, DATETIME

  • SCALE / Linear Scale

  • IMAGE, VIDEO

  • TITLE, SECTION, SECTION_HEADER

• Add options in columns:

  • option start, option 2, option 3, ..., option end

Options can include:
Option Text | Image URL | Action

Example:

Astrology | image-url | NEXT_SECTION

• Single correct answer → use: Taxonomy

• Multiple correct answers → use: Answer1,Answer2

• This automatically makes it a Checkbox question

• Use | to separate rows:
  Correct|Incorrect, Maybe, Incorrect

• Set column Other = TRUE

• Works for:

  • Multiple Choice

  • Checkbox

• If Points + Correct Answer is provided:

  • Question becomes a Quiz question

• Image column → adds image to question

• VIDEO type → paste YouTube link in options column

Options can include navigation actions:

• NEXT_SECTION → go to next section

• SUBMIT_FORM → submit form

• Section name → jump to specific section

• Type = Title

• Type = SECTION / SECTION_HEADER

• Type = IMAGE

• Image column = image URL

• Type = VIDEO

• Option = YouTube URL

•  Each row = one question or element

• Do NOT leave important columns inconsistent

• Use TRUE/FALSE (uppercase) only

• For multiple correct answers → separate with commas

• For grid → use | and , properly

•  Option format supports:
  Text | Image | Action

• Wrong type names (e.g., "multiple choice" instead of MULTIPLE_CHOICE)

• Missing commas in multiple answers

• Incorrect grid formatting

• Not matching A/B/C with actual options

• Start with a simple sheet (a few questions)

• Test → then scale to full form

• Use consistent formatting throughout