Creating Google Forms Quiz FREE From Excel (Unlimited Questions)

Creating online exam quizzes in Google forms requires a lot of time specially while making multiple-choice questions & correct answers. It's very difficult to build & import questionnaires for online exam mock tests from Microsoft excel sheets into Google forms.
Free Google Forms Quiz Builder
People also ask; How do I import a question from Excel to Google Forms? Can I import questions to Google Forms? How do I import bulk questions into Google Forms? Can I import spreadsheet into Google Form? Now you can easily import questions from excel to google forms for FREE. Google Forms is the popular choice for creating surveys, quizzes, and other types of forms. You can add unlimited questions and answers to Google Forms using the script. So here on this page, I am demonstrating how to make google quizzes using Excel sheet and google sheets and free script. By using this technique you can easily add all your unlimited questions and answers with multiple choice in the google form.

Use Google Forms to make online forms, mock test, questions with multiple-choice types. You can import questions into google forms from sheets and use Google Forms to create online test quizzes and send them to other people. Moreover, you can customize the forms with pictures, add custom fields, & export form responses instantly to Excel for additional analysis or grading.

As a tutor, you can use Google Forms to quickly assess students. Making a quiz hassle-free, here I am going to use the script, that supports importing questions, question & answers, and quizzes into Google Forms. You just need to add and run the following script and it will create a quiz in the google form. So here this blog is explaining how to create a Google forms online test quiz free from Excel using google scripts.
Creating Google Forms Quiz FREE From Excel
Creating Google Forms Quiz FREE From Excel
{tocify} $title={Table of Contents}

Creating Google Forms Quiz FREE From Excel (Unlimited Questions)

This free form builder helps you to create Google Forms in a very easy and quick method by importing questions/quizzes from existing Google Sheets.

Here you are required to pre-format your existing excel sheet or create a new sheet accordingly as explained below. The form maker script automatically identifies the questions and answers or quizzes to import into the new Google form template. This way the form creator works as an amazing Form builder, Form Maker, and Form Importer tool that you require for FREE.

