DEV Community

Cover image for How to Duplicate any Google Form
Vryntel
Vryntel

Posted on

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.

Top comments (0)