10 Powerful Google Sheets Templates for Schools in 2020

If you’re a school administrator or head, what administrative and academic goals do you have for your school this year 2020? Have you drawn any plan of action in realizing these goals?

This is 2020! If there is any great change we are going to witness in this new decade, beginning from 2020, it is the surge in the ‘technology of things’. Every area of human engagement and interactions would have a feel of it. 

For those of us in the education sector, the tech influence would be too overwhelming.

So, in your school goals, do you have any plan for edtech? It is a must have for your school this year. If you need help on how to go about it, read the post below:

Read this: 15 Recommended ICT Policy Statement for 21stcentury schools

You don’t need break the bank to implement edtech in your school. There are so many solutions you can have as a school, in the areas of administration, teaching and learning, just using Google tools.

In this post, I want to show you one of those powerful Google tools: Google Sheet.

Google Sheet is a spreadsheet package owned by Google Incorporated. If you know about Microsoft Excel, Google Sheet is its Google version, but with more powerful and better integrations.

Here, I show you 10 Google Sheets Templates you can kick-start your school edtech journey with. This post comes with graphics and two or three video tutorials to assist you.

Recommended Posts on Google Tools:

3 Best Google Tools for Classroom Assessment

Create Online Course with these 7 Google Tools

 5 Powerful Ways to Use Google Drive in Schools

 40 Edtech Solutions with Free Google Tools

Now. let's have a look at these Google Sheet templates:

Template 1: Daily Attendance Sheet

Take daily attendance of your students with this template. It also comes with a summary report of attendance.

Template 2: Class Daily Time Table

You need a class time table to regulate lesson periods. That's exactly what this template does for you.

Template 3: Grade Book

This template helps you grade your students' works- be it periodic assessment or terminal examinations It comes with both Individual student report and Overview of Data in Statistical representation

Template 4: TO DO List

You need this template to draw a comprehensive school calendar, either termly or for a session.

Template 5: Monthly Budget

You may not need a Financial accountant this time This template guides you in preparing your school annual or termly budget. It comes with analytical/summary report.

Template 6: Financial Statement

This template helps you prepare Profit & Loss Account, Balance Sheet and Overview of transactions. 

Template 7: Team Roster

With this template, you can schedule tasks with your team with a follow-up report. You could easily monitor progress being made.

Template 8: Invoice for Sales and Services

With this template, you have a customized invoice for every product sales and services your school enjoyed or executed.

Template 9: CRM- Customer Relationship Management

CRM is all about persons and companies you’re tracking for business deal, as well as opportunities for business scale up. This template is so designed to make CRM work easily for your school.

Template 10: Monthly Calendar with Notes

Mark your calendars with special notes to remember special events. You have a ready-made tool with this template


A lot of global changes is affecting the way we do things. The conventional system is about to be distrupted. This is the right time to start embracing the "technology of things"

You can start with these free Google tools. Just having a Gmail account is all you need to access all these free tools.


Watch these Videos to learn more

1. Create Attendance Register with Google Sheets

2. Create Class Time Table with Google Sheets


Want to learn more about "Google Tools for Education & Business"?  JOIN THIS CLASS!