You have a bank of quiz questions in a spreadsheet — maybe from a textbook, a colleague, or years of building your own — and you need to get them into Google Forms. Google Forms doesn't have a built-in import feature, so what are your options?

In this guide, you'll learn the different ways to import quiz questions into Google Forms, from the manual approach to fully automated methods that can handle hundreds of questions in seconds.

The Problem: Google Forms Has No Import Button

Unlike some other form builders, Google Forms doesn't offer a native way to import questions from a spreadsheet, CSV, or any external file. If you open Google Forms and look through the menus, there's simply no "Import" option.

This means that by default, every question has to be created one at a time inside the form editor. For a quick 5-question poll, that's fine. For a 40-question midterm exam with multiple choice answers, point values, and answer keys? That's a significant time investment.

Here are the main approaches people use to work around this:

Method 1: Type Questions Manually

The most straightforward (and slowest) method. You open Google Forms, click the + button to add a new question, type the question text, add each answer option, mark the correct answer, set the point value, and repeat.

⏱️

Time estimate: A typical multiple-choice question with 4 options takes about 2-3 minutes to enter manually, including setting the correct answer and point value. A 30-question quiz would take roughly 60-90 minutes.

This approach works for small forms, but it doesn't scale. It's also error-prone — it's easy to accidentally mark the wrong answer as correct or mistype an option when you're on question 25 of 50.

Method 2: Use Google Apps Script

If you're comfortable with code, you can write a Google Apps Script that reads data from a Google Sheet and uses the Forms API to create questions programmatically. A basic script might look something like this:

function importQuestions() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var form = FormApp.create('My Quiz');
  var data = sheet.getDataRange().getValues();

  for (var i = 1; i < data.length; i++) {
    var item = form.addMultipleChoiceItem();
    item.setTitle(data[i][0])
      .setChoices([
        item.createChoice(data[i][1], data[i][1] === data[i][5]),
        item.createChoice(data[i][2], data[i][2] === data[i][5]),
        item.createChoice(data[i][3], data[i][3] === data[i][5]),
        item.createChoice(data[i][4], data[i][4] === data[i][5])
      ]);
  }
}

This works, but it has significant limitations:

Requires JavaScript/coding knowledge
Needs to be customized for your specific spreadsheet layout
Doesn't easily handle mixed question types
No support for images or equations in questions
Breaks when your spreadsheet format changes
No GUI — you have to edit code every time

For developers, this is a viable option. For most teachers and administrators, it's not practical.

Method 3: Use SheetFormR (Recommended)

SheetFormR gives you the automation of a script with a visual interface that doesn't require any coding. It's a Google Workspace add-on that connects directly to your spreadsheet and builds the form for you.

Here's the step-by-step process:

Step 1

Prepare Your Question Bank

Organize your questions in Google Sheets. Each row is one question. You'll want columns for the question text, answer options, the correct answer, and optionally point values and question type.

Here's a typical layout:

Question	A	B	C	D	Correct	Points
What is H₂O?	Salt	Water	Oxygen	Hydrogen	B	2
The mitochondria is the _____ of the cell	Brain	Wall	Powerhouse	Nucleus	C	2
Which are prime? (select all)	2	4	7	9	A, C	3

Step 2

Open SheetFormR

From your Google Sheet, go to Extensions > SheetFormR > Launch. The SheetFormR panel will open in a sidebar.

If you haven't installed it yet, go to Extensions > Add-ons > Get add-ons and search for "SheetFormR."

Step 3

Enable Quiz Mode

Toggle Quiz Mode on in SheetFormR. This tells SheetFormR to:

Set the Google Form as a graded quiz
Import correct answers from your spreadsheet
Apply point values to each question
Configure answer feedback if specified

Step 4

Map Your Columns

Tell SheetFormR which column contains what. Use the column mapping interface to assign:

Question text — the column with your question
Answer options — the columns with choices (A, B, C, D, etc.)
Correct answer — which answer is right
Point value — how many points each question is worth
Question type — multiple choice, checkbox, short answer, etc.

