Four ways to access Google Sheet Templates

Are you a Google Sheets novice? Does just the sound of the word ‘Sheets’ send shivers down your spine? That used to be me! Then I discovered ready made templates that gave me the confidence to dive into the world of cells and formulas.

Read on to find out about four easy ways to access Google Sheets templates.

Get started with #Google #Sheets by using a template. Click To Tweet


1.Google’s own inbuilt templates

When you create a new sheet there have been 2 options for a while now. Click on the ‘New’ button, hover over ‘Sheets’ and you see a little arrow. (You see this with Docs and Slides as well.)

When you click on the arrow you get the option of creating a blank spreadsheet or starting from a template.

Choose ‘From a Template’ and the template gallery will open. You’ll notice at the top there is a gallery with your domain name and a General gallery. This General gallery contains templates of a wide variety that have all been created by Google. There is an Education section, along with Personal, Work and Management sections.

Google Sheets has education templates ready and waiting for you. Click To Tweet


If you find a template that you want to use, you simply click on it and a new copy of it will be created in your Drive, wherever you were when you started making the new sheet.

All the formatting of the sheet will automatically be there, as will any formulas that were created within the template. Once you have created your own copy, you are free to edit it however you want.

If you have a Google Sheets junkie in your school, or an expert who loves formulas, they can submit a template to your school’s gallery for anyone else to use as well.

2. Install the Vertex42 Add-on for Sheets

Open up a new Google Sheet and click on ‘Add-ons’. Select ‘Get Add-ons’

The Add-ons dialogue box will open. Type in Vertex42 and add it.

Google will ask you to choose the account you want to add it to, and you will then need to allow the permissions it asks for. Once you have done that it will appear in your Add-ons menu.

Click on the ‘Browse Templates’ to view the available templates for you to use. A dialogue box will open with all the templates menu.

Again, the new sheet will be created where ever you were in your Drive at the point in time that you began the process. The sheet is completely editable, ready for you to personalise.

Use these #Google #Sheets Add-ons to increase the number of templates you have to use. Click To Tweet


3.Install the Template Vault Add-on for Sheets

Follow the same procedure as you did to install the Vertex42 Add-on, except this time you search for ‘Template Vault’ in the Add-on menu.

Install the Add-on the same way. Again, it will ask you to choose the account you want to use and to allow it the permissions it asks for.

Go to your Add-ons, select ‘Template Vault’ and its menu will launch.

You now have your own copy that you are able to edit however you want.

4.Convert an Excel template to a Google Sheet.

Microsoft Excel has a number of templates that are pre populated in the same way that Google Sheets does.

I came across this Excel timeline template that I wanted to use with my students. Within minutes I had it as a Google Sheet.

Download the Excel document to your device and then upload it where ever you want it in your Google Drive. You can do this by either using the ‘New’ then ‘Upload File’ options – or – simply dragging and dropping it into your Drive.

Once you have it in your Drive, click on it, but don’t open it. Go to your three dots on the right hand side and choose ‘Open with’ and then “Google Sheets’.

Excel spreadsheet templates easily convert to #Google #Sheets Click To Tweet


You will now have two versions in your Drive, the original Excel version and the new Sheets version. The new Google Sheets versions will usually retain all the features and formulas of the Excel version. Once I have converted mine, I then delete the Excel version as I no longer need it.

So there we are. Four easy ways to get yourself started with Google Sheets. Find yourself a template and dive into the world of cells and formulas – you may just find you like it!

For more tips and tricks about sheets check out Lara’s blogs here or here.

Why Doing One Thing is a Good Thing

What is potentially the most common phrase ever spoken by teachers?
“I’m just so busy! There’s never enough time.”
And they would be right. It can be a frantic job. That’s why doing just one thing might be just what is needed. Read on to see what I mean.

Multiple Desktops (1)

Multiple desktops allow you to multitask

Before laptops were common, when I was working on a project I would have several books open and many pieces of paper all on a big table. Nowadays we can have the same experience by using multiple desktops to multi task.


Google Sheets – Starter Tips

Google Sheets is a great tool for classroom teachers. It can help you increase your efficiency and organisation. If you’ve never used spreadsheets before they can be a little intimidating, but once you get started I’m sure you’ll realise how powerful Google Sheets really is. This blog post will give you five tips that I wish I’d known when I started using them.


Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to


Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...


Sign Up Now
To Get The Latest Updates