📘 SheetFormR Help & User Guide

💳 Subscription Info

SheetFormR offers a 3-day free trial with full access to all features — unlimited builds, AI tools, Classroom integration, everything.

After your trial, continue with a Pro subscription ($7/month) to keep creating forms. No feature restrictions during or after trial — you always get the complete SheetFormR experience.

🖥️ Wide View vs Compact View

SheetFormR offers two interface modes:

• Wide View — Opens as a large modal window. Best for detailed work and seeing more options at once.
• Compact View — Opens in the sidebar. Best for quick edits while viewing your spreadsheet.

Click the Switch to Compact or Switch to Wide button in the top-right to toggle between modes.

You can also choose your preferred view from the homecard when you first open SheetFormR.

📊 How to Structure Your Spreadsheet

SheetFormR expects your data organized like this:

📋 Source Sheet Dropdown

Select which sheet (tab) in your spreadsheet contains your quiz questions. SheetFormR reads data from this sheet when building your form.

Auto-map on Sheet Change

When enabled, SheetFormR automatically detects and maps your columns every time you switch to a different sheet. This saves you from manually mapping columns each time.

Remember Build Tab Choices

Saves your preferences (Auto-Map setting, Build Options, Open Form in New Tab) on this computer. Your settings will persist even after closing and reopening SheetFormR.

Enable Quiz Mode ✓

Creates a graded quiz instead of a regular form. This enables:

• Answer keys (correct answers)
• Point values per question
• Automatic grading when respondents submit

When enabled, a green QUIZ badge appears next to the option.

Create and Link New Response Sheet ✓

Automatically creates a linked Google Sheets response sheet for your form. Responses will be collected in a new tab in your current spreadsheet.

This is required if you want to use the Track Submissions feature later.

Apply Title/Description ✓

Uses Row 2 of your mapped Title and Description columns as the form's title and description.

Create as Classroom Assignment

Creates a Google Classroom assignment along with your form. When enabled:

1. Click Load Courses to see your classes
2. Select which course to create the assignment in
3. After the form is created, you'll need to attach it in Classroom (instructions appear on screen)

Append Date/Time To Name

Adds the current date and time to the end of your form title. Useful for creating multiple versions of the same quiz.

Example: "Chapter 5 Quiz" becomes "Chapter 5 Quiz - Jan 18, 2026 10:30 AM"

Include Question Numbers ✓