SheetFormR also has an Auto-Map feature that will try to detect your columns automatically based on the header names.

Step 5

Click Create Form

Hit the Create Form button. SheetFormR reads every row in your spreadsheet and builds the complete Google Form with all questions, answer choices, correct answers, and point values. The form appears in your Google Drive, ready to share or assign.

✅

Result: A 50-question quiz that would take 2+ hours to enter manually is created in about 30 seconds. All answer keys and grading are already configured.

What Question Types Can You Import?

SheetFormR supports importing all standard Google Forms question types. You can mix and match different types within the same spreadsheet by adding a column that specifies the type for each question:

Question Type	Best For	Auto-Grading
Multiple Choice	Standard quiz questions with one correct answer	✓ Yes
Checkboxes	"Select all that apply" questions	✓ Yes
Dropdown	Questions with many options, saves space	✓ Yes
Short Answer	Fill-in-the-blank, single-word answers	✓ Yes
Paragraph	Essay or long-form responses	Manual review

Importing From Different Spreadsheet Formats

Your question bank might not be in the exact format shown above, and that's fine. SheetFormR's column mapping is flexible enough to handle different layouts. Here are some common formats people use:

Format A: Answer options in separate columns

Each answer option gets its own column (A, B, C, D). The correct answer column contains a letter or the full answer text. This is the most common format and the easiest to work with.

Format B: Answer options in a single column

All options are in one column, separated by commas or line breaks. SheetFormR can parse these with the right delimiter settings.

Format C: True/False questions

For true/false questions, you only need two columns: the question and the correct answer (True or False). SheetFormR will automatically create the two answer options for you.

Format D: Existing forms or PDFs

If your questions exist in a Word doc, PDF, or another non-spreadsheet format, you'll first need to get them into Google Sheets. You can paste them in manually, or use SheetFormR's Forge AI feature to help generate and organize questions from a topic description.

Tips for a Clean Import

Check for blank rows — Empty rows in your spreadsheet can cause issues. Remove any gaps between questions.
Consistent column usage — If a question has only 3 answer options instead of 4, leave the extra column blank rather than shifting columns.
Watch for special characters — Curly quotes, em dashes, and special symbols usually import fine, but double-check formatted content like equations or chemical formulas.
Test with a small batch first — If you're importing 100+ questions, try a test run with 5-10 questions to make sure your mapping is correct before doing the full import.
Use the preview — After creating the form, open it in preview mode to verify questions, answer order, and point values look correct.

After the Import: Next Steps

Once your quiz is generated, you might want to:

Review and tweak — Open the form in the Google Forms editor to make any final adjustments, reorder questions, or add section headers.
Enable shuffling — Randomize question and answer order to prevent cheating.
Assign via Google Classroom — SheetFormR can push the form directly to a Google Classroom assignment, or you can assign it manually.
Set a time limit — Use Google Forms' built-in scheduling or a Classroom due date to control access.
Share the link — Send the form URL to students, colleagues, or respondents.

Frequently Asked Questions

Can I import questions from an Excel file?

Not directly, but you can upload your Excel file to Google Drive, open it as a Google Sheet, and then use SheetFormR from there. The conversion is automatic and takes a few seconds.

Will the import overwrite an existing form?

No. SheetFormR creates a brand new Google Form each time. Your existing forms are never modified.

Can I import images with my questions?

SheetFormR supports equation images for math and science content. For general image support, you can add images to questions after the form is created using the Google Forms editor.

What if some questions are multiple choice and others are short answer?

Add a "Question Type" column to your spreadsheet and specify the type for each row. SheetFormR will create the correct question type for each row during import.

Is there a limit on how many questions I can import?

SheetFormR doesn't impose a question limit. You can import as many questions as your spreadsheet contains. Google Forms itself can handle several hundred questions per form.

Import Your Quiz Questions in Seconds

Stop typing questions one by one. SheetFormR imports your entire question bank automatically.

Try SheetFormR Free →

How to Import Quiz Questions into Google Forms