How to Duplicate any Google Form

vryntel

Vryntel

Posted on January 29, 2024

How to Duplicate any Google Form

Unlike Google Sheets, Google Form doesn't offer a direct way to make a copy of a public Google Form, without being an owner or a collaborator of the form itself.

As a work-around you can use the FormDuplicator tool, that is a Google Spreadsheet bounded with a Google Apps Script that can clone every public Google Form.

Image description

FormDuplicator spreadsheet:
https://docs.google.com/spreadsheets/d/1nYBfvTkIWfmBFhnaNFrDDQh5m_9GJ0m0xHPbqVQhfD4/copy

Github page:
https://github.com/Vryntel/FormDuplicator

After making a copy of the spreadsheet, to be able to run the script you need to grant permission to the script (only the first time) by following these steps:

  • In the Spreadsheet page, go in the top toolbar and click Extensions > Apps Script
  • After the new page will open up, return in the spreadsheet page and in the top toolbar it will show up the FormDuplicator option
  • Click on the FormDuplicator option in the toolbar, and then click on "Duplicate Form"
  • At this point Google will ask your authorization to run the script, you need to grant it

Now to clone a Google Form, just paste the form url in the "Form to duplicate" field and then go to the top toolbar, FormDuplicator, Duplicate Form.

After the script will finish its execution, a pop-up will show up with a message:

  • "Form Duplicated correctly": The form has been duplicated exactly as the original form. Your copy of the Google Form will be printed in the "Generated Form" field;

  • "Form Partially duplicated": The form has been duplicated but without some propeties. All the not duplicated proprieties will be displayed in the "Not duplicated" worksheet;

For the list of what the tool can't duplicate from a form, check my Github page:
https://github.com/Vryntel/FormDuplicator

  • "Error": If some values are missing in the settings worksheet or an unexpected error has occured;

Thank you for reading.

💖 💪 🙅 🚩
vryntel
Vryntel

Posted on January 29, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

How to Duplicate any Google Form
javascript How to Duplicate any Google Form

January 29, 2024