How to Link Google Forms to Google Spreadsheet

Linking Google Forms to Google Sheets is a very simple task. But before you learn the steps, you need to know that the Google Forms is an individual software, and it operates seamlessly. So, operating it wouldn’t be a complicated stuff. Just read the article below and learn about the steps.

Contradictory to popular belief, the procedure to link Google Form to Sheets is a simple one. As it is not a well-known method, the users get skeptical. But don’t worry, all the details are provided below.

Solution 1 - Link Google Form to Sheets: Using Google Form

In this part, we will discuss the procedure to link Google form to spreadsheet. Before we proceed with the steps, you have to remember that Google Forms is an individual program, and all its responses will be visible.

  • Step 1: So, go to ‘Responses’ and click on ‘Summary’.
  • Step 2: After that, click on ‘More’ and select the response destination.
  • Step 3: Now, choose ‘Create a New Spreadsheet’.

Lastly, you just have to click on ‘Create’ again, and you will be able to open response on Google Sheets.

Solution 2 - Link Google Form to Google Sheets: using Zapier Software

In this part, we will be using Zapier to make Google form dropdown from sheet. Zapier is a 3rd party program designed for this task particularly.

Google forms are the most versatile tools on the internet. But to make one, it takes only a minute. The Zapier program works seamlessly with Google Forms; it will be easy to use it to link it with Google Sheets.

  • Step 1: After you have created the form, the answers will be saved in the ‘Responses’ tab.
  • Step 2: So, after that, click on the green sheets icon under the ‘Responses’ tab, or you can also click on ‘Select Response Destination’ on the menu.

    response tab

Extra Tips: How to Open Password-Protected Excel Spreadsheet

In the previous part of this article, we have discussed the procedure to link Google form to Google sheet. What some of the users thought to be an impossible task, we made sure to make them realize that it is possible. The steps are simple, and for their convenience, we have laid them out in intricate details. But this part of the article is dedicated to something completely different. We are here to discuss the way to recover the password of a locked excel spreadsheet.

There are a few well-known methods discussed on several online forums, but we recommend using a professional password recovery program for the successful recovery. There are several options available, but we recommend the use of PassFab for Excel. This is a genuine program with the capability of fast password recovery. The steps are very simple. Check out the guide below.

  • Step 1: Download and install PassFab for Excel on your computer. Run the program and click on ‘Recover Excel Open Password’ on the interface.

    passfab for excel
  • Step 2: Then, click on ‘Please Import Excel File’ and add the encrypted file.

    import the locked document
  • Step 3: After that, you have to specify an attack mode. There is a Dictionary attack, Brute Force attack, and Brute Force with Mask.
  • Step 4: After selecting the attack style, the program will start the recovery of the Excel password.

    password recovery successful

The recovery will take a few moments, but the required time depends on the complexity of the password.


Therefore, we have detailed the ways to link Google Form to spreadsheet in the simplest way possible. The steps are easy, and if you follow them properly, you will be successful. By the way, if you are looking for a way to recover password for your locked MS Excel spreadsheet, then PassFab for Excel is the best way to go about it.

Updated on / Posted by Shirley Howard to Useful Tips / Follow @Shirley Howard


Product-related questions? Speak directly to our Support Team >>