If it is for Google Workspace:
Here's what you can do if it's part of Google Workspace.
1.) From the Google Sheets Home Page (Sheets) -> select Template gallery
2.) Select your Organization Name. Then Submit Template
3.) Then select the Spreadsheet you want to make a template and select the category for it.
4.) It should then appear in the template gallery under your organization name. Here is also where the other users from your organization can access the template
If using personal Gmail accounts:
Otherwise, if you are only using personal Gmail accounts and want to share a template with other users I suggest the following workaround:
1.) Open the spreadsheet you want to make a template and add the word "Template" to its file name. (This is just so other users will not edit the actual file)
2.) Select the Folder Icon next to the filename
3.) Click new folder to create a folder which you will be sharing access for other users. Type a name for the folder, the name does not matter but I suggest you name it something like Google Sheets Templates or Custom Templates
4.) Move the Spreadsheet file to that folder.
5A.) Share the file to the other users and only allow for view access to prevent them from accidentally editing the original spreadsheet.
5B.) Or from your google drive you can share the access to other users to that Custom Templates Folder so they can access all templates you put in this drive folder.
6.) Manually make a copy of the file to use it as a template.
See below references for more info:
- Create Template - Workspace/Organization
- Create Template - Personal
there is nothing that says 'template gallery' - Google Docs Editors Community
Google Sheets Create Template - Stack Overflow
How to submit a template to the public gallery in Google Sheets?
Where do you get templates to get you started?
How to create a template in Google Sheets?
Can you download Google Sheet templates?
Are Google Sheets templates suitable for small businesses?
Videos
Hi everybody,
I have some very useful google sheets template, and want them to publish on the template gallery. But I could not figure it out how to submit them?
There're two tabs on the gallery: 1. My Gallery 2. General
I can submit any of my files to My Gallery. But I want to make them public on the General tab. I see some people doing this.
Do you have any idea?
Thanks a lot!