How to Bulk Import Questions into Google Forms (3 Methods)

Why Google Forms Has No Native Bulk Import

Google Forms is designed as a visual form builder where users add questions one at a time through the interface. Unlike Qualtrics (which supports .txt file import via Auto-Number format) or REDCap (which uses a data dictionary CSV), Google Forms has no built-in mechanism for importing a batch of questions from a file. Every question must be added through the form editor or programmatically via Google Apps Script.

For surveys with 20, 50, or 200 questions, adding questions one by one is not practical. The three approaches below solve this problem in different ways.

Method 1: Google Apps Script

Google Apps Script is Google's built-in JavaScript platform that runs inside Google Workspace. Every Google Form has a built-in Script Editor accessible from the three-dot menu. You can write a script that programmatically adds questions to a form, or paste a pre-written script from Pirai AI's output.

Here is a simple working example that adds three questions to a Google Form:

function addQuestions() {
  var form = FormApp.getActiveForm();

  // Multiple choice question
  var q1 = form.addMultipleChoiceItem();
  q1.setTitle('How satisfied are you with our service?');
  q1.setChoiceValues(['Very satisfied', 'Satisfied',
    'Neutral', 'Dissatisfied', 'Very dissatisfied']);
  q1.setRequired(true);

  // Likert scale (Linear Scale)
  var q2 = form.addScaleItem();
  q2.setTitle('How likely are you to recommend us?');
  q2.setBounds(0, 10);
  q2.setLabels('Not at all likely', 'Extremely likely');

  // Open text
  var q3 = form.addParagraphTextItem();
  q3.setTitle('What is the main reason for your score?');
  q3.setRequired(false);
}

To run this: open your Google Form, click the three-dot menu, select Script editor, delete the default code, paste your script, and click Run. For a 50-question survey, the script approach is far faster than the visual editor.

Limitation: Writing the script yourself requires JavaScript knowledge and time to code each question. For large surveys from existing documents, Method 3 (Pirai AI) generates this script automatically from your Word or PDF file.

Method 2: Google Workspace Add-Ons

Several Workspace add-ons (available in the Google Workspace Marketplace) can convert documents or structured data into Google Forms questions. Formswrite, Automagical Forms, and similar tools work as Drive add-ons that read your document and create questions in a Google Form linked to your Drive account.

When these work well: Simple question types (multiple choice, short answer, paragraph) from clean documents. Education quiz conversion where answer keys matter.

Limitations: Most add-ons require granting read/write access to your entire Google Drive. They struggle with matrix questions, Likert scale batteries, and complex question structures. They work within the Google ecosystem only and cannot produce output for other survey platforms.

Method 3: Pirai AI Document Conversion

Pirai AI converts Word, PDF, and Excel survey documents to Google Forms two ways. One-click export: click Export to Google Forms - Pirai AI creates a native Google Form directly in your Google Drive via OAuth. Apps Script: download the generated .txt script and run it in Google Forms yourself - no Drive permissions granted to Pirai AI. Upload at platform.piraiai.com.

This approach handles question types that other methods miss: Multiple Choice Grid (for Likert batteries), Checkbox Grid, Linear Scale with custom labels, and Paragraph questions all convert correctly. A 200-question survey document converts in the same time as a 20-question one.

The key difference from Workspace add-ons: no Drive access is granted to Pirai AI. The document is processed in-memory, the script is downloaded to your device, and you run it yourself inside your own Google account.

Method Comparison

Frequently Asked Questions