Build your Google Form quiz free by importing from forms, Google sheets, and Excel sheets:
  1. Start a new spreadsheet by creating a blank Google sheet.
    Creating a blank Google sheet
    Creating a blank Google sheet
    1. After starting a google sheet you need to add your all questions and respective correct answers with multiple options in the sheet as shown. As shown in the picture, you need to;
      • Add all of your questions in column A,
      • Add all the correct answers in column B
      • Add all other remaining 3 options in columns C, D, and E.
      Add your all quiz questions and answers
      Add your all quiz questions and answers
      (Script will randomly mix all the options while building quiz form)
      1. Now to add a script, you need to go to Extensions >> Apps Script.
        Apps Script Extension
        Apps Script Extension
      2. A new tab of Apps Script will open. Here you need to copy & paste the script code into the project. Code is given below. Name the code and save it.
        Copy and paste the script code into the project
        Copy and paste the script code into the project
      3. Script code:
        If you see any previous code in to that box, just remove it and add the following code:
        function popForm() {
         
          var ss = SpreadsheetApp.getActive();
          // var sheet = ss.getActiveSheet();
          var sheet = ss.getSheetByName('Sheet1');
          var numberRows = sheet.getDataRange().getNumRows();
         
            
          var myQuestions = sheet.getRange(1,1,numberRows,1).getValues();
          var myAnswers = sheet.getRange(1,2,numberRows,1).getValues();
          var myGuesses = sheet.getRange(1,2,numberRows,4).getValues();
         
         
          var myShuffled = myGuesses.map(shuffleEachRow);
          Logger.log(myShuffled);
          Logger.log(myAnswers);
         
         
          var form = FormApp.create('Free Online Quiz By ProBlogBooster');
          form.setIsQuiz(true);
         
         
          for(var i=0;i<numberRows;i++){
            if (myShuffled[i][0] == myAnswers[i][0]) {
              var addItem = form.addMultipleChoiceItem();
              addItem.setTitle(myQuestions[i][0])
              .setPoints(1)
              .setRequired(true)
              .setChoices([
                addItem.createChoice(myShuffled[i][0],true),
                addItem.createChoice(myShuffled[i][1]),
                addItem.createChoice(myShuffled[i][2]),
                addItem.createChoice(myShuffled[i][3]),

              ]);
            }
            else if (myShuffled[i][1] == myAnswers[i][0]) {
              var addItem = form.addMultipleChoiceItem();
              addItem.setTitle(myQuestions[i][0])
              .setPoints(1)
              .setRequired(true)
              .setChoices([
                addItem.createChoice(myShuffled[i][0]),
                addItem.createChoice(myShuffled[i][1],true),
                addItem.createChoice(myShuffled[i][2]),
                addItem.createChoice(myShuffled[i][3]),


              ]);
            }
            else if (myShuffled[i][2] == myAnswers[i][0]) {
              var addItem = form.addMultipleChoiceItem();
              addItem.setTitle(myQuestions[i][0])
              .setPoints(1)
              .setRequired(true)
              .setChoices([
                addItem.createChoice(myShuffled[i][0]),
                addItem.createChoice(myShuffled[i][1]),
                addItem.createChoice(myShuffled[i][2],true),
                addItem.createChoice(myShuffled[i][3]),


              ]);
            }
            else if (myShuffled[i][3] == myAnswers[i][0]) {
              var addItem = form.addMultipleChoiceItem();
              addItem.setTitle(myQuestions[i][0])
              .setPoints(1)
              .setRequired(true)
              .setChoices([
                addItem.createChoice(myShuffled[i][0]),
                addItem.createChoice(myShuffled[i][1]),
                addItem.createChoice(myShuffled[i][2]),
                addItem.createChoice(myShuffled[i][3],true),


              ]);
            }
            else {
              var addItem = form.addMultipleChoiceItem();
              addItem.setTitle(myQuestions[i][0])
              .setPoints(1)
              .setRequired(true)
              .setChoices([
                addItem.createChoice(myShuffled[i][0]),
                addItem.createChoice(myShuffled[i][1]),
                addItem.createChoice(myShuffled[i][2]),
                addItem.createChoice(myShuffled[i][3]),


              ]);
            }
          }
        }


        function shuffleEachRow(array) {
          var i, j, temp;
          for (i = array.length - 1; i > 0; i--) {
            j = Math.floor(Math.random() * (i + 1));
            temp = array[i];
            array[i] = array[j];
            array[j] = temp;
          }
          return array;
        }
        1. Once you saved the script code it's time to execute the script. Click on RUN on the Apps script page as shown. Once you RUN the code, you will get the warning message as "Google hasn’t verified this app" or otherwise, google will ask "This project requires your permission to access your data." Here you need to click on "Advanced" and click on go to your code to allow permissions to proceed.

        2. Now go to Google Forms. Your expected Google Forms Quiz is created. You can customize the title and setting as you want.
          Free Google Forms Quiz
          Free Google Forms Quiz


If you enjoyed this article, please share it with your friends and help us spread the word.

Next Post Previous Post
No Comment
Add Comment
comment url
But before you read the page, I just want to tell you that; you can now convert every visitor & every impression in $$$ with the most advanced & reliable monetization platform that having highest fill rate & the best payouts in the industry.
ADTR Network

One day approval. Monetize your traffic from day 1, with 100% fill rates, higher CPM, & quick payouts. Register to Start Earning Right Now →

Join
ADTR Network
Now

New AI-Powered Content Marketing Toolkit
Rated 5/5 stars in 10,000+ reviews. Stay ahead of the competition with next-gen tech adoption by optimizing content for the target audience to drive 3x faster results. Act now to gain a competitive edge in the market.

ADTR

Improve Revenue, Performance,
&
Grow Traffic Faster

Join Adsense Certified Ad Partner
"ADTR is a must have automatic testing tool for serious publishers."
300% Rise
in AdSense Earnings
Get results from Day 1
It's FREE
Read The Case Study

Disclaimer

We are one of the type of a professional review site that operate like any other website on the internet. We respect & trust our readers. And we are confident & would like to mention that the above post contains some affiliate/referral links. And if you make a purchase; we receive commission from the links/apps/products we refer. We are totally unbiased and do not accept paid reviews or fake reviews claiming to be something they are not. We test each product thoroughly and give high marks to only the very best. We are independently owned and the opinions expressed here are our own.

Privacy Policy

All of the ProBlogBooster ideas are free for any type of personal or commercial use. All I ask is to keep the footer links intact which provides due credit to its authors. From time to time, we may use visitors/readers, information for distinct & upcoming, unanticipated uses not earlier disclosed in our privacy notice. If collected data or information practices changed or improved at some time in the future, we would post all the policy changes to our website to notify you of these changes, and we will use for these new purposes only data collected from the time of the policy change forward. If you are concerned about how your information is used, you should check back our website policy pages periodically. For more about this just read out; Privacy Policy