How to Collect Data from Google Forms in Google Sheets - Full Guide

Every answer your form collects is already waiting in a spreadsheet. You just have not connected them yet. This tutorial shows how to collect data from Google Forms in Google Sheets: link the form from Responses, turn responses on, test it with a real submission, point an existing form at a spreadsheet you already have, and pull the answers into a second tab with QUERY so the raw data stays untouched. Chapters: 0:00 - The problem: answers stuck inside the form 0:15 - Build the form: three questions 0:41 - Link it: Responses, then the green Sheets icon 1:07 - Turn responses on and test it with Ana and Ben 1:41 - Already have a sheet? Select an existing destination 2:11 - Work with the data: QUERY on a second tab 2:42 - Recap: one form, one destination Every answer your form collects is already waiting in a spreadsheet. You just have not connected them yet. One click links them and every new response lands as a fresh row automatically. Here is the fastest way first. First, the form itself. Open Google Forms and start a blank form. I will call it Team Lunch Survey and add three questions: a name, a favorite lunch, and a one to five rating. The lunch question is multiple choice, pizza, sushi, or salad, and the rating is a linear scale. Nothing fancy, the link works the same whether you have three questions or thirty. But where do the answers actually go? That is the next step. Click Responses at the top of the editor, then the green Sheets icon on the right. A box asks where the answers should live. Pick Create a new spreadsheet. Google names it after your form and opens it for you. The first tab is called Form Responses 1. Column A is the timestamp and every column after it is one of your questions in the same order. So the link is live, but the sheet is still empty, nothing lands in it until someone answers. First turn responses on, click Published at the top, flip Accepting responses on, and save. Then open the live form with Copy responder link, the preview eye can show the form, but it cannot submit anything. Fill it in as Ana, pizza, four out of five, and hit Submit. Back in the sheet a new row appears within a couple of seconds, timestamp, name, lunch, rating. One more as Ben with a different lunch and it lands right underneath in order. No copy, no paste, no refresh, that is the whole loop. But what if you already have a spreadsheet you want to use? Back in the form open Responses again, click the three dots beside the Sheets icon and choose Select destination for responses. This time pick Select existing spreadsheet, find your file, and click Insert. Google adds a fresh Form Responses tab to that workbook with your answers so far already copied in and new answers land there from now on. And if you ever change your mind, the same menu has Unlink form, the sheet, and its data stay put. One form, one destination at a time. Now one rule before you start working with the data. Never edit the Form Responses tab itself. Google owns that tab and your edits can be wiped out by the next submission. Add a second tab instead and pull the data across with a formula, equals QUERY, Form Responses 1, select star. Now sort it, filter it, or chart it, the raw answers stay untouched. And the analysis rebuilds itself every time a new row arrives. Raw data in one tab, your work in another, that is the setup that survives a thousand responses. So: build the form, link it from Responses, and test it with one submission. Every answer from here on files itself into your sheet. What will you collect first? Tell us in the comments.