keepcalculator

06 Numbers and Powers

Reuse Combine Google Forms? Quick Guide

Card No. 06·76820 · Updated · Standard formula, shown below

Yes, you can reuse a Google Form, but you cannot combine multiple existing Google Forms into one single form without manual copying. This article explains exactly how to reuse a form, how to merge questions from several forms, and what your options are for collecting responses in one place.

Background: How Google Forms Works

Google Forms is a free survey tool in Google Workspace. Each form is a separate file stored in your Google Drive, with its own set of questions, settings, and response spreadsheet. When you create a form, Google automatically generates a linked spreadsheet (if you choose the “Responses” tab > spreadsheet icon) where all submissions are collected. This structure means that there is no built-in “merge forms” button – the platform treats each form as an independent entity. However, you can copy a form (which duplicates all questions and settings) and you can manually move questions between forms using copy-paste or the “import questions” feature.

How to Reuse an Existing Google Form

Reusing a form is straightforward. You have two main paths:

  • Make a copy: Open the form, click the three-dot menu (⋮) in the top right, select “Make a copy,” and choose a name and location. This duplicates the entire form, including questions, settings, and theme. The copy starts with zero responses.
  • Use the same form again: If you want to collect responses for a new event or period, you can simply clear the old responses (Responses tab > three-dot menu > “Delete all responses”) and send the same link again. This works if you don’t need to keep the old data in the same spreadsheet.

If you want to keep old responses but start fresh, make a copy of the form and unlink the old response spreadsheet from the copy (Responses tab > three-dot menu > “Unlink form”). Then you can link a new spreadsheet.

How to Combine Questions from Multiple Forms

There is no one-click merge, but you can manually combine questions using these steps:

  1. Open the destination form (the one you want to keep).
  2. Click the “+” (Add question) button to create a blank question, or click the “Import questions” icon (the arrow into a square, usually in the right toolbar).
  3. Select the source form from your Drive, then choose which questions to import. You can select all or specific ones. Imported questions keep their original wording, but any images or videos are not copied – only text is imported.
  4. Repeat for each source form.

Alternatively, you can copy-paste questions manually: open the source form, click on a question, press Ctrl+C (or Cmd+C on Mac), then paste into the destination form. This works for individual questions, but you lose answer choices formatting if the question has options – actually, pasting usually preserves the question text and choices, but it’s safer to use “Import questions.”

How to Collect Responses in One Place

Even if you keep multiple forms, you can view responses in a single spreadsheet by linking each form to the same spreadsheet. Here’s how:

  1. Create a new Google Sheet (or use an existing one).
  2. Open your first form, go to the Responses tab, click the spreadsheet icon, and select “Create a new spreadsheet” or “Select existing spreadsheet.” Choose your target sheet.
  3. Repeat for the other forms, selecting the same spreadsheet. Each form will create a separate sheet (tab) within that spreadsheet.

This way, you have one file with multiple tabs, each containing responses from a different form. You can then use formulas or Google Apps Script to combine the tabs if needed, but that requires some technical skill.

Common Problems and Misconceptions

One common misconception is that you can “merge” forms without losing data. In reality, merging forms manually does not merge existing responses – it only combines the question structure. If you need to combine response data from old forms, you must export each form’s responses to a spreadsheet and then copy-paste the rows into one master sheet.

Another issue: when you import questions from another form, the imported questions do not bring over any “go to section based on answer” logic or validation rules. You must reapply those settings manually. Also, if the source form had images in questions, those images are not imported – only text.

Finally, if you delete a form that is linked to a spreadsheet, the spreadsheet remains, but the form is gone. Always make a copy before deleting if you think you might need the form again.

Alternatives to Combining Forms

If you need a single form with questions from multiple sources, the “Import questions” feature is the cleanest method. However, if you are trying to combine responses from multiple forms into one dataset, consider these alternatives:

  • Use one form with sections: Instead of multiple forms, create one form with multiple sections (click the “Add section” icon). This keeps all questions in one form and all responses in one spreadsheet.
  • Use Google Sheets to combine data: If you already have multiple response spreadsheets, you can use the QUERY function or Google Apps Script to pull data from multiple sheets into one master sheet. This is more advanced but gives you a single view without changing the forms.
  • Use a third-party add-on: There are add-ons like “Form Publisher” or “Form Approvals” that can merge responses, but they are not official Google tools and may have costs. Always check permissions before installing.

Costs and Limitations

Google Forms is free for personal use and for Google Workspace accounts. There are no costs for reusing or combining forms. The main limitations are:

  • No native merge function.
  • Importing questions loses images and formatting.
  • Each form can have at most 500,000 total responses (for free accounts) – but that is rarely a limit in practice.
  • You cannot combine forms across different Google accounts (e.g., a personal and a work account) into one form; you would need to manually copy questions.

Frequently Asked Questions

Can I merge two Google Forms into one without losing responses?

No. Merging forms only combines the question structure; existing responses stay in their original spreadsheets. To combine response data, export each form’s responses to a spreadsheet and copy-paste the rows into one sheet.

How do I copy a Google Form with all its settings?

Open the form, click the three-dot menu, choose “Make a copy,” and select a destination folder. The copy includes all questions, settings, and theme, but it does not include responses.

Can I import questions from a form that is not in my Drive?

No, the import feature only works with forms that you have access to (i.e., they are in your Drive or shared with you). If you have edit access, you can import; if not, you must ask the owner to share it.

What happens to the response spreadsheet when I copy a form?

The copy is not linked to the original spreadsheet. You will need to link a new spreadsheet (or the same one, but that would mix responses). It is best to create a new spreadsheet for the copy.

Is there a way to combine responses from multiple forms into one spreadsheet automatically?

Yes, you can use Google Apps Script to read responses from multiple forms and write them to a single sheet. This requires scripting knowledge, but there are tutorials available. Alternatively, you can use a third-party tool like Zapier, but that may have costs.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →