How to Reuse a Google Form

Collecting valuable data with a Google Form is made even better when you don’t need to recreate the wheel each and every time you have a new event, project or cohort of colleagues or students. Or perhaps you see a form that someone’s shared with you that you’d like to repurpose.

Well, there’s good news! There are several different options for reusing a Google Form. Read on for how to pick the best option to suit your situation.

Google Form Reuse Options & When to Use Them

There are four ways you can reuse an existing Google Form to collect new data. Here’s a summary of each option and when to use them. Scroll down further for step-by-step instructions for implementing each option.

1. Make a copy of the form 
This option creates a brand new copy of the form, completely separate from the original form and its associated response spreadsheet. Use this option if you want to retain the existing data in both the original form and its associated spreadsheet. This is also the best option to use if you want to make modifications to the original form or use a form that someone else has shared with you.

2. Link the form to a new spreadsheet
This option allows you to retain the original form responses in the original spreadsheet and collect new responses in a new spreadsheet. However, the original responses will need to be deleted from within the form (this doesn’t remove them from the spreadsheet). Use this option if you want to retain a record of the original responses only in spreadsheet format. 

3. Remove existing responses from the form & the spreadsheet
This option involves deleting all existing responses from both the form and its associated spreadsheet. You can then reuse the same form and spreadsheet to collect a new set of responses. Only use this option if you don’t want to retain the original responses.

4. Use the FormRecycler add-on to reuse form questions
FormRecycler is a Google Forms Add-on that allows you to copy questions from one Google Form to another. You could use this to copy questions from your existing form to a new one. Use this option if you want to retain the existing form and its data as is, and build a new form that has similar questions.

Option 1: Make a Copy of the Form

Use this option to create a brand new copy of the form, completely separate from the original form and its associated response spreadsheet. 

Note: You need to have edit access to the form to make a copy.

1. Open the form.

2. Click the three dots in the top right corner and choose Make a copy from the menu.

3. Enter a name for the new form and select a location to save it in Google Drive. Click OK.

Option 2: Link the Form to a New Spreadsheet

Use this option to retain the original form responses in the original spreadsheet and collect new responses in a new spreadsheet. 

1. Open the form.
2. Click the Responses tab.
3. Click the three dots at the top right of the responses tab.

4. Choose the Unlink form option.

5. Click Unlink to confirm the process.

6. Click the Create spreadsheet button (little green Google Sheets icon).

7. Ensure the Create a new spreadsheet option is selected and edit the name of the spreadsheet to reflect your new use (if you do not do this, the new spreadsheet will have the same name as the existing one, which is likely to be confusing!).

8. Click Create. All new responses will now go to the new spreadsheet.

Option 3: Remove Existing Responses from the Form & the Spreadsheet

Use this option to delete all existing responses from both the form and its associated spreadsheet so you can reuse both.

1. Open the form.
2. Click the Responses tab.
3. Click the three dots at the top right of the responses tab.

4. Choose the Delete all responses option.

5. Click OK to confirm the deletion.

6. Open the spreadsheet that is linked to the form.

Tip: You can do this by clicking the small green spreadsheet button on the Responses tab.

7. Highlight all the rows that contain the form submissions. Make sure that you select the entire row, not just the data within the row.

Tip: To select an entire row, left click on the row number. To select multiple rows, left click on the first one and keep the mouse button clicked while dragging the cursor down.

8. Right-click the highlighted rows, then choose the Delete rows option.

The spreadsheet should now be empty and ready for the new form submissions. 

Option 4: Use the FormRecycler Add-On to Reuse Form Questions

Use this option to copy questions from your existing form to a new one.

1. Create and name a new Google Form.

2. Click the three dots in the top right corner and choose Add-ons from the menu.

3. Search for ‘FormRecycler’ in the search box (top right corner).
4. Locate the Add-on and then click the Free button to begin installing it.

5. Select the Google account you want to use with the Add-on, then click Allow to give FormRecycler the permissions it needs to function.

6. Click the puzzle piece button at the top of the form and choose ‘FormRecycler’ from the list.

7. Click Recycle Form Questions to get started.

8. Select the form that you want to use your questions from (i.e. the original form).

9. Tick the questions you want to add to your form, then click Insert Questions.

Related Post

Great Ways to Use Nearpod at the Start of the Year

Nearpod Orientation  A great starting point for Nearpod in the classroom is to allow students to get hands on with the tool. This can be done as a whole class session or independently. I recommend this lesson being completed live in the whole class or within small group sessions. There are many pre-made orientation lessons

VIEW POST

Popular Post

Great Ways to Use Nearpod at the Start of the Year

Nearpod Orientation  A great starting point for Nearpod in the classroom is to allow students to get hands on with the tool. This can be done as a whole class session or independently. I recommend this lesson being completed live in the whole class or within small group sessions. There are many pre-made orientation lessons

VIEW POST

Setting up your Microsoft Class Teams for 2023

4 steps to getting your 2023 Class Team set up in the blink of an eye The end of the school year is looming and you are keenly aware that you don’t want to spend your summer holidays setting up for the new school year. We’ve all been there so follow these 4 steps to

VIEW POST

ChatGPT is Freaking Me Out: Teacher Edition

ChatGPT is one of the biggest technology revelations we have seen in recent times, and we are all wondering how this will impact us. From students and school teachers to businesses and writers, everyone is finding a good use for ChatGPT. Our UTB team love new and exciting tech, and we are using ChatGPT in

VIEW POST

Here’s What
Our Clients Say

How well do you use the
Apple Apps Google Workspace Microsoft 365
tools in your workplace?

Find out if you’re working with the tools OR if you’ve got the
tools working for you.

Download your skills checklist to see how you score...

Country:

Choose Industry:

Which Skills Checklist?

 

Nice Move Allstar!
You're about to get
awesome value in your
inbox that's going to make
life that little bit easier & sweeter!

 

Are you at a beginner, intermediate, or advance level?

This skill checklist will help you find out.

We will only send you awesome stuff!
Privacy Policy

Privacy Policy

Using Technology Better Privacy Commitment

Introduction

We hold the privacy of your personal information in the highest regard.

Using Technology Better regards customer privacy as an important part of our relationship with our customers. The following privacy policy applies to all Using Technology Better users, and conforms to Internet privacy standards.

This policy will be continuously assessed against new technologies, business practices and our customers’ needs.

If you have questions or concerns regarding this statement, you should first contact the support team on our Contact Us Page.

Collection of Information

In order to use the Using Technology Better website, we may require information from you in order to provide the best service possible.

All correspondence may also be collected and stored, particularly in regard to sales, support and accounts, including Email.

Any information collected by Using Technology Better is collected via correspondence from you or your company. This may be via the telephone, Email, mail, fax or directly through our website.

Visitors and customers of japan.usingtechnologybetter.com will have their information shared back to DAIWABO INFORMATION SYSTEM CO., LTD. and DIS Service & Solution Co., Ltd.

Use of Collection Information

Any details collected from Using Technology Better customers is required in order to provide you with our

products and/or services, and a high level of customer service.

Correspondence is recorded in order to provide service references, and to assist in our staff development.

Web Site Use Information

Similar to other commercial Web sites, our Web sites utilize a standard technology called “cookies” (see explanation below, “What Are Cookies?”) and web server log files to collect information about how our Web site is used.

Information gathered through cookies and Web server logs may include the date and time of visits, the pages viewed, time spent at our Web site, and the Web sites visited just before and just after our Web site.

Storage of Collected Information

The security of your personal information is important to us. When you enter sensitive information (such as credit card numbers) on our website, we encrypt that information using secure socket layer technology (SSL).

When Credit Card details are collected, we simply pass them on in order to be processed as required. We never permanently store complete Credit Card details.

We follow generally accepted industry standards to protect the personal information submitted to us, both during transmission and once we receive it.

If you have any questions about security on our Website, you can email us at <ContactEmail>.

Access to Collected Information

If your personally identifiable information changes, or if you no longer desire our service, you may correct, update, delete or deactivate it by emailing us at <ContactEmail>.

Orders

If you purchase a product or service from us, we may request certain personally identifiable information from you.

You may be required to provide contact information such as:

Name

Email

Postal address

Your school or organisation

Financial information (such as credit card number, expiration date, name on card, card billing address).

