If you’re like most people, you probably use Google Sheets to keep track of your finances, manage your to-do list, and more. But did you know you can also use it to collect data from your users? Google Forms is a great way to do just that. It’s easy to set up and use, and it can help you gather data from your users in a variety of ways. In this article, we’ll show you how to add a Google Form to Google Sheets using the steps below.

  1. Open Google Sheets and create a new sheet (or open an existing sheet if you already have one).
  2. On the Home tab, click the Forms button ( ).
  3. In the Forms panel that appears, click New Form ( ).
  4. In the New Form dialog box that appears, enter a name for your form (for example, “User Survey”). Under Category, select Survey. Under Type, select Google Form. Under Description, enter a brief description of your form (for example “Collect user feedback”). Click Create Form. ..

When you create a Google Form, you can record the responses in Google Sheets. But you can also do the reverse and create a form right from your spreadsheet. This attaches the two together and records the responses automatically.

Maybe you’re tracking project updates and want to use Google Forms to gather those updates from your team. Or perhaps you’re logging feedback for a new product and want to send out a product survey. When you have a spreadsheet in Google Sheets and want a form related to that data, this is a great way to do it.

Create a Google Form From Google Sheets

Head to Google Sheets and open a workbook. You can also create a new workbook if you prefer. You don’t have to select a particular sheet to get started either. Once you create the form, Google Sheets will set up a new Form Responses tab in the workbook.

Click Tools > Create a New Form from the menu.

This creates the response sheets in your workbook and opens Google Forms in a new browser tab with a blank form ready for your questions. As you add questions to the form, you’ll see these populate in real-time as column headers in the Form Responses sheet in the workbook.

Complete your form setup as you normally would.

If you create additional forms from the same Google Sheets workbook, the response sheets will be named and numbered as Form Responses 1, Form Responses 2, and so on. You can rename the sheet(s) if you wish.

View Form Responses in Google Sheets

Once you share your form with others and begin receiving responses, you’ll see those responses on the appropriate tab in Google Sheets. These are also added immediately, just like the questions you set up.

You’ll also notice a convenient Timestamp column in the sheet that records the date and time for each response automatically.

Manage the Google Form From Google Sheets

In addition to creating your Google Form from Google Sheets and receiving the responses, you can take a few other actions on the form from Sheets. This is a handy way to edit your form, view it, send it, and more without having to open and log into Google Forms separately.

Click Tools > Manage Form from the Google Sheets menu. You’ll see your options in the pop-out menu.

Edit Form: Open the form in a new browser tab to make changes. Go to Live Form: Open the live form in a new browser tab as your respondents see it. Send Form: Open the form directly to the Send Form options to share it. Embed Form in a Webpage: Open the form directly to the Embed HTML for you to copy. Show Summary of Responses: Open the Responses section in Google Forms with the Summary tab already selected. Unlink Form: If you finish accepting form responses, you can unlink the form and then move or delete the connected sheet if necessary.

RELATED: How to Limit Responses in Google Forms

With the real-time integration of Google Forms and Google Sheets, you can save the step of selecting a location for responses after the form creation. This direct connection gives you a way to view responses and analyze that data on the spot.