Automate the Boring. Focus on What Matters.
Save your time with our Quiz Maker
Automate the Boring. Focus on What Matters.
Save your time with our Quiz Maker
Designed for educators, this intuitive tool lets you generate Google Forms directly from your spreadsheet. No coding required. Create quizzes, manage responses, and control access — all from the tools you already use
With just a few clicks, transform structured data in Google Sheets into a fully functional Google Form.
Define questions, answer types, points, and correct answers
Customize sections and pages
Automatically generate quizzes from a single sheet
Simply fill out your spreadsheet with the following fields:
Page: Page number or page title
Section: Section name
Question: Quiz question text
Type: Question type — e.g., Dropdown, Checkboxes, Multiple choice, or Paragraph
Options: Answer choices, separated by “;”
Answer: Correct answer(s), also separated by “;” if multiple
Points: Score assigned to the question
You can also set the form's Title and Description at the top of the sheet.
Use the custom menu Quiz Generator in your Google Spreadsheet to create a new form instantly.
Click Create New Form
The form is created with all configured questions
Get a link to edit or preview the form
See total points and metadata in a dedicated sheet
🗂️ Track Form History
The FormsInfo sheet stores:
Creation date
Quiz title
Total points
Edit/view links
🕒 Control Form Availability
From your spreadsheet, toggle form status:
Open Form Now → Accepting responses
Close Form Now → Form is closed
No need to visit the Google Form interface manually.
Emiliia Tarmaieva
Product Lead, JOHNNYWORKS LLC
We're building solutions that empower teachers with tools that work the way they do — fast, simple, and powerful.
We’re preparing to release this tool on the Google Workspace Marketplace so educators everywhere can simplify quiz creation and classroom management — right from Google Sheets.
In the near future, we also plan to integrate AI-powered question generation. This feature will allow teachers to automatically create quiz questions by uploading files such as PDFs, Word documents, or text — making quiz creation even faster and smarter.
Stay tuned!