How to Add Templates to Google Sheets

Katherine Jul 11, 2026

Ever found yourself wishing you could apply a consistent format to multiple Google Sheets? Or perhaps you've wanted to create a reusable layout for reports? Enter Google Sheets templates - a powerful tool that can save you time and ensure consistency across your spreadsheets. Let's dive into how to add a template to Google Sheets.

How to Use Google Sheets Like a Pro
How to Use Google Sheets Like a Pro

Before we begin, ensure you're using the latest version of Google Sheets. If you're not, you can update your Google Sheets by clicking on your profile picture in the top-right corner, then 'Update Google Sheets'.

How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet

Creating a Template

First, let's create a template. A template is essentially a Google Sheet that you can reuse and apply to new spreadsheets.

Struggling to add Alternating Colors in Google Sheets
Struggling to add Alternating Colors in Google Sheets

To create a template, open Google Drive, click on 'New' in the top-left corner, then 'Google Sheets'. Name your new sheet something like 'My Template'.

Designing Your Template

Create Your Own Weekly Planner with Google Sheets: Easy Tutorial & Tips
Create Your Own Weekly Planner with Google Sheets: Easy Tutorial & Tips

Now, design your template. This could be a simple layout with headers and columns, or a complex dashboard with charts and graphs. Remember, anything you include in your template will be replicated in every new sheet you create from it.

To make your template even more useful, you can include instructions or notes. For example, you might add a note to explain what each column is for, or provide instructions on how to use the sheet. To add a note, click on the cell where you want the note to appear, then click on 'Insert' in the menu, and select 'Note'.

Saving Your Template

Google Sheets Weekly & Monthly Schedule Templates
Google Sheets Weekly & Monthly Schedule Templates

Once you're happy with your design, it's time to save it as a template. Click on 'File' in the menu, then 'Template description'. In the pop-up window, give your template a name and a description. You can also choose whether to make your template public or private.

Finally, click 'Save' to create your template. It will now appear in the 'From a template' section when you create a new Google Sheet.

Using a Template

How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier

Now that you've created your template, let's use it to create a new Google Sheet.

To use a template, open Google Drive, click on 'New' in the top-left corner, then 'Google Sheets'. In the pop-up window, click on 'From a template'. You'll see a list of your saved templates, as well as any public templates you have access to.

GOOGLE SHEETS MUST KNOWS: 3 WAYS TO INSERT IMAGE IN SPREADSHEETS
GOOGLE SHEETS MUST KNOWS: 3 WAYS TO INSERT IMAGE IN SPREADSHEETS
How to use Google Sheets with Elementary Students
How to use Google Sheets with Elementary Students
Google Docs Free Checklist Template
Google Docs Free Checklist Template
How to Make an Assignment Tracker Template in Google Sheets Using AI
How to Make an Assignment Tracker Template in Google Sheets Using AI
Google Sheets Checklists
Google Sheets Checklists
Google Sheets Tutorial: How to Open a Spreadsheet
Google Sheets Tutorial: How to Open a Spreadsheet
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
Google Sheets Customization Tips ✨ Make Your Spreadsheets Beautiful & Functional
Google Sheets Customization Tips ✨ Make Your Spreadsheets Beautiful & Functional
How to Create a Template in Google Docs
How to Create a Template in Google Docs
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
Add Custom Colors to Google Docs, Slides, and Sheets
Add Custom Colors to Google Docs, Slides, and Sheets
How to Insert Special Characters in Google Sheets
How to Insert Special Characters in Google Sheets
Free Spreadsheet Templates for Excel & Google Sheets
Free Spreadsheet Templates for Excel & Google Sheets
How to Add and Sum in Google Sheets
How to Add and Sum in Google Sheets
Google Sheets Weekly & Monthly Schedule Templates
Google Sheets Weekly & Monthly Schedule Templates
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
Google Sheets: 3 Add-Ons to Try - Teacher Tech with Alice Keeler
Google Sheets: 3 Add-Ons to Try - Teacher Tech with Alice Keeler
How to create progress bars in Google sheets
How to create progress bars in Google sheets
How to Add Error Bars in Google Sheets
How to Add Error Bars in Google Sheets
Google Sheets Budget Tutorial: Master Your Finances Easily!
Google Sheets Budget Tutorial: Master Your Finances Easily!

Applying the Template

Find the template you want to use, then click on it. This will open a new Google Sheet based on your template.

You can now start adding data to your new sheet. Remember, anything you change in this sheet will not affect the original template. If you want to make changes to the template, you'll need to do that in the original Google Sheet, then save it as a new template.

Renaming and Customizing Your Sheet

Once you've added data to your new sheet, you might want to rename it. Click on the sheet's name at the bottom, then type in your new name.

You can also customize your sheet further by adding or removing sheets, changing the theme, or adjusting other settings. To do this, right-click on the sheet's name, then select 'Spreadsheet settings'.

And there you have it! You've now learned how to add a template to Google Sheets. Whether you're creating reports, tracking projects, or planning events, templates can save you time and ensure consistency across your spreadsheets. Happy templating!