Creating Google Forms Quiz FREE From Excel (Unlimited Questions)

Ezoic Review

Join Adsense Certified Ad Partner
"Ezoic 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

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

You may also like to know;

• Top 108 Hey Google Assistant Commands, Voice Searches, and Actions
• Top 30 YouTube Tricks, Features and Hacks to Improve User Experience

{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

2. 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

   (Script will randomly mix all the options while building quiz form)
3. Now to add a script, you need to go to Extensions >> Apps Script.

   

   Apps Script Extension

4. 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

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;
}

5. 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.
   
   
6. 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