One Way to Force Students to Save a Copy of Google Spreadsheet

I just came across this method of forcing a student to save a copy of a spreadsheet to their Google Drive. I tried it out today, and it works nicely and is very easy to do.  Here are some quick instructions, but visit Tammy Worcester’s site for a detailed explanation. Thanks to Tammy and follow her @TammyWorcester on Twitter. 

  1. Create a spreadsheet.
  2. Share the spreadsheet with “anyone with the link.”
  3. Go to and paste in the URL of the shared document.
  4. Add &newcopy at the end of the URL.

When you give the shortened URL to your students and they visit the page they see a message asking them, “Make a new copy of this document?”

The photo below makes Step 3 and Step 4 a bit clearer. Notice the &newcopy.

spreadsheet force copy

This is what the student sees:

make a copy


About Gail

Retired Technology Integration Specialist. I enjoy riding my bike, baking, and reading.
This entry was posted in Web 2.0. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s