Link a Google Form to Google Sheets — Including an Existing Sheet

Updated November 11, 2026 · ~8 min read

"link google form to google sheets" is one of the most common Google Forms tasks, and the built-in way takes about three clicks. The confusion starts with the second question: can I link it to an existing sheet? Yes — but with rules. This guide covers the standard setup, linking to a spreadsheet you already have, the one-sheet-per-form limit, unlinking and relinking, and the important thing a linked sheet does not contain.

Key rule: One form writes to one response sheet at a time. A linked sheet holds submitted answers (Timestamp + one column per question). It does not hold the question structure, options, answer key, points or images.

Link a Google Form to a new Google Sheet in 3 steps

Open the form in edit mode and go to the Responses tab.
Click the green Google Sheets icon (top right of the Responses panel).
Choose Create a new spreadsheet, give it a name, click Create.

The sheet opens with a Timestamp column and one column per question. From then on, every submission appends a row automatically. That is the answer to "can you link google forms to google sheets" — yes, natively, no add-on needed.

Link a Google Form to an existing Google Sheet

This is what link google form to existing google sheet and how to link my google form to google sheets usually mean. Two cases:

The existing spreadsheet is in the same Google account and you just created it — in the green Sheets icon dialog, choose Select existing spreadsheet and pick it. Google adds a new tab (e.g. Form Responses 1) for the responses.
The sheet is older or in another account — Google Forms can only link to spreadsheets your account can edit. If the picker does not show it, copy the sheet into your Drive first, or use IMPORTRANGE from the linked response sheet into your master workbook.

Note the tab behaviour: linking writes to a new tab inside the spreadsheet, not into your existing columns. If you need the answers in a specific tab with your own header row, point your formulas at the Form Responses 1 tab with ='Form Responses 1'!A1:Z or an ARRAYFORMULA / QUERY.

How to link a Google Form to Google Sheets in 5 steps

Unlink, relink, and the one-sheet rule

A form can have only one linked response sheet. To change it:

Responses tab → More (three dots) → Unlink from Sheets (or the small Sheets icon → Unlink).
Then click the green Sheets icon again and choose a new or existing spreadsheet.

Important: unlinking does not delete the old sheet, and responses collected while unlinked are still stored in the form — they will appear when you link again, or you can download them as CSV. Also note google form responses to different sheets is not supported natively; route data with QUERY or IMPORTRANGE instead.

What a linked sheet does not contain

The response sheet has answers, not the quiz. It has no answer key, no points, no question types, no option list, and no image URLs. So if your goal is to grade in Sheets, edit the quiz in a spreadsheet, or re-use the questions elsewhere, you need a separate export of the question structure — see Google Form to Google Sheets (quiz structure).

For raw data portability use Export Google Form to CSV; for refreshing an .xlsx automatically see Google Form to Excel Automatically.

Troubleshooting the link

New columns not appearing. Adding a question adds a column, but existing rows keep empty cells in it. Refresh the sheet and check the far-right columns.
Timestamp format. Google writes a locale-formatted datetime; wrap with VALUE() or set the column format explicitly before charting.
Responses stopped arriving. Someone may have unlinked the sheet, or the form was duplicated (the copy has its own link).
Permission errors. The linked sheet must remain editable by the form owner. Transferring ownership or moving it to a shared drive can break the link.
Deleted rows come back or formulas get overwritten. Never insert your own columns into the response tab. Put calculations in a separate tab that references it.

Open the Responses tab

In the form editor, switch from Questions to Responses.

Click the green Sheets icon

Top right of the Responses panel.

Choose new or existing

Create a new spreadsheet, or select an existing one you can edit.

Check the response tab

A new tab (Form Responses 1) receives Timestamp + one column per question.

Build on a separate tab

Keep grading formulas, charts and lookups off the raw response tab.

Frequently asked questions

Can you link Google Forms to Google Sheets?

Yes, natively. Open the form, go to the Responses tab, click the green Google Sheets icon, and create or select a spreadsheet. Every new submission then appends a row automatically.

How do I link a Google Form to an existing Google Sheet?

In the green Sheets icon dialog, choose 'Select existing spreadsheet' and pick a file your account can edit. Google adds a new response tab to it rather than writing into your existing columns. If the file is in another account, copy it to your Drive or use IMPORTRANGE from the linked sheet.

Can one form send responses to different sheets?

Not natively — a form links to one response sheet. To split data, keep the single linked sheet as the source and use QUERY, FILTER or IMPORTRANGE to feed other tabs or spreadsheets.

What happens if I unlink the sheet?

The old spreadsheet is not deleted, and submissions keep being stored in the form. When you relink, or when you download responses as CSV, the collected answers are still there. Only the live writing stops while unlinked.

Does the linked sheet include the answer key and points?

No. It contains a Timestamp and the submitted answers only. To grade in Sheets you need a separate export of the question structure with correct answers and marks, then join it to the responses.

Google Form converters

ExamParser has a dedicated page for each export format. Use the one that matches the file you need — Word for an editable document, PDF for a fixed archive copy, CSV for raw data, Excel for a working spreadsheet, and Google Sheets for a live linked sheet.

GGoogle Form to Word(.docx) GGoogle Form to PDF GGoogle Form to CSV GGoogle Form to Excel GGoogle Form to Google Sheets

Related guides

Get the full picture, not just the responses

A linked sheet is great for live answers, but it has no answer key or question bank. Export the structured quiz too — questions, options, answers and points intact — so you can grade, edit and reuse it. No AI rewriting.

Open the Google Form to Word converter →