DEV Community

Cover image for How to Duplicate any Google Form
Vryntel
Vryntel

Posted on

5

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)

Eliminate Context Switching and Maximize Productivity

Pieces.app

Pieces Copilot is your personalized workflow assistant, working alongside your favorite apps. Ask questions about entire repositories, generate contextualized code, save and reuse useful snippets, and streamline your development process.

Learn more