How to import questions into Google Forms from Google Sheets

By Jake Marsh · Updated

To import questions into Google Forms from Google Sheets, put one question per row with a header row (Question, Type, Choices, Answer, Points), open your form, and choose Extensions > Quizferry > Build from a question bank. Pick Sheet, then Pick a spreadsheet and the tab, click Check to see any problems by row, then click Build. Each row becomes a question with its answer key and points set.

The sheet layout

Only the Question column is required. Header names are matched loosely (case, spacing and common spellings), and the header row can be anywhere in the first 10 rows. Create a template sheet in the sidebar makes a new spreadsheet with every column and one example of each question type.

ColumnWhat goes in it
QuestionThe question text
TypeMultiple choice, Checkbox, Dropdown, Short answer, Paragraph, True/false or Scale. Section, Title and Image rows add page breaks, text blocks and pictures. Blank means multiple choice when there are choices, short answer when not
ChoicesAll choices in one cell, separated by `
AnswerA letter (B), several (A, C), a number (2) or the choice text. For short answer, accepted answers separated by `
PointsA whole number
Feedback if correct / if incorrectShown after grading. A plain Feedback column fills both
Image URLA PNG, JPG or GIF link, or a Drive file shared as Anyone with the link
SectionQuestions with the same name go on one page
GroupThe pool for random draws (Topic, Unit, Tag and Difficulty work too)
Required, Help text, OtherYes or No; the small text under a question; Yes adds an "Other" box

Steps

  1. Open the form to fill, or a new one at forms.new.
  2. Open Extensions > Quizferry > Build from a question bank.
  3. Choose Sheet, click Pick a spreadsheet and select the bank in the Google Picker. Choose the Tab if the file has more than one.
  4. Set the options. Quiz turns on grading. Points for graded questions without a Points value fills the gaps. Make questions required unless the bank says otherwise saves a Required column.
  5. Click Check. Every problem is listed with its row number: an Answer of E on a question with four choices, a Type the add-on doesn't know, a picture link that won't load. Fix the sheet and click Check again.
  6. Click Build. Watch the form fill in. Long banks run in several steps; leave the sidebar open until it finishes.
  7. Run Finish if you have short answer questions. Finish with the Forms API sets their answer keys, which add-ons can't set any other way.

Importing from Excel or CSV

Quizferry reads Google Sheets. Upload the Excel or CSV file to Drive, open it in Google Sheets, and use File > Save as Google Sheets (Excel) or File > Import (CSV) so the bank is a Google Sheet. Then pick it as above. Columns made for other quiz tools usually work as they are because of the loose header matching.

Updating the quiz later

Edit the rows in the sheet, open the sidebar in the same form, pick the bank from Recent..., and build again with Replace the questions Quizferry built here before ticked. Only the items Quizferry added last time are replaced, in the same spot, so questions you added by hand stay.

What it costs

Quizferry's free trial covers 5 builds or 14 days, whichever comes first, with no card needed. Check and the preview are always free, and a build counts once however many questions it adds. After that it's $9.99 a month or $99 a year per Google account, with no question limit. Install it from the Quizferry page.

Quizferry

Build a Google Forms quiz from a question bank sheet, a Doc or pasted text $9.99 a month or $99 a year per Google account.


Questions

Can I import questions from Sheets into Google Forms without an add-on?

Google Forms' Import questions only copies from another Google Form, so a spreadsheet bank needs an add-on or retyping.

Do my column names have to match exactly?

No. Quizferry matches common names and spellings. If it can't find a Question column in the first 10 rows, Check says so.

Can I mark the right choice inside the Choices cell?

Yes. Put a * in front of the correct choice and leave the Answer column empty.

How do I import true/false questions?

Set Type to True/false and put True or False in the Answer column. No choices are needed.


More Quizferry guides


More Google guides