Our company just created a new template for website planning. It is available as a Google sheet. We've also added instruction on how to create a copy for themselves. Like open the document, Go to File -> Make a Copy. However, we still get many requests asking for access.

Is there a way to automatically create a new copy for the user when he/she click on the link, instead of the view only file?

1 Answer 1


Short answer

On the spreadsheet URL, replace /edit by /copy

Extended answer

The Google Sheets spreadsheet URL looks like the following


Replace /edit and the following characters by /copy



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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