How to Duplicate any Google Form
Vryntel
Posted on January 29, 2024
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.
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.
Posted on January 29, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.