Bulk Upload Questions to Google Forms: Add Dozens of Questions at Once

Updated November 12, 2026 · ~10 min read

"Bulk add questions to Google Forms" is the problem every teacher hits when a question bank already exists: 50 questions in a document, and the Forms editor only lets you add them one at a time. There is no bulk import button in Google Forms. This guide lays out the three methods that actually work — manual entry, a script against the Forms API, and a one-click importer that parses your existing text — with runnable code, a column layout, and the traps that break a large import.

Why Google Forms has no bulk import

The Forms editor creates one item at a time. Its only native "import" is duplicating an existing Form in Drive — not reading a document, CSV or text file. Google's help centre confirms there is no built-in way to bulk upload questions from a file. That gap is why people search "bulk add questions to google forms" and "bulk upload questions to google forms".

Three consequences: (1) typing 50 questions takes an hour and invites typos; (2) the answer key, marks and option order are easy to lose when copying manually; (3) any automation must map your source into the item types Forms understands (multiple choice, checkbox, short answer, paragraph, etc.).

Three methods compared

Method 1 — bulk-create items with Apps Script (runnable)

If you want to own the automation, put your question bank into a sheet with columns Type, Stem, A…E, Answer, Points, then run this complete script from a spreadsheet-bound Apps Script project. It creates every item in one pass, with the correct-answer flag attached to the choice.

function bulkAddQuestions() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const rows = sheet.getDataRange().getValues();
  const h = rows[0].map(x => String(x).trim());
  const c = n => h.indexOf(n);
  const form = FormApp.openById("YOUR_FORM_ID");
  let n = 0;

  for (let r = 1; r < rows.length; r++) {
    const v = rows[r];
    const stem = String(v[c("Stem")] || "").trim();
    if (!stem) continue;
    const opts = ["A","B","C","D","E"]
      .map(k => String(v[c(k)] == null ? "" : v[c(k)]).trim())
      .filter(Boolean);
    const answer = String(v[c("Answer")] == null ? "" : v[c("Answer")]).trim();
    const pts = Number(v[c("Points")]) || 1;
    const type = String(v[c("Type")] || "mcq").toLowerCase();

    let item;
    if (opts.length && (type === "mcq" || type === "multiple choice")) {
      const choices = opts.map(o => form.newChoice(o, o === answer));
      item = form.addMultipleChoiceItem().setTitle(stem).setChoices(choices);
      item.setPoints(pts);
    } else if (opts.length && type === "checkbox") {
      const correct = answer.split(",").map(x => x.trim());
      const choices = opts.map(o => form.newChoice(o, correct.includes(o)));
      item = form.addCheckboxItem().setTitle(stem).setChoices(choices);
      item.setPoints(pts);
    } else {
      item = form.addTextItem().setTitle(stem);
    }
    item.setRequired(false);
    n++;
  }
  Logger.log("Added " + n + " items");
  // Turn on quiz mode + answer key in Settings > Quizzes afterwards.
}

Notes: form.newChoice(value, isCorrect) is how the answer key is attached; without quiz mode enabled in Settings, correct flags are ignored. Forms caps an individual item's options and has a practical limit on total items per form, so split very large banks into sections or multiple forms. Running the script twice duplicates everything — clear the form or track IDs.

Method 2 — one-click import from the file you already have

If you do not want to maintain code, the direct route is to upload the source file (PDF, Word, Excel, Google Docs, Google Sheets, plain text or RTF) and let a converter parse it into rows, then write the whole form under your own Google account. The important property is that questions, choices, the correct answer and marks stay together in one row, so a 200-question bank behaves exactly like a 5-question one. See How to Import Questions into Google Forms for the full method map, and Convert File to Google Form for the umbrella workflow.

Bulk upload questions to Google Forms in 5 steps

Troubleshooting a large import

• Only some questions appear. A blank Stem row aborts or skips; check for merged cells and stray blank lines in the source.
• Options are in the wrong order. The importer reads columns in fixed order A→E. Never sort the rows after export.
• Answer key is missing. Quiz mode must be enabled in the form Settings, and the correct flag must be attached to the choice (not written as a separate note).
• Points are all 1. The Points column must be numeric; text values silently fall back to 1.
• Duplicate questions. The script or upload ran twice. Clear the form before re-running.
• Special characters show as gibberish. Save the source as UTF-8 (with BOM if your spreadsheet tool needs it).
• Images are gone. Forms cannot bulk-attach images from a file; keep one public image URL per question and add it after import.
• "Form has too many items". Split into sections or separate forms; very large banks also slow the editor.

Frequently asked questions

Question importers

ExamParser has a dedicated importer for each source format. Pick the one your questions currently live in — PDF, Word, Excel, Google Sheets or a quiz file — and the questions, options and answer key are carried into a Google Form you own.

Related guides

• How to Import Questions into Google Forms (every method)
• CSV to Google Forms (question bank without re-typing)
• Text to Google Form (plain text source)
• Convert File to Google Form (umbrella)
• Import Multiple Choice Questions into Google Forms
• TXT to Google Form (.txt files)

Import the whole question bank in one pass

Stop adding questions one at a time. Upload the file you already have and get a Google Form you own, with the questions, options, answer key and points carried over exactly as written. Deterministic, no AI rewriting.