Home » Google » How To Make a Form from Google Sheets

How To Make a Form from Google Sheets

Google Sheets recently updated the menus and icons. There is no longer a Form menu. Find it under Tools.

Not What You Think It Is

“Create a new form” in the Tools menu will indeed create a new Google Form. However, it is relatively the same as just going to http://forms.new. The Form is blank!

There is no way to take the questions off of your spreadsheet to create a Form.

Natively, the Form created is just a blank Form. If you want to create a Form from a spreadsheet you can use alicekeeler.com/form or use another Add-on like Form Creator. However, the Form you create from the Tools menu will link the current spreadsheet to the Form you create. That is helpful. I noticed though that even though my default for making a new Form is to collect email addresses, the Form created from the spreadsheet did not have that setting. I had to enable that manually on the settings tab.

Linked Responses Sheet

Purple form icon on the tab.

You can tell which sheet is receiving the responses from the spreadsheet as it has a purple Form icon. If you unlink the sheet from the Form, the icon will go away.

Want More Help with This? Become a Premium Member

Manage Form

You can find what was the old “Form” menu integrated into the Tools menu.

Tools menu and choose manage form to see the menu of options.

If you have a Form linked to the spreadsheet you will see the option for “Manage form.” You can then

  • Edit form
  • Go to live form
  • Send form
  • Embed form in a webpage
  • Show summary of responses
  • Unlink form

Edit Form

Edit form will open the Form in a new tab to allow you to edit. This is really handy so you do not need to go back to Google Drive and figure out which Form is feeding into this particular spreadsheet.

Go to live form

This takes you to the Form that can be filled out. Use this option to add entries to the Form.

Send Form

As you are reviewing the Google Form, you may notice that someone has not filled it out but should have. Send them the link to the Form.

Embed Form in a Webpage

This takes you to the sharing screen of the Google Form to copy the embed code.

Show Summary of Responses

You can share the summary charts with students or colleagues by using the link that this option sends you to.

Unlink Form

Choosing this option disconnects the Form from the spreadsheet. The copy of the Form results will remain in the spreadsheet. However, new responses to the Form will not populate in the spreadsheet any longer.

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…

Collaborate with Students – reuse TemplateTab

Reuse TemplateTab to collaborate with students and have less paperwork to grade.

First S

CS First is a great way to get started with teaching students computer science even if you as the teacher do not have experience with coding or computer science. First s … science! It is critical th…

4 Tips for Google Bookmark

4 Tips for Google Bookmark. If you use Chrome here are some ways to use the Bookmarking feature.

Leave a Reply

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