How to Link a Google Form to Google Sheets (and Unlink It)

The summary charts in Google Forms are nice, but the real power comes when your responses flow into a spreadsheet. You can sort, filter, share with your team and build follow-up lists without copying anything by hand. Linking a form to Google Sheets takes a few clicks. Here's how to set it up, what happens to permissions, and how to unlink it without losing data.

Link your form to a spreadsheet

1. Open the form in Google Forms.
2. Click the Responses tab at the top, then Summary.
3. Click the three-dot More menu at the top right.
4. Choose Select destination for responses.
5. Pick Create a new spreadsheet or Select existing spreadsheet.
6. Click Create or Select.

Google says Sheets then puts your data in a table automatically, with formatting and structure, so it's easy to read straight away.

New spreadsheet or existing one?

Choose	When
Create a new spreadsheet	Most of the time; keeps each form's data tidy
Select existing spreadsheet	When you want several forms feeding one workbook, each on its own tab

Start from Sheets instead

You can also go the other way round. In Google Sheets, choose Tools, then Create a new form. Google says responses from a form created this way are saved in a new sheet in that spreadsheet. It's handy when you already work in the spreadsheet and want a quick way to collect data into it.

The permissions catch

Here's the detail that trips teams up. Google says that when you create a new response spreadsheet, the form's collaborators automatically get access to it. But later permission changes don't sync between the two. If you remove someone from the form, they can still open the spreadsheet unless you remove them there too. Whenever someone leaves a project, update both the form and the sheet.

Unlink a spreadsheet

1. In the form, click Responses, then Summary.
2. Click the three-dot More menu.
3. Choose Unlink form and confirm.

Google says new responses stop going to the spreadsheet, but the data already there stays put. You can relink later with Select destination for responses, so unlinking isn't a disaster if you change your mind.

Two files, two lives

Once linked, your form and spreadsheet are separate files in Google Drive. Google explains you can delete the spreadsheet without deleting the form, or delete the form and keep the spreadsheet. That's useful for archiving: keep the spreadsheet as a record and delete an old form you'll never use again.

Be careful in the other direction, though. Google warns that if you delete responses in the form, it can't be undone. The spreadsheet copy is a good safety net if you ever need to clear responses from the form itself.

Ideas for using your response sheet

• Filter sign-ups by date to see who registered this week.
• Add a column to mark who you've followed up with.
• Share view access with a colleague who handles bookings.
• Sort feedback by score to spot the happiest and least happy customers.

I add a Status column to every response sheet: New, Contacted, Done. It turns a list of answers into a simple to-do list that the whole team can see, and nobody has to ask who's dealt with which enquiry. A bit of conditional colouring on that column, green for Done and amber for Contacted, makes it even easier to scan at a glance.

Don't edit the columns Forms writes to

Add your own columns to the right of the response data rather than renaming or rearranging the ones Forms creates. Changing those can confuse things when new responses arrive. Your own notes and status columns are perfectly safe beside them.

Linking several forms to one workbook

If you run several forms for one project, such as a sign-up form and a feedback form for the same event, you can send both to the same spreadsheet by choosing Select existing spreadsheet. Each form gets its own tab, so the data stays separate but sits in one place. It's a tidy way to keep everything about one event together, and easier to share with a colleague than several separate files.

Very large forms

For forms that collect a huge number of responses, keep an eye on performance and consider starting a fresh form for each event or campaign. It keeps each spreadsheet manageable and easier to analyse. If you're turning responses into customer insight, my persona builder template is a great next step, and my guide on how to see responses on Google Forms covers the other views available.

My verdict

Responses, Summary, More, Select destination for responses, then create a new spreadsheet. Every new answer appears as a row automatically. Remember permissions don't sync, so update both files when people change, add your own columns to the right, and unlink without fear because existing data stays.

Frequently asked questions

How do I connect a Google Form to Google Sheets?

In the form, go to Responses, Summary, the More menu, then Select destination for responses and create or choose a spreadsheet.

Do old responses go into the spreadsheet when I link it?

Linking sets up a destination for responses; check the sheet after linking to confirm your existing answers are there.

What happens if I unlink a Google Form from Sheets?

Google says new responses stop going to the sheet, but existing data stays. You can relink later.

Who can see my Google Form response spreadsheet?

Form collaborators get access to a new response sheet automatically. Later permission changes need updating on both files.

Can I create a Google Form from Google Sheets?

Yes. In Sheets, choose Tools, then Create a new form. Responses save to a new sheet.