How To Make A Template In Google Sheets

In this tutorial, you will learn how to make a template in Google Sheets.

If you work in Google Sheets often, you’ll probably have spent time creating the same type of file repeatedly. This can be time-consuming and error prone, especially when large teams are involved. Instead of taking the time to manually recreate a spreadsheet, or create a duplicate and remove existing data, it’s often better to use templates. Fortunately, Google Sheets makes it easy to create your own templates that you can reuse yourself or share with your team to save everyone time.

Note: This feature is only available if your organization supports it. Contact your organization administrator for more info.

Submitting a Template

Before submitting your Google Sheets template, be sure you have the required permissions to change the sharing settings of the Google Sheet and that the file is not restricted from downloading

Step 1

Visit the Google Sheets home page https://docs.google.com/spreadsheets

Step 2

Click on the Template Gallery button in the upper right corner

Step 3

Click on the tab with your organization’s name to view all available templates

Step 4

Click on the Submit Template button

Step 5

Click on the Select Spreadsheet button and browse to the spreadsheet you want to make a template out of. Click on the spreadsheet and click Open to select it

Step 6

If you want to create a copy of the spreadsheet, check the checkbox, then choose a category to save the template under and click Submit

Step 7

Your template is now saved and available to others in your organization. To find and use your new template, follow steps 1-3 above to view the list of templates available to your organization. Click on the template to make a new copy of it

Summary

In this tutorial, I covered how to make a template in Google Sheets. Want more? Check out all the Google Sheets Tutorials.