9

Is it possible to craft a URL (or bookmarklet) so that when clicked it opens a fresh "copy" of an existing Google Docs or Sheets?

Apparently it used to be possible by appending &newcopy=true to the end of the URL, but this doesn't appear to work any longer.

Is there a new method?

9

Just change /edit in the end of the link to /copy.

Before:

... B3iw8gTpKwAW8/edit

After:

... B3iw8gTpKwAW8/copy
  • 2
    Add more details like the /copy URL will take the user to a page asking to confirm that the user want to create a copy. – Rubén Jun 18 '15 at 22:20
2

I'm not sure if there is a supported way to handle this or not, but I was able to get this to work with a little hackery.

From the Google Doc that you want to make the copy link for:

  • Click the File drop down
  • Click the Make a copy... option
  • Click the OK button
  • When the new window pops up, quickly copy the initial URL before it redirects to the copied document. This is the link you want.

From there, I removed the &token URL parameter, and the rest should be self explanatory and can be adjusted as necessary: &copyComments, &copyCollaborators, and &title.

Obviously, the user who is trying to make the copy needs the appropriate privileges in the sheet to do so.

1

Possibly it should work in this way in new sheets!

Goto Share then, get Share able Link. Using the link, you can customize and get that a non-editable/comment able. Then the shared user can create a copy of it/new sheet with the copy.

I understand this may not be the real use case we're using previously. However, it helps me at times.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.