We use this information for billing purposes and to fill your orders. If we have trouble processing an order, we will use this information to contact you.

Communications

Using Technology Better uses personally identifiable information for essential communications, such as

Emails

Accounts information

Critical service details.

We may also use this information for other purposes, including some promotional Emails.

If at any time a customer wishes not to receive such correspondence, they can request to be removed from any mailing lists by contacting support.

You will be notified when your personal information is collected by any third party that is not our agent/service provider, so you can make an informed choice as to whether or not to share your information with that party.

Third Parties

Using Technology Better may at its discretion use other third parties to provide essential services on our site or for our business processes.

We may share your details as necessary for the third party to provide that service.

These third parties are prohibited from using your personally identifiable information for any other purpose.

Using Technology Better does not share any information with third parties for any unknown or unrelated uses.

What Are Cookies?

A cookie is a very small text document, which often includes an anonymous unique identifier. When you visit a Web site, that site’s computer asks your computer for permission to store this file in a part of your hard drive specifically designated for cookies.

Each Web site can send its own cookie to your browser if your browser’s preferences allow it, but (to protect your privacy) your browser only permits a Web site to access the cookies it has already sent to you, not the cookies sent to you by other sites.

Browsers are usually set to accept cookies. However, if you would prefer not to receive cookies, you may alter the configuration of your browser to refuse cookies.

If you choose to have your browser refuse cookies, it is possible that some areas of our site will not function as effectively when viewed by the users.

A cookie cannot retrieve any other data from your hard drive or pass on computer viruses.

How Do We Use Information We Collect from Cookies?

As you visit and browse our Web site, the site uses cookies to differentiate you from other users. In some cases, we also use cookies to prevent you from having to log in more than is necessary for security.

Cookies, in conjunction with our Web server’s log files, allow us to calculate the aggregate number of people visiting our Web site and which parts of the site are most popular. This helps us gather feedback to constantly improve our Web site and better serve our clients.

Cookies do not allow us to gather any personal information about you and we do not intentionally store any personal information that your browser provided to us in your cookies.

Legal

We reserve the right to disclose your personally identifiable information as required by law and when we believe that disclosure is necessary to protect our rights and/or comply with a judicial proceeding, court order, or legal process served on our Website.

Links

Links on the Using Technology Better site to external entities are not covered within this policy. The terms and conditions set out in this privacy statement only cover the domain name of usingtechnologybetter.com

Changes to Privacy Policy

If we decide to change our privacy policy, we will post those changes to this privacy statement, and other places we deem appropriate so that you are aware of what information we collect, how we use it, and under what circumstances, if any, we disclose it.

We reserve the right to modify this privacy statement at any time, so please review it periodically. If we make material changes to this policy, we will not use the personal information you have submitted to us under this Privacy Policy in a manner that is materially inconsistent with this Privacy Policy, without your prior consent

Delivery Policy

Most goods are digitally delivered instantly via email.  Our services may be delivered either via an online medium or live in person.

For our online delivery see below.  For services delivered live onsite, please refer to our speaker agreement form which is emailed to you on confirmation of booking.

Refund Policy

We do not offer refunds or returns unless we cannot supply goods or services or the goods or services are not delivered as promised.

Australian law is the governing body for all work, goods and services supplied by Using Technology Better.

Marketing Release

Using Technology Better (UTB) may film, record, and photograph me (the results of which are the “Recordings”). UTB may also incorporate into any production(s) any separate content (e.g., quotes, testimonials, biographical information, profiles, photos, videos, sound recordings, artwork, etc.) I provide to UTB or approve in writing (“Materials”).

1.License

I grant to UTB an irrevocable, perpetual, worldwide, royalty-free license to, in its sole discretion, (i) edit, translate, and modify the Recordings and the Materials, (ii) attribute the Recordings and Materials to me by my name, age, and city and state of residence, (iii) incorporate the Recordings and the Materials into content to promote UTB, its programs, or products (“Content”), and (iv) publicly use, distribute, reproduce, create derivative works from, and perform/display the Content, and any excerpts thereof, in any language.

2. No Compensation.

I grant this permission without any financial or other obligation of any nature.

 

For any issues or concerns please contact us