0

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

1

Short answer

On the spreadsheet URL, replace /edit by /copy

Extended answer

The Google Sheets spreadsheet URL looks like the following

https://docs.google.com/spreadsheets/d/1aAKaVc-eUBwmwCFwX4q4vLtubDzE_81kOTWgbmz4FvU/edit#gid=0

Replace /edit and the following characters by /copy

https://docs.google.com/spreadsheets/d/1aAKaVc-eUBwmwCFwX4q4vLtubDzE_81kOTWgbmz4FvU/copy

0

Your Answer

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

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