Create a quiz in Excel

  • HOME
  • Create a quiz in Excel

Create a quiz in Excel

Microsoft Excel and Google Spreadsheet are available.
This page explains how to create a quiz using Excel.

1. Create a problem

Problems can be created from a spreadsheet.
The template can be downloaded from
(*Please note that the more questions you have, the longer it will take when using the conversion tool and the uploader.)

Japanese: format English: format

2. the procedures and rules for creating questions

    • Add#format:tablein column A. If this description is missing, it will not work properly.
      column A column B column C column D column E
      #format:table
    • To add other options in column A. Enter them in line 2, 3 or more if desire.
      Options: Roman characters starting with #

      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
    • Enter a Quiz sentence in column A following the options, a Quiz format in B, a correct answer in C, and incorrect answers in D and beyond.
      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
      Quiz sentence Quiz format Correct answer Incorrect answer 1 Incorrect answer 2
      Dry ice is the solid form of sa: Carbon dioxide Oxygen Nitrogen
    • If you start a new line, it will be recognized as the next quiz.
      column A column B column C column D column E
      #format:table
      #shuffle_questions:true
      Dry ice is the solid form of sa: Carbon dioxide Oxygen Nitrogen
      What is the capital city in Japan? sa: Tokyo Osaka Osaka

      When all questions are completed, save the file.

      3. generate quizzes using the conversion tool

      Select the created question data and click the "Convert" button to generate the quiz player.
      For more information on the process of conversion, see "Conversion ToolPlease refer to the page "3.
      You can check the contents of the quiz you have created by clicking on the menu button below.
      Preview → Displays the conversion result.
      Download → Download the conversion results.
      Limited publication → publish only to those who know the URL.
      General Release → Open to the public on the QuizGenerator website.
      *Copy and paste the tag (IFrame) for embedding the quiz for limited public use, and you can put the quiz you created on your blog or website.

      FAQ

      When entering English characters, the first letter is capitalized.
      Move the mouse cursor over the cell that will be capitalized and right-click>Format Cells.

      Next, select a string from the classification (C) and click the OK button.