Prepends the question number (from your Question # column) to each question title.

Example: "What is 2+2?" becomes "1. What is 2+2?"

Shuffle Answer Choices

Randomizes the order of answer choices once when building the form. The shuffled order is then fixed in the form.

This is different from Google Forms' built-in shuffle, which re-shuffles for each respondent.

Shuffle Question Order

Enables Google Forms' native "Shuffle question order" setting. Each respondent sees questions in a different random order.

Sort by Question Number

Sorts questions based on the values in your Question # column before building. Useful if your questions are out of order in the spreadsheet.

Include Images

Attaches images to questions using URLs from your Image URL column. Supports:

• Direct image links (JPG, PNG, GIF)
• Google Drive images (must be shared as "Anyone with the link")

📝 Row Selection

Build only specific rows instead of the entire sheet. Leave blank to build all rows.

Formats accepted:

• 3-10 — rows 3 through 10
• 3,5,7 — only rows 3, 5, and 7
• 3-10,15,20-25 — combine ranges and individual rows

Preflight

Checks your data for potential issues before building. Catches problems like:

• Missing question text
• No answer choices for multiple choice questions
• Invalid question types
• Correct answer doesn't match any choice

Always run Preflight first to avoid surprises!

Preview

Shows a visual preview of your form without actually creating it. Scroll down to see how your questions will appear.

Click any question image in the preview to see it full-size.

Create Form

Builds your Google Form! When complete, you'll see a 🎉 OPEN FORM link to view your new form.

Check to Open Form in New Tab

When enabled, automatically opens your newly created form in a new browser tab.

✅ How to Format Correct Answers

The Correct Answer field accepts different formats depending on your question type:

🎨 Theme

Choose your accent color: Blue (default), Red, Green, Yellow, or Pink.

🌙 Mode

Choose light mode, dark mode, or follow your system settings.

Compact Layout

Reduces padding and spacing for a more compact view. Only applies when using the sidebar (not the wide modal).

Tooltips on Mouse Over

Shows helpful tooltips when you hover over options. Disable if you find them distracting.

How to Use Forge AI

1. Select a sheet from the "Add Questions To" dropdown, or create a new sheet
2. Describe your quiz in the text box (up to 15,000 characters)
3. Check "Includes Math/Equations" if your topic involves math — equations will render as images
4. Click 🚀 Forge Content to Sheet

☑️ Includes Math/Equations

When checked, Forge renders any LaTeX equations as high-resolution images using CodeCogs. The images are hosted externally and work in Google Forms.

How to Use Polish AI

1. Enter row numbers to polish (e.g., 3-10 or 3,5,7). Leave blank for all rows (max 20).
2. Select improvement style(s):
   • Make clearer / less ambiguous — removes confusing wording
   • Simplify reading level — makes questions easier to understand
   • Make more rigorous — increases precision and academic rigor
3. Click ✨ Polish Questions
4. Review the preview — select which improvements to apply
5. Click Apply Selected

How to Track Submissions

1. Click Create Roster Status Sheet
2. Select your Roster Sheet — the sheet containing student names and emails
3. Select your Response Sheet — the linked response sheet from your form
4. Choose an action:
   • Create Submission Status Sheet — creates the structure only
   • Create & Sync Scores — creates structure AND imports scores

How to Import a Classroom Roster

1. Click Import Classroom Roster
2. Select one or more courses from the list
3. Choose Import Mode:
   • Combined — all students in one sheet
   • Per-class — separate sheet for each course
4. Choose Roster Import Mode:
   • Append — only adds new students (recommended)
   • Refresh — clears and rebuilds the entire roster
5. Click Import Roster

❓ Can I edit a form after creating it?

Yes! After SheetFormR creates your form, it's a normal Google Form. Open it in Google Forms to make any edits — add questions, change settings, update the theme, etc.

❓ Does SheetFormR store my data?

No. All your data stays in your Google account. SheetFormR reads from your spreadsheet and writes to Google Forms, but we don't store your questions, student data, or form content on our servers. Only your email is used for license verification.

❓ "No sheets found" or dropdown is empty

Solution: Click Refresh to reload the sheet list. Make sure you have at least one sheet tab in your spreadsheet.

❓ Auto-Map isn't detecting my columns

Solution: Check that your column headers are in Row 1. Auto-Map looks for headers in the first row only. Also try using standard names like "Question", "Answer A", etc.

❓ Images aren't appearing in my form

Solutions:

• Make sure Include Images is enabled in Build Options
• Use direct image URLs (right-click → Copy image address)
• For Google Drive images, share as "Anyone with the link"
• Supported formats: JPG, PNG, GIF

❓ Correct answers aren't being graded properly

Solutions:

• Make sure Enable Quiz Mode is checked
• Ensure your Correct Answer value exactly matches one of your answer choices (including capitalization)
• For multiple correct answers (checkbox questions), separate with commas: A, C

❓ I can't see my Classroom courses

Solution: SheetFormR can only access courses where you are a teacher. Student courses won't appear. Also make sure the courses are active (not archived).

❓ Form was created but it's empty

Solutions:

• Check that your Question Text column is mapped correctly
• Make sure you have data starting in Row 3 (Row 1 = headers, Row 2 = title/description)
• Run Preflight to check for issues before building

❓ SheetFormR is running slowly

Solutions:

• Large spreadsheets take longer to process — try using Row Selection to build smaller batches
• Disable images if you don't need them
• Close other browser tabs to free up memory

❓ I need more help

Contact us at sheetformr@gmail.com — we're happy to help!