To send Google Forms responses to Google Sheets, open the form in the editor, go to Responses and choose Select destination for responses. Pick a new spreadsheet or select an existing one. Open the linked file and submit a sample response through the respondent link to confirm that a new row appears.
Keep the response table as your intake record and build working lists and reports on other tabs. If different people should see the raw answers and the report, use separate files and check the sharing settings for each. Linking the form and spreadsheet connects their data flow, while the two files still have their own permissions.
- Create a new spreadsheet when the answers need a separate home.
- Select an existing spreadsheet when the existing audience should see the incoming answers.
- Submit a recognisable test entry and check the timestamp and answer columns.
- Keep team notes, reporting formulas and filtered outputs separate from raw intake.
- Check both files’ sharing settings when handing over or removing access.
Connect the form to a new spreadsheet
Open the form as an editor. The page for filling in the form is for submitting answers. The editor is where you can see the Questions, Responses and Settings tabs. Choose Responses, open the More menu and select Select destination for responses. If the Sheets icon says Link to Sheets, you can start there.
Choose Create a new spreadsheet, give it a distinctive name, and click Create. An event name and year are more useful than “Sign-ups” when you search Drive later. For example, use “June Reading Workshop 2027 — response intake”. Open the linked spreadsheet from the Responses tab and identify the tab holding the incoming records.
Look across the first row. You should see a timestamp and headings for the questions. Use those headings to check the shape of your intake. If two columns are both called “Name”, work out which question each corresponds to before you build a report. Give the questions distinct wording while the form is still in testing.
Verify one submission end to end
Open the responder link with an account allowed to submit. Enter an obvious marker in a free-text field, such as “TEST — round 1”, where the form permits it. Record the time and submit. Open the sheet from the editor again, locate the new timestamp and check each answer against what you entered. If you have a separate report, check that the row is handled there as intended.
A test from the owner’s account proves that the owner can submit. If the expected audience includes people outside your school or organisation, use an appropriate account to test that route too. Keep test details fictional. When testing a live form, decide how reports will distinguish test submissions before you send one.
Back to contents · Next section
Use an existing spreadsheet as the destination
Choose Select existing spreadsheet when the form belongs with an existing workbook. Select the spreadsheet file through the picker and confirm. Open the destination again through the form and find the response tab Google Forms added. The choice in the picker is a spreadsheet file. A dashboard tab inside that file is still a separate place to build your reporting.
This works well for a team whose members already have permission to see every answer. For example, the same two organisers who own a reading workshop tracker might need to see every registration. Keeping both tabs in one file makes it easier to navigate between them. Check any existing sharing links and inherited access before using that arrangement.
Compare the audience before you choose
Imagine the intake collects a parent’s email address and a session choice, while volunteer helpers only need a count by session. Give the organisers the response file and publish counts in a separate spreadsheet. Sharing the full workbook with helpers and hiding the intake tab would give them a file with information beyond their role. A filter view likewise changes which records appear on screen, while the file permissions stay the same.
Previous section · Back to contents · Next section
Work with a response table and a reporting tab
Treat one tab as the record of what arrived. Put summary formulas, calculations and notes in a separate reporting or workflow tab. That lets you change a chart, calculate session totals or review unanswered entries while keeping the original response fields available for checking. For simple counts, begin with a clearly labelled list of choices and a count next to each choice.
Suppose the session choices are Saturday 10 am and Saturday 2 pm. A useful report shows both counts, a total and a place for answers requiring review. It also says whether the count represents all submissions, confirmed places, or unique registrants. Three people filling the form twice produce six submissions. If the team wants to count people, agree on the identifier and how you will handle updates before reporting the number.
Pair status notes with an identifier
A notes column typed next to a report can drift away from the right person when the report is re-sorted or regenerated. Keep staff-entered statuses in a small table that includes the relevant booking reference. Then look up or reconcile the status using that reference. If you are relying on a timestamp or email as a key, first check whether it can repeat or be missing. A unique registration reference is easier to use if your workflow already provides one.
Check incoming rows against the report
Suppose you counted session choices through row 50 during testing. Add a sample beyond that row or review the reporting range before launch. Use a range that captures new submissions and handle blanks explicitly. Test the summary again when a new question is added, an answer choice is renamed, or the destination changes. A connected response tab can be working even when the summary is still reading yesterday’s range.
Previous section · Back to contents · Next section
Edit the form while people are using it
Work out whether a change affects collection, reporting or both. Fixing a spelling mistake in instructions is a different change from replacing a multiple-choice question or changing which session names respondents can select. Preserve a dated copy of the question wording and choice list if you need to compare data across versions.
For example, if a registration changes “Saturday morning” to “Saturday 10 am”, compare the existing values and the new test row. Decide whether your report should combine the two labels, treat them as different sessions or show them in a transition column. Take that decision before relying on the totals. An exact text count can quietly split one real-world category into two.
Manage a switch between two collection periods
Record the cutoff you used, who owns the destination and what happened to any submissions made during the change. Save a date-stamped snapshot where the organisation normally keeps its records if the team needs to reproduce its end-of-period totals. Use the new link from the form editor when you check the connection and the respondent link when you test the next submission.
If people continue to use an old respondent link, check whether the old form is still accepting submissions and which spreadsheet it points to. A new destination for one form does not redirect submissions sent to another form.
Previous section · Back to contents · Next section
Troubleshoot missing or unexpected responses
A submission appears in Forms but you cannot find it in Sheets
Open the destination directly from the Responses tab. Compare the full file title and the response tab with the sheet you had open. Check whether the row is hidden or outside the currently visible filter view. Look for the timestamp and the test marker. If the workbook is open on a dashboard tab, switch to the raw intake before concluding that the connection failed.
If the destination has been unlinked, new responses will stop going to that spreadsheet. Decide whether to reconnect and test with a new submission. When checking a gap, compare timestamps from Forms and the sheet around the unlink and reconnect times. Check what has already appeared before copying anything manually, so the same response is not counted twice.
A row appears in Sheets but the report total is wrong
Trace a single submission from its raw answer to the report. Check the referenced tab and column, the last row included, the reporting period and the rule for blanks. Examine the exact answer text for a renamed option or an unexpected leading or trailing space in a free-text field. Compare the count with a short filtered list of the matching rows.
A respondent cannot open the form or a colleague cannot open the sheet
Ask which link the person is using and which account they are signed in with. A link to fill in a form, a link to edit the form and a link to open the spreadsheet serve different jobs. Review access on the relevant file. Avoid broadening spreadsheet sharing just to let more people answer a form.
Previous section · Back to contents · Next section
Unlink and hand over the response file
In the form editor, open Responses, then the More menu, then Unlink form. Confirm the change. Google says the existing spreadsheet data stays in place, while new submissions stop going to that destination. Check the status of collection separately if you are also closing the form to respondents. Give the reporting team the cutoff and identify any downstream report that should stop refreshing.
Forms and linked spreadsheets are separate files in Drive. Google’s help also notes that collaborators on a form get access when a new response spreadsheet is created, while later permission changes do not automatically synchronise. When someone leaves the team, inspect the sharing settings on both files and on any separate report. If access came from a group or shared location, check that route as well.
Write a handover someone can use
Record the names and links of the form, response spreadsheet and report. Identify the respondent link and the place to inspect incoming submissions. State who can approve access, how test rows are identified and who is responsible for investigating a missing response. Have the new owner submit a sample and talk through where they would look if the report stayed unchanged.
Previous section · Back to contents · Next section
Walk through a school club registration
A club adviser wants students to choose a practice slot. Two organisers need the submitted details, while other helpers only need headcounts. The adviser builds the form, links a new spreadsheet and checks its sharing. An organiser sets up a separate headcount report for the helpers. The team tests the respondent route with a student account that meets the form’s access settings.
The first test picks Friday. The raw sheet shows the response with its timestamp. The organisers check that the report counts Friday once for the test dataset. They repeat with a Saturday choice and an optional field left blank, then compare the two rows with the expected counts. This tells the team whether the form accepts the intended audience, whether the sheet receives the answers, and whether the report treats blanks correctly.
On opening day, they share the responder link. At the end of the day they compare the last response in Forms with the last raw intake row and check the total by session. The helpers can use the headcount report without seeing the details they do not need for room setup.
Previous section · Back to contents · Next section
Build a small reconciliation check for launch day
Before launch, agree on which submissions belong to the opening period. For a fictional club form with Saturday and Sunday options, use four controlled responses on a test form. Enter two Saturday choices and one Sunday choice, then submit a fourth answer using an allowed optional field left blank. Set an expected outcome for that fourth response based on the session it selected. The number of submissions should match in the form editor and the raw intake. The number of valid choices in the report should also match the intake for each option.
Next, simulate a renamed choice on the test form. Submit a response using the new label and observe which category the report places it in. If the two labels represent one session, record the mapping in a reference table or update the report’s counting logic and rerun the totals. Check one line manually. Counting is simplest when every reported category has a clear mapping and every unresolved value has somewhere visible to go.
Keep a minimal launch note
Write down the current destination, the timestamp of the test, and what you expected in the form editor, the raw sheet and the report. If a teammate finds a mismatch next week, they can check those three places in order. Compare a known submission with the nearest rows before changing formulas or reconnecting the form.
Previous section · Back to contents · Frequently asked questions
Frequently asked questions
Can I connect a form to a spreadsheet I already use?
Yes. Choose Select existing spreadsheet and select the file. Check where the new response tab appears and review the workbook’s current audience.
Will unlinking erase the responses already in Sheets?
The existing spreadsheet data stays in place. New responses stop going to that spreadsheet until you connect a destination again.
Can I share the form without sharing its spreadsheet?
Yes. The respondent link is separate from the spreadsheet link. Check the form’s responder access and the spreadsheet’s sharing settings independently.
Can I use the response sheet as a dashboard?
A separate tab is easier to maintain if the readers are the same. Use a separate file if the dashboard audience needs less information than the response file contains.
How do I know the connection works?
Submit a clearly labelled sample through the actual responder route, find its timestamp and answers in the linked sheet, and confirm any report reflects it as intended.
Helpful reading
- Google Forms Help on choosing and unlinking a response destination
- How to Create and Share a Filter View in Google Sheets
- How to Protect Cells and Lock Formula Columns in Google Sheets
- How to Create a Pivot Table in Google Sheets
- How to Share a Google Drive File Without Access Problems
Check the path before you share the form
Open the responder link, submit one sample and follow it from Forms to the raw response table and then to the report. That gives you a clear starting point if something looks different once real submissions arrive.