Share Google Sheet Files on Copy Mode

How do you normally share Google Sheet files? Possibly you are sharing Google sheet files in edit mode or view mode. Wait! There is one more option to share Google Sheet files. You can share Google sheet files in copy mode. Something similar to force copying instead of editing. Yup! What’s this copy mode is about? It’s none other than sharing Google sheet files with a friends or colleagues in copy mode. The person with the Google Sheet copy mode file link can only copy the file. No view mode or edit mode. The person with the link asked to copy the file.

Now the question. How to Share Google Sheet file link in Copy Mode?

Before coming to this Google Sheet tip, let us have a look at what other sharing methods are.

  1. Edit Mode: You are giving permission to make changes to your Google Sheet file, accept or reject suggestions, and also share the file with others.
  2. View Mode: Yup! It’s just the sharing mode with view only permission. The person with the link can only view the file but can’t even share the file.
  3. Comment Mode: This mode is not a popular sharing option. This allow the person with the link to make comments and suggestions. That’s all.

Now our Custom Sharing Mode in Google Sheets. This mode will force the person with the link to copy the file. This mode is not a Google Sheet default sharing option.

How to activate copy mode in Google Sheets? Follow the below steps.

  • Open the file which you want to send with copy mode.
  • Edit the URL as below.

Copy Mode Sharing in Google Sheets

Done! Now share this link. The person with link will ask to copy the file. This way you can share Google Sheet files in copy mode.


Please enter your comment!
Please enter your name here