What importing into Google Forms means

Importing in Google Forms means bringing questions from another source — usually a spreadsheet, a CSV file, or another form — into a new or existing Google Form without typing each question manually. Google Forms does not have a built-in import button. Instead, you move questions in by copying them from a spreadsheet, pasting them into the form, or using a script that reads from a Google Sheet and populates the form automatically.

The most common path is copying questions from a Google Sheet, pasting them into the form's question editor, and letting Google Forms parse them into separate questions. This works best when your source file is already organized — one question per row, with answer choices in a predictable format.

A second path uses Google Apps Script, a free automation tool built into Google Sheets and Forms. A script can read rows from a spreadsheet and create questions in your form in seconds, which saves time if you are importing dozens of questions or doing this repeatedly.

Key Takeaways

  • Google Forms has no native import feature, but you can copy questions from a Google Sheet and paste them into the form's question field to create multiple questions at once.
  • Your source spreadsheet should have one question per row, with answer choices separated by commas or on separate rows, so the form can parse them correctly.
  • Google Apps Script can automate the import process if you have many questions or need to repeat the import regularly, though it requires basic familiarity with code.
  • Imported questions land at the bottom of your form; you can reorder them afterward by dragging them into place.
  • Question type (multiple choice, short answer, dropdown) must be specified in your source file or set manually after import.

Preparing your spreadsheet for import

Before you import, organize your source data in a Google Sheet so Google Forms can read it correctly. Open a new Google Sheet and create columns for the information you need: question text, answer choices, and question type.

In the first column, write the full question text. In the second column, list the answer choices separated by commas — for example, "Yes, No, Maybe" — or put each choice on its own row if you prefer. If your form uses different question types (multiple choice, checkboxes, short answer), add a third column labeled "Type" and write the type name: "Multiple choice", "Checkboxes", "Short answer", "Dropdown", or "Linear scale".

Keep the format straightforward and consistent. Do not use special characters, line breaks, or extra spaces in the question text itself, as these can cause parsing errors when you paste into the form. Test with a few rows first before you prepare a large batch.

Copying and pasting questions from a spreadsheet

Open your Google Form in one browser tab and your prepared Google Sheet in another. In the Sheet, select the cells containing your questions — usually column A if you have one question per row. Copy the selection using Ctrl+C (Windows) or Cmd+C (Mac).

Switch to the Google Form tab. Click the plus icon (+) at the bottom left of the form to add a new question. In the question text field, paste your copied text using Ctrl+V or Cmd+V. Google Forms will attempt to split the pasted text into separate questions based on line breaks.

After pasting, Google Forms shows you a preview of how it parsed the questions. Review each one to confirm the text and structure are correct. If the parsing is wrong — for example, if answer choices ended up in the question text — delete the batch and try again with a different format in your spreadsheet.

Once the questions are in the form, set the question type for each one. Click the dropdown menu on the right side of each question (the three vertical dots) and select "Question type". Choose from Multiple choice, Checkboxes, Dropdown, Linear scale, Short answer, Paragraph, Date, Time, or File upload. If your spreadsheet included a Type column, this step confirms what you already specified.

Using Google Apps Script to automate import

If you have many questions or import regularly, a Google Apps Script can read from your spreadsheet and create questions in the form automatically. Open your Google Sheet, click "Extensions" in the menu, then "Apps Script". A new tab opens with a blank script editor.

Paste this basic script into the editor:

function importQuestions() { var sheet = SpreadsheetApp.getActiveSheet(); var formId = "YOUR_FORM_ID_HERE"; var form = FormApp.openById(formId); var data = sheet.getRange(1, 1, sheet.getLastRow(), 3).getValues(); for (var i = 0; i < data.length; i++) { var question = data[i][0]; var choices = data[i][1].split(","); var type = data[i][2]; if (type === "Multiple choice") { form.addMultipleChoiceItem().setTitle(question).setChoiceValues(choices); } } }

Replace "YOUR_FORM_ID_HERE" with your actual form ID. To find it, open your Google Form, click the three-dot menu at the top right, select "Get pre-filled link", and copy the long string of characters after "formkey=" in the URL. Paste that string between the quotes in the script.

Click the play button (▶) to run the script. The first time you run it, Google asks for permission to access your Sheet and Form. Grant permission, and the script reads your spreadsheet and creates questions in the form. This approach works for multiple choice, checkboxes, and dropdown questions; other question types require slightly different code.

Handling answer choices and question types

Answer choices must be formatted consistently so the form can parse them. If you are pasting from a spreadsheet, separate choices with commas on the same line: "Red, Blue, Green, Yellow". If you are using a script, the script splits on commas automatically, so the same format works.

Some question types do not have answer choices — short answer, paragraph, date, and time questions accept any input from the respondent. When you import these, leave the answer choice column blank or write "N/A". The form will not create choice fields for them.

Linear scale questions need a range, usually 1 to 5 or 1 to 10. In your spreadsheet, write the range as "1-5" or "1 to 5" in the choices column. After import, click each linear scale question and adjust the range and labels (such as "Not satisfied" to "Very satisfied") manually, as the import process does not parse these details.

Reordering and editing imported questions

Imported questions appear at the bottom of your form in the order they were imported. To move them, click and drag each question by the six-dot handle on the left side. Drag it up or down to place it where you want it in the form sequence.

Edit any question after import by clicking on the question text or answer choices. The same editing tools available for manually created questions work here: you can change the question text, add or remove choices, make a question required, add descriptions, or change the question type.

If you imported a batch and several questions need the same change — for example, making them all required — you can edit them one at a time. There is no bulk edit feature in Google Forms, so plan for this step if you are importing a large number of questions.

Troubleshooting common import problems

If pasted questions do not split into separate items, the spreadsheet format may not match what Google Forms expects. Try copying just the question text column (without answer choices) and pasting that first. Then add answer choices manually or in a second paste.

If a script runs but creates no questions, check that the form ID is correct and that your spreadsheet data is in columns A, B, and C starting from row 1. The script looks for data in those exact locations. Also confirm that the question type in column C matches one of the types the script recognizes — "Multiple choice", "Checkboxes", or "Dropdown".

If answer choices appear as a single long string instead of separate options, the script or paste operation did not split them correctly. In your spreadsheet, make sure choices are separated by commas with no extra spaces: "Yes,No,Maybe" works better than "Yes, No, Maybe".

If you see an error message when running a script, check that you granted permission the first time you ran it. If you denied permission by mistake, delete the script project and create a new one, then run the script again and grant permission when prompted.

Frequently Asked Questions

Can I import questions from a Microsoft Excel file?

Not directly. read the Excel file as a CSV, then upload it to Google Drive and open it as a Google Sheet. From there, follow the copy-and-paste method or script method described above. Google Forms only reads from Google Sheets, not from Excel files stored locally.

What if my questions have images or special formatting?

The import methods described here handle text only. If your questions include images, links, or bold text, import the text first, then add images and formatting manually in the form editor. Click the image icon in the question editor to add an image after import.

Can I import questions into an existing form without overwriting what is already there?

Yes. Imported questions always land at the bottom of the form, so your existing questions stay in place. After import, drag the new questions to reorder them as needed.

How do I import questions that require specific answer validation, like email addresses?

Validation settings (email, URL, number range) cannot be set during import. Import the questions first, then click each one, select "Response validation" from the three-dot menu, and set the validation rule manually.

Is there a limit to how many questions I can import at once?

Google Forms does not publish a hard limit, but importing more than 100 questions at once may be slow. If you have a very large batch, split it into groups of 50 and import each group separately.