Docs / Excel

Make a quiz from Excel

Have 20 questions in a spreadsheet? Import them together instead of entering each one in the editor. You can write the workbook yourself, or ask an AI assistant that can create spreadsheets to build it for you.

Download the Excel template Go to My Quizzes

Import a workbook

1. Open My Quizzes, select Create a quiz, then Import from Excel.
2. Download the template above or from that dialog. Open its Main sheet, change the sample title and questions, and save the file as .xlsx.
3. Choose the file in the import dialog. frogQuiz checks it and previews the questions, answer options and correct answers. Nothing is created during preview.
4. If a row has a problem, fix it in the spreadsheet and choose the file again. When the preview is right, select Create quiz. The quiz opens in the editor, where you can add images or make other changes before hosting.

You can create quizzes without an account when guest creation is enabled. Guest quizzes remain tied to that browser and expire after 30 days unless you add them to an account. Signing in is the safer choice for anything you want to keep.

What goes where?

The importer reads the Main sheet. The template also contains Every type, with an example of each question type, and For agents, with instructions for spreadsheet-making assistants. The latter two sheets are guides, not additional questions.

This is a shortened example: keep all the original template headings and columns, even ones you leave empty. The title goes in Main!C5, the optional description in Main!C6, headings in row 13, and questions from row 14. Correct Answers uses answer positions, not text: 1 for the first option or 1,3 for two correct options.

Which questions can I import?

• Multiple choice / True or False: one right answer.
• Check choice: more than one right answer, such as 1,3.
• Poll: options with no correct answer and no points.
• Type answer: list the spellings you will accept.
• Slider: minimum in Answer 1, maximum in Answer 2, correct number or range in Correct Answers.
• Put in order: list items in their correct order.
• Info slide: put the slide's text in Answer 1, with no answer key or timer.
• Word cloud: players supply the words; leave answers and the answer key empty.
• Ranking: players arrange items by preference, not by a right order.

Use Type to name the question type. The Every type tab shows a complete example for each one, including where to leave cells blank. For more than four options, add consecutively named answer columns before the Time column.

Make the Excel file with AI

Microsoft 365 Copilot or another assistant with spreadsheet-creation tools can prepare a .xlsx workbook for frogQuiz, if your version can export Excel files. Provide the downloaded template so the assistant retains the right sheet names, columns and question rules. Import the generated file through the normal preview, with no account key or AI plugin required.

For example, you can ask:

Make a 15-question frogQuiz Excel workbook from this template for a team social. Mix multiple choice, polls, a word cloud and a ranking. Keep the questions easy to read aloud, include correct answers where needed, and leave all the template's column headings intact. Give me the completed .xlsx file to import.

Check factual answers before playing. An agent can produce a plausible-looking answer that is wrong, and a valid workbook does not make the facts correct.

Prefer the direct route? A connected frogQuiz MCP agent can create and edit quizzes in your account without a spreadsheet. A connected agent can also export an owned quiz as base64-encoded .xlsx bytes, or preview a workbook without saving it. To hand you a downloadable file, the assistant still needs an environment that can save the exported bytes.

Good uses for Excel

• Team nights: collect everyone's questions in one sheet, then import once.
• Lessons and training: turn an existing question bank into a hosted quiz.
• Parties: ask an assistant for a themed quiz and review every answer before playing.
• Reuse: download one of your own quizzes as an Excel file and import it as a new quiz.

Limits and common problems

• Up to 50 questions per import and a 2 MB .xlsx file.
• Question text is limited to 250 characters; individual answers to 100 characters. Timed questions use whole seconds from 1 to 999.
• Use plain text and numbers. Formulas, pictures, macros and password-protected files are not imported. Add images in the editor afterward.
• If the preview reports a row or column error, edit that cell and upload the file again. Import does not silently skip invalid rows.
• For a correct-answer question, check that the numbers refer to filled answer cells.

Want the rest of the workflow, including editing, hosting and player phones? See how frogQuiz works.

AI agents: Connected MCP clients can use preview_excel_import to check workbook rows without creating a quiz, and export_quiz_excel for an owner-only download encoded as base64. MCP limits workbook payloads to 128 KiB; the browser's Excel import supports up to 2 MB. See AI agents.