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.