Skip to content
Home » Google » Google Forms: Paste a LOT of Student Names

Google Forms: Paste a LOT of Student Names

Tip for using Google Forms: Try to use Multiple Choice and Drop Down options as often as possible. When you let students or others fill in the Form with open response answers it is difficult to sort and filter by that response. If possible, add a drop-down list of the student names for them to choose on the Form.

Want More Help with This? Become a Premium Member

Multiple Choice, Checkboxes, Dropdown

Any of the question types in Google Forms that let you present the responder with a list of options you can PASTE the list. No need to tediously type (or copy paste) each option one at a time.

Paste All At Once

You do NOT need to copy and paste each name one by one. On the multiple choice question choose “Option 1.” While Option 1 is highlighted use Control V to paste the list of names.

Separate Options

If you have question options in a Word Document, Google Doc, or a spreadsheet you can copy and paste into options lists, the entire list at once, into Google Forms. The trick is, each option needs to be on it’s own line. In Word or a Google Doc this means your options are on different lines. You have pressed Enter between each option choice. In Google Sheets this means each option is in it’s own cell, vertically.

Paste Special

If your options are NOT pasting correctly try pasting them into a Google Sheets spreadsheet but hold down the SHIFT key when pasting. Control Shift V is paste special and sometimes this will fix some of your copy paste woes.

How to Update Student Spreadsheets